系統(tǒng)容災(zāi)應(yīng)急保障預(yù)案三分冊

XXX系統(tǒng)存儲容災(zāi)應(yīng)急保障預(yù)案三分冊卓望數(shù)碼技術(shù)（深圳）有限公司2008年7月目錄概述3現(xiàn)網(wǎng)存儲情況31. CX700存儲配置32. CX3-40F存儲配置3存儲數(shù)據(jù)恢復(fù)實施過程4概述本分冊適用于當(dāng)主用存儲EMC CX700存儲出現(xiàn)故障，同時現(xiàn)有的數(shù)據(jù)庫主機(jī)（XXX-dd01和XXX-dd02）也故障的情況下，采用容災(zāi)數(shù)據(jù)庫XXX-etl和容災(zāi)存儲 EMC CX3-40F來對整個存儲數(shù)據(jù)和業(yè)務(wù)的恢復(fù)和實施過程。現(xiàn)網(wǎng)存儲情況1. CX700存儲配置目前CX700中，用于XXX數(shù)據(jù)庫數(shù)據(jù)的磁盤是Lun1 Lun7以及Lun9-Lun10. 如下所示Lun NumberRAID TypeRAID Group Lun SizeSP Assigned1RAID101300GBA2RAID102300GBB3RAID10 1300GBB4RAID102300GBA5RAID10170GBA6RAID10270GBB7RAID101100MB9RAID104100GBA10RAID104200GBB1001RAID51300GBA1002RAID52300GBB1003RAID51300GBB1004RAID52300GBA1005RAID5170GBA1006RAID5270GBB1007RAID51100MB1009RAID54100GBA1010RAID54200GBB2. CX3-40F存儲配置目前CX3-40F中，用于XXX數(shù)據(jù)庫數(shù)據(jù)容災(zāi)的磁盤是Lun1 Lun7以及Lun9-Lun10. 如下所示Lun NumberRAID TypeRAID Group Lun SizeSP Assigned1RAID101300GBA2RAID102300GBB3RAID10 1300GBB4RAID102300GBA5RAID10170GBA6RAID10270GBB7RAID101100MB9RAID104100GBA10RAID104200GBB 存儲數(shù)據(jù)恢復(fù)實施過程當(dāng)主用存儲EMC CX700故障，容災(zāi)備用存儲CX3-40F將被激活，處于active狀態(tài)，同時現(xiàn)網(wǎng)數(shù)據(jù)庫主機(jī)（XXX-dd01和XXX-dd02）也故障，將采用容災(zāi)數(shù)據(jù)庫主機(jī)（XXX-etl），進(jìn)行數(shù)據(jù)和業(yè)務(wù)恢復(fù)。此時將實施容災(zāi)數(shù)據(jù)庫主機(jī)（XXX-etl）掛接到容災(zāi)備用存儲 EMC CX3-40F,此時數(shù)據(jù)庫主機(jī)和存儲架構(gòu)如下圖： 即：容災(zāi)數(shù)據(jù)庫主機(jī)（XXX_etl）+EMC CX3-40F，具體恢復(fù)實施步驟如下：在進(jìn)行恢復(fù)時可以直接使用每個步驟的內(nèi)容，進(jìn)行數(shù)據(jù)和業(yè)務(wù)恢復(fù)1) 把容災(zāi)存儲的LUN bind到容災(zāi)數(shù)據(jù)庫主機(jī)XXX_ETL上，2) 通過ioscan找到CX 3-40F上bind mirror卷命 令備注說明在XXX_ETL：上執(zhí)行#iosacn fnC disk 在XXX_dd01：上檢查mirror卷信息#insf e 安裝硬件信息路徑#powermt display dev=all #powermt config#powermt save檢查對應(yīng)的lun和WWWN信息3) 利用已經(jīng)備份好的vg map文件做對應(yīng)VG import命 令備注說明重建設(shè)備文件： XXX_ETL：mkdir vg_ora1 mkdir vg_ora2 mkdir vg_ora3 mkdir vg_ora4 mkdir vg_ora5 mkdir vg_ora6 mkdir vg_arch1 mkdir vg_lock mknod /dev/vg_lock/group c 64 0x100000 vg_lockmknod /dev/vg_ora1/group c 64 0x110000 vg_ora1mknod /dev/vg_ora2/group c 64 0x120000 vg_ora2mknod /dev/vg_ora3/group c 64 0x130000 vg_ora3mknod /dev/vg_ora4/group c 64 0x140000 vg_ora4mknod /dev/vg_ora5/group c 64 0x080000 vg_ora5mknod /dev/vg_ora6/group c 64 0x090000 vg_ora6mknod /dev/vg_arch1/group c 64 0x010000 vg_arch1mknod /dev/vg_arch2/group c 64 0x020000 vg_arch2重建設(shè)備文件導(dǎo)入vg信息:在XXX_ETL：vgimport -s -v -m /tmp/vgbak/vg_ora1.map /dev/vg_ora1vgimport s -v -m /tmp/vgbak/vg_ora2.map /dev/vg_ora2 vgimport s -v -m /tmp/vgbak/vg_ora3.map /dev/vg_ora3 vgimport s -v -m /tmp/vgbak/vg_ora4.map /dev/vg_ora4 vgimport s -v -m/tmp/vgbak/vg_ora5.map /dev/vg_ora5 vgimport s -v -m /tmp/vgbak/vg_ora6.map /dev/vg_ora6vgimport s -v -m /tmp/vgbak/vg_lock.map /dev/vg_lockvgimport s -v -m /tmp/vgbak/vg_arch1.map /dev/vg_arch1vgimport s -v -m /tmp/vgbak/vg_arch1.map /dev/vg_arch2重做vg的import4) 修改用戶權(quán)限命 令備注說明在XXX_ETL：chown -R oracle:dba /dev/vg_ora1/chown -R oracle:dba /dev/vg_ora2/chown -R oracle:dba /dev/vg_ora3/chown -R oracle:dba /dev/vg_ora4/chown -R oracle:dba /dev/vg_ora5/chown -R oracle:dba /dev/vg_ora6/chown -R oracle:dba /dev/vg_arch1/chown -R oracle:dba /dev/vg_lock/chown -R oracle:dba /dev/vg_arch2/修改用戶權(quán)限信息5) 將數(shù)據(jù)庫改為雙機(jī)模式命 令備注說明重新配置MC，啟動雙機(jī)在 XXX_ETL：vgchange -a n /dev/vg_ora1 vgchange -a n /dev/vg_ora2 vgchange -a n /dev/vg_ora3 vgchange a n /dev/vg_ora4 vgchange a n /dev/vg_ora5 vgchange -a n/dev/vg_ora6vhchange a y /dev/vg_arch1mount /dev/vg_arch1/lv_arch1 /arch1vgchange -a y /dev/vg_arch2mount /dev/vg_arch2/lv_arch2 /arch2在XXX_ETL：更改vi /etc/cmcluster.asci更改其中的鎖盤路徑,這個要根據(jù)具體情況才能確認(rèn)具體的硬件路徑.cmcheckconf -v -C /etc/cmcluster/cluster.ascii cmapplyconf -v -C /etc/cmcluster/cluster.asciicmruncl f vcmviewcl v由于現(xiàn)在容災(zāi)數(shù)據(jù)庫只采用了一臺主機(jī)，因此雙機(jī)起來后，只有一個節(jié)點。在XXX_ETL：vgchange -a s -p /dev/vg_ora1 vgchange -a s -p /dev/vg_ora2 vgchange -a s -p /dev/vg_ora3 vgchan