X系統(tǒng)容災(zāi)應(yīng)急保障預(yù)案四分冊(cè)v

1、XXX系統(tǒng)存儲(chǔ)容災(zāi)應(yīng)急保障預(yù)案四分冊(cè)卓望數(shù)碼技術(shù)（深圳）有限公司2008年7月目錄概述3現(xiàn)網(wǎng)存儲(chǔ)情況31. CX700存儲(chǔ)配置32. CX3-40F存儲(chǔ)配置3存儲(chǔ)數(shù)據(jù)恢復(fù)實(shí)施過程4概述本分冊(cè)適用于當(dāng)主備存儲(chǔ)EMC CX700，EMC CX3-40F都正常，由于錯(cuò)誤的操作，產(chǎn)生錯(cuò)誤數(shù)據(jù)，導(dǎo)致主存儲(chǔ)數(shù)據(jù)以及備存儲(chǔ)Mirror View的數(shù)據(jù)都是錯(cuò)誤數(shù)據(jù)，數(shù)據(jù)需要恢復(fù)到前一天的正常數(shù)據(jù)。怎么采用主用存儲(chǔ)EMC CX700的clone數(shù)據(jù)，實(shí)現(xiàn)業(yè)務(wù)恢復(fù)？現(xiàn)網(wǎng)存儲(chǔ)情況1. CX700存儲(chǔ)配置目前CX700中，用于XXX數(shù)據(jù)庫數(shù)據(jù)的磁盤是Lun1 Lun7以及Lun9-Lun10. 如下所示Lun Num

2、berRAID TypeRAID Group Lun SizeSP Assigned1RAID101300GBA2RAID102300GBB3RAID10 1300GBB4RAID102300GBA5RAID10170GBA6RAID10270GBB7RAID101100MB9RAID104100GBA10RAID104200GBB1001RAID51300GBA1002RAID52300GBB1003RAID51300GBB1004RAID52300GBA1005RAID5170GBA1006RAID5270GBB1007RAID51100MB1009RAID54100GBA1010RAID

3、54200GBB2. CX3-40F存儲(chǔ)配置目前CX3-40F中，用于XXX數(shù)據(jù)庫數(shù)據(jù)容災(zāi)的磁盤是Lun1 Lun7以及Lun9-Lun10. 如下所示Lun NumberRAID TypeRAID Group Lun SizeSP Assigned1RAID101300GBA2RAID102300GBB3RAID10 1300GBB4RAID102300GBA5RAID10170GBA6RAID10270GBB7RAID101100MB9RAID104100GBA10RAID104200GBB 存儲(chǔ)數(shù)據(jù)恢復(fù)實(shí)施過程當(dāng)主備存儲(chǔ)EMC CX700，EMC CX3-40F都正常，由于錯(cuò)誤的操作，產(chǎn)

4、生錯(cuò)誤數(shù)據(jù)，導(dǎo)致主存儲(chǔ)數(shù)據(jù)以及備存儲(chǔ)Mirror View的數(shù)據(jù)都是錯(cuò)誤數(shù)據(jù)，數(shù)據(jù)需要恢復(fù)到前一天的正常數(shù)據(jù)。采用EMC CX700 的Clone 卷組和現(xiàn)網(wǎng)數(shù)據(jù)庫主機(jī)進(jìn)行數(shù)據(jù)和業(yè)務(wù)的恢復(fù)，此時(shí)將實(shí)施現(xiàn)網(wǎng)數(shù)據(jù)庫主機(jī)（XXX-dd01和XXX-dd02）掛接到主用存儲(chǔ) EMC CX700 的Clone卷組,此時(shí)數(shù)據(jù)庫主機(jī)和存儲(chǔ)架構(gòu)如下圖： 即：現(xiàn)網(wǎng)數(shù)據(jù)庫主機(jī)（XXX_dd01和XXX_dd02）+EMC CX700，具體恢復(fù)實(shí)施步驟如下：在進(jìn)行恢復(fù)時(shí)可以直接使用每個(gè)步驟的內(nèi)容，進(jìn)行恢復(fù)。1) 備份現(xiàn)網(wǎng)數(shù)據(jù)庫cs_dd01和cs_dd02的vg信息命 令備注說明記錄設(shè)備的minumber：在XXX

5、_dd01： oracleXXX_dd01：:/oracle>ll /dev/*/group crw-r- 64 0x000000 /dev/vg00/group crw-rw-rw- 64 0x010000 /dev/vg_arch1/groupcrw-rw-rw- 64 0x030000 /dev/vg_lock/group crw-rw-rw- 64 0x040000 /dev/vg_ora1/group crw-rw-rw- 64 0x050000 /dev/vg_ora2/group crw-rw-rw- 64 0x060000 /dev/vg_ora3/group crw-r

6、w-rw- 64 0x070000 /dev/vg_ora4/group crw-r-r- 64 0x080000 /dev/vg_ora5/group crw-r-r- 64 0x090000 /dev/vg_ora6/group在XXX_dd02：oracleXXX_dd02：:/oracle>ll /dev/*/group crw-r- 64 0x000000 /dev/vg00/group crw-rw-rw- 64 0x020000 /dev/vg_arch2/groupcrw-rw-rw- 64 0x030000 /dev/vg_lock/group crw-rw-rw- 6

7、4 0x040000 /dev/vg_ora1/group crw-rw-rw- 64 0x050000 /dev/vg_ora2/group crw-rw-rw- 64 0x060000 /dev/vg_ora3/group crw-rw-rw- 64 0x070000 /dev/vg_ora4/group crw-r-r- 64 0x080000 /dev/vg_ora5/group crw-r-r- 64 0x090000 /dev/vg_ora6/group重建時(shí)建相同的minmber在XXX_dd01： vgexport p s m /tmp/vgbak/vg_ora1.map /d

