《XXX系统容灾应急保障预案四分册v.doc》由会员分享，可在线阅读，更多相关《XXX系统容灾应急保障预案四分册v.doc（12页珍藏版）》请在三一文库上搜索。
1、XXX系统存储容灾应急保障预案四分册卓望数码技术（深圳）有限公司2008年7月方案范文无法思考和涵盖全面，最好仔细浏览后下载使用。目录概述3现网存储情况31. CX700存储配置32. CX3-40F存储配置3存储数据恢复实施过程4方案范文无法思考和涵盖全面，最好仔细浏览后下载使用。概述本分册适用于当主备存储EMC CX700，EMC CX3-40F都正常，由于错误的操作，产生错误数据，导致主存储数据以及备存储Mirror View的数据都是错误数据，数据需要恢复到前一天的正常数据。怎么采用主用存储EMC CX700的clone数据，实现业务恢复？现网存储情况1. CX700存储配置目前CX7
2、00中，用于XXX数据库数据的磁盘是Lun1 Lun7以及Lun9-Lun10. 如下所示Lun NumberRAID TypeRAID Group Lun SizeSP Assigned1RAID101300GBA2RAID102300GBB3RAID10 1300GBB4RAID102300GBA5RAID10170GBA6RAID10270GBB7RAID101100MB9RAID104100GBA10RAID104200GBB1001RAID51300GBA1002RAID52300GBB1003RAID51300GBB1004RAID52300GBA1005RAID5170GBA10
3、06RAID5270GBB1007RAID51100MB1009RAID54100GBA1010RAID54200GBB2. CX3-40F存储配置目前CX3-40F中，用于XXX数据库数据容灾的磁盘是Lun1 Lun7以及Lun9-Lun10. 如下所示方案范文无法思考和涵盖全面，最好仔细浏览后下载使用。Lun NumberRAID TypeRAID Group Lun SizeSP Assigned1RAID101300GBA2RAID102300GBB3RAID10 1300GBB4RAID102300GBA5RAID10170GBA6RAID10270GBB7RAID101100MB9
4、RAID104100GBA10RAID104200GBB 存储数据恢复实施过程当主备存储EMC CX700，EMC CX3-40F都正常，由于错误的操作，产生错误数据，导致主存储数据以及备存储Mirror View的数据都是错误数据，数据需要恢复到前一天的正常数据。采用EMC CX700 的Clone 卷组和现网数据库主机进行数据和业务的恢复，此时将实施现网数据库主机（XXX-dd01和XXX-dd02）挂接到主用存储 EMC CX700 的Clone卷组,此时数据库主机和存储架构如下图： 即：现网数据库主机（XXX_dd01和XXX_dd02）+EMC CX700，具体恢复实施步骤如下：在进
5、行恢复时可以直接使用每个步骤的内容，进行恢复。1) 备份现网数据库cs_dd01和cs_dd02的vg信息方案范文无法思考和涵盖全面，最好仔细浏览后下载使用。命 令备注说明记录设备的minumber：在XXX_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
6、/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在XXX_dd02：oracleXXX_dd02：:/oracle>ll /dev/*/group crw-r- 64 0x000000 /dev/vg0
7、0/group crw-rw-rw- 64 0x020000 /dev/vg_arch2/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-rw-rw- 64 0x070000 /dev/vg_ora4/group crw-r-r- 64 0x080000 /dev/vg_ora5/group
8、crw-r-r- 64 0x090000 /dev/vg_ora6/group重建时建相同的minmber在XXX_dd01： vgexport p s m /tmp/vgbak/vg_ora1.map /dev/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.ma
9、p /dev/vg_ora5vgexport p s m /tmp/vgbak/vg_ora6.map /dev/vg_ora6vgexport p s m /tmp/vgbak/vg_arch1.map /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导出vg信息文件方案范文无法思考和涵盖全面，最好仔细浏览后下载使用。命 令备注说明2) 停XXX_dd01和XXX_dd02 RAC3) 从主用
10、存储EMC CX700 的stroage group中把XXX数据库所使用的LUN1-LUN7,LUN9-LUN10，从XXX_dd01和XXX_dd02移除4) 主用存储EMC CX700的Clone LUN, LUN 1001LUN 1007,LUN1009LUN1010 bind到XXX_dd01和XXX_dd02上。5) 通过ioscan找到EMC CX 700上bind Clone卷命 令备注说明在XXX_dd01：和XXX_dd02：上执行#iosacn fnC disk 在XXX_dd01：上检查mirror卷信息#insf e 安装硬件信息路径#powermt display
11、dev=all #powermt config#powermt save检查对应的lun和WWWN信息6) 做对应VG的export和import命 令备注说明在XXX_dd01：和XXX_dd02：上执行重建时建相同的minmberXXX_dd01：vgexport vg_ora1vgexport vg_ora2vgexport vg_ora3vgexport vg_ora4vgexport vg_ora5vgexport vg_ora6vgexport vg_arch1vgexport vg_lockXXX_dd02：vgexport vg_arch2vgexport vg_ora1vge
12、xport vg_ora2vgexport vg_ora3vgexport vg_ora4删除原有vg_ora1-ora6和vg_arch和vg_lock信息方案范文无法思考和涵盖全面，最好仔细浏览后下载使用。命 令备注说明vgexport vg_ora5vgexport vg_ora6vgexport vg_lock#ioscan -fnCdisk |grep -i no_hw |awk 'print "rmsf -H", $3' | sh清理原有CX 700的LUN NO_HW的设备文件重建设备文件： XXX_dd01：mkdir vg_ora1 mkd
13、ir 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 64 0x040000 vg_ora1mknod /dev/vg_ora2/group c 64 0x050000 vg_ora2mknod /dev/vg_ora3/group c 64 0x060000 vg_ora3mknod /dev/vg_ora4/g
14、roup 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_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/v
15、g_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_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 0x0900
16、00 vg_ora6mknod /dev/vg_arch2/group c 64 0x020000 vg_arch2重建设备文件方案范文无法思考和涵盖全面，最好仔细浏览后下载使用。命 令备注说明导入vg信息:在XXX_dd01：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
17、/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_arch1在XXX_dd02：vgimport -s -v -m /tmp/vgbak/vg_ora1.map /dev/vg_ora1v
18、gimport 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.ma
19、p /dev/vg_lockvgimport s -v -m /tmp/vgbak/vg_arch1.map /dev/vg_arch2重做vg的import7) 修改用户权限命 令备注说明在XXX_dd01：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_or
20、a6/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/vg_ora4/chown -R oracle:dba /dev/vg_ora5/chown -R oracl
21、e:dba /dev/vg_ora6/chown -R oracle:dba /dev/vg_arch2/chown -R oracle:dba /dev/vg_lock/8) 将数据库改为双机模式命 令备注说明重新配置MC，启动双机在 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 vgchange a n /dev/vg_ora5 vgchange -a n/dev/vg_ora6vhchange a y /
22、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_arch2/lv_arch2 /arch2在XXX_dd01：更改vi /etc/cm
23、cluster.asci更改其中的锁盘路径,这个要根据具体情况才能确认具体的硬件路径.cmcheckconf -v -C /etc/cmcluster/cluster.ascii cmapplyconf -v -C /etc/cmcluster/cluster.asciicmruncl f vcmviewcl v将db01和db02重新组成双机环境方案范文无法思考和涵盖全面，最好仔细浏览后下载使用。命 令备注说明在XXX_dd01：vgchange -a s -p /dev/vg_ora1 vgchange -a s -p /dev/vg_ora2 vgchange -a s -p /dev/
24、vg_ora3 vgchange -a s -p /dev/vg_ora4vgchange -a s -p /dev/vg_ora5 vgchange -a s -p /dev/vg_ora6在XXX_dd02：vgchange -a s -p /dev/vg_ora1 vgchange -a s -p /dev/vg_ora2 vgchange -a s -p /dev/vg_ora3 vgchange -a s -p /dev/vg_ora4vgchange -a s -p /dev/vg_ora5 vgchange -a s -p /dev/vg_ora69) 数据库启动和业务测试命 令备注说明su - oracle sqlplus " /as sysdba"SQL>startup;数据库正常启动后，进行相关业务测试 方案范文无法思考和涵盖全面，最好仔细浏览后下载使用。