1、DELLSCV度存储灾难恢复操作技巧方案计划灾难恢复操作方案2一、模拟环境中断主站点与备站点线路,模拟主存储完全损坏二、灾备站点启用服务移除slave存储上repl of test卷与master站点间的映射关系修改repl of test卷名称(防止主备存储通讯正常后,删除远程复制关系时,系统自动对reple of test的操作)将修改后的slave_test卷映射给slave数据库服务器。重启slave数据库服务器,识别新分配的存储卷,并加载文件系统,启动数据库。slave-site-db: # fdisk -lDisk /dev/mapper/36000d310038186000000
2、000000000029: 10 GiB, 10737418240 bytes, 2 0971520 sectorsUnits: sectors of 1 * 512 = 512 bytesSector size (logical/physical): 512 bytes / 4096 bytesI/O size (minimum/optimal): 2097152 bytes / 2097152 bytesDisklabel type: dosDisk identifier: 0xcbb2660dDevice Boot Start End Sectors Size Id Type/dev/m
3、apper/36000d310038186000000000000000029-part1 4096 20971519 20967424 10G 83 Linuxslave-site-db: # mount /dev/mapper/36000d310038186000000000000000029-part1 /tttslave-site-db: # cd /tttslave-site-db:/ttt # lsdata data.tar lost+foundslave-site-db:/ttt # cp data.tar 1.tar 三、计划回切至主站点3.1、停数据库1)、停数据库2)、um
4、ount 文件系统cd /umount /ttt3.2、存储回切操作1)、取消映射2)、手工对slave_test创建快照3)、恢复通讯链路(模拟主存储故障完全解决)确认两台存储是否完全恢复连接4)、删除原先远程复制关系确认test到repl of test关系是否存在,是否存在故障删除test卷的远程复制关系5)、删除master存储上原来的test卷的映射和卷本身6)、建立slave存储到master存储的远程复制关系等待两个存储之间完成数据复制,复制时间受数据量和带宽速度影响。7)、删除slave_tests与repl of slave_test的映射关系,但保留master存储上的re
5、pl of slave_test卷8)、修改master存储上repl of slave_test卷名称,并映射个master数据库集群服务器9)、修改master存储test卷快照策略10)、重启2台master数据库服务器识别存储A、master-db2: #RebootB、master-db2: #fdisk -lDisk /dev/mapper/36000d31003818400000000000000002f: 10 GiB, 10737418240 bytes, 20971520 s ectorsUnits: sectors of 1 * 512 = 512 bytesSector
6、 size (logical/physical): 512 bytes / 4096 bytesI/O size (minimum/optimal): 2097152 bytes / 2097152 bytesDisklabel type: dosDisk identifier: 0xcbb2660dDevice Boot Start End Sectors Size Id Type/dev/mapper/36000d31003818400000000000000002f-part1 4096 20971519 20967424 10G 83 LinuxC、修改/etc/multipath.c
7、onf文件,将新的卷的UUID36000d31003818400000000000000002f填写到mpath3下(生产数据8T卷为mpath1)vi /etc/multipath.conf ,修改mpath3的wwid为36000d31003818400000000000000002dmultipaths multipath alias mpath3 wwid 36000d31003818400000000000000002d multipath alias mpath2 wwid 36000d310038184000000000000000015 multipath alias mpat
8、h1 wwid 36000d31003818400000000000000001f devices device failback immediate no_path_retry queue path_grouping_policy multibus product Compellent Vol vendor COMPELNT 2)、重新启动两台服务器master-db2: #rebootmaster-db2: # mount /dev/mapper/mpath3-part1 /tttmaster-db2: # cd /tttmaster-db2:/ttt # ls1.tar data data.tar lost+found四、重建master存储到slave存储的远程复制关系1)、删除slave存储上slave_test卷2)、建立master存储test卷到slave存储的远程复制关系