8、ev/vg_ora1vgexport p s m /tmp/vgbak/vg_ora2.map /dev/vg_ora2vgexport p s m /tmp/vgbak/vg_ora3.map /dev/vg_ora3vgexport p s m /tmp/vgbak/vg_ora4.map /dev/vg_ora4vgexport p s m /tmp/vgbak/vg_ora5.map /dev/vg_ora5vgexport p s m /tmp/vgbak/vg_ora6.map /dev/vg_ora6vgexport p s m /tmp/vgbak/vg_arch1.map /

9、dev/vg_arch1vgexport p s m /tmp/vgbak/vg_lock.map /dev/vg_lock在XXX_dd02：vgexport p s m /tmp/vgbak/vg_arch2.map /dev/vg_arch2導(dǎo)出vg信息文件2) 停XXX_dd01和XXX_dd02 RAC3) 從主用存儲(chǔ)EMC CX700 的stroage group中把XXX數(shù)據(jù)庫所使用的LUN1-LUN7,LUN9-LUN10，從XXX_dd01和XXX_dd02移除4) 主用存儲(chǔ)EMC CX700的Clone LUN, LUN 1001LUN 1007,LUN1009LUN101

10、0 bind到XXX_dd01和XXX_dd02上。5) 通過ioscan找到EMC CX 700上bind Clone卷命 令備注說明在XXX_dd01：和XXX_dd02：上執(zhí)行#iosacn fnC disk 在XXX_dd01：上檢查mirror卷信息#insf e 安裝硬件信息路徑#powermt display dev=all #powermt config#powermt save檢查對(duì)應(yīng)的lun和WWWN信息6) 做對(duì)應(yīng)VG的export和import命 令備注說明在XXX_dd01：和XXX_dd02：上執(zhí)行重建時(shí)建相同的minmberXXX_dd01：vgexport vg

11、_ora1vgexport vg_ora2vgexport vg_ora3vgexport vg_ora4vgexport vg_ora5vgexport vg_ora6vgexport vg_arch1vgexport vg_lockXXX_dd02：vgexport vg_arch2vgexport vg_ora1vgexport vg_ora2vgexport vg_ora3vgexport vg_ora4vgexport vg_ora5vgexport vg_ora6vgexport vg_lock刪除原有vg_ora1-ora6和vg_arch和vg_lock信息#ioscan -f

12、nCdisk |grep -i no_hw |awk 'print "rmsf -H", $3' | sh清理原有CX 700的LUN NO_HW的設(shè)備文件重建設(shè)備文件： XXX_dd01：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 0x030000 vg_lockmknod /dev/vg_ora1/group c 6

13、4 0x040000 vg_ora1mknod /dev/vg_ora2/group c 64 0x050000 vg_ora2mknod /dev/vg_ora3/group c 64 0x060000 vg_ora3mknod /dev/vg_ora4/group c 64 0x070000 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_arch1XXX_

14、dd02：mkdir vg_ora1 mkdir vg_ora2 mkdir vg_ora3 mkdir vg_ora4 mkdir vg_ora5 mkdir vg_ora6 mkdir vg_arch2 mkdir vg_lock mknod /dev/vg_lock/group c 64 0x030000 vg_lockmknod /dev/vg_ora1/group c 64 0x040000 vg_ora1mknod /dev/vg_ora2/group c 64 0x050000 vg_ora2mknod /dev/vg_ora3/group c 64 0x060000 vg_or

15、a3mknod /dev/vg_ora4/group c 64 0x070000 vg_ora4mknod /dev/vg_ora5/group c 64 0x080000 vg_ora5mknod /dev/vg_ora6/group c 64 0x090000 vg_ora6mknod /dev/vg_arch2/group c 64 0x020000 vg_arch2重建設(shè)備文件導(dǎo)入vg信息:在XXX_dd01：vgimport -s -v -m /tmp/vgbak/vg_ora1.map /dev/vg_ora1vgimport s -v -m /tmp/vgbak/vg_ora2.

16、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

17、/vgbak/vg_arch1.map /dev/vg_arch1在XXX_dd02：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/v

18、g_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_arch2重做vg的import7) 修改用戶權(quán)限命 令備注說明在XXX_dd01：chown -R oracle:dba /dev/vg_ora1/chown -R oracle:dba /dev/vg_ora2/chown -R oracle:dba /dev/vg_ora3

19、/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/在XXX_dd02：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

20、/vg_ora4/chown -R oracle:dba /dev/vg_ora5/chown -R oracle:dba /dev/vg_ora6/chown -R oracle:dba /dev/vg_arch2/chown -R oracle:dba /dev/vg_lock/修改用戶權(quán)限信息8) 將數(shù)據(jù)庫改為雙機(jī)模式命 令備注說明重新配置MC，啟動(dòng)雙機(jī)在 XXX_dd01：vgchange -a n /dev/vg_ora1 vgchange -a n /dev/vg_ora2 vgchange -a n /dev/vg_ora3 vgchange a n /dev/vg_ora4 v

21、gchange a n /dev/vg_ora5 vgchange -a n/dev/vg_ora6vhchange a y /dev/vg_arch1mount /dev/vg_arch1/lv_arch1 /arch1在 XXX_dd02：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_ora6vgchange -a y /dev/vg_arch2mount /dev/vg_arc