Oracle 备份数据恢复演练手册.doc

Oracle MOM备份数据恢复演练手册文档信息:备份恢复演练测试日期修订内容修订人审核人版本2014.08.07创建模板Kenvin.lianV1.0目录MOM备份数据恢复演练手册1目录2一、背景3二、目标和范围3三、规划和执行33.1 规划33.1.1 测试计划33.1.2 测试人员43.1.3 测试资源规划43.2执行过程43.2.1 异机恢复43.2.1 创建权限53.2.2 创建参数文件53.2.3 查找备份集53.2.4 恢复spfile63.2.5 恢复控制文件63.2.6 恢复数据文件73.2.7 日志回滚153.2.8 启动数据库15四、测试总结16一、背景xxxx有限公司核心数据库采用AIX6.1系统和ORACLE 11G数据库,采用Enterprise Netbackup 7.5备份软件,结合LAN Free备份方式将Oracl8、e数据备份到IBM磁带库中. 此次测试模拟数据库主机发生灾难后的数据恢复全过程, 为灾难恢复提供经验参考.二、目标和范围根据IT备份恢复管理制度以及业务角度出发，每季度第一个月（1，2周）进行数据恢复验证，目标是 备份数据有效性验证 验证和修订备份恢复计划 验证备份恢复执行过程 熟练恢复过程 MOM数据可恢复能力验证测试数据从现有数据备份生产环境中抽取，连续、两个季度应不同。本次之验证MOMDB2备份数据。三、规划和执行3.1 规划3.1.1 测试计划日期时间阶段系统管理员&DBA备份管理员应用管理员业务xxxx/xx/x 09:00开始阶段确定测试范围xxxx/xx/x 10:00规划阶段制定恢复计划提供硬件资源需求xxxx/xx/x 9:00执行阶段准备恢复硬件资源辅助/执行数据恢复验证恢复数据辅助/执行数据恢复验证恢复状态配置恢复环境应用xxxx/xx/x 16:00 收尾阶段总结测试过程更新/完善恢复计划总结测试过程更新/完善恢复计划总结测试过程更新/完善恢复计划验证应用验证数据3.1.2 测试人员姓名角色联系方式职责描述系统管理员Orracle DBA备份管理员应用管理员3.1.3 测试资源规划设备类型设备名称操作系统数据版本应用名称设备型号硬件配置3.2执行过程测试： 测试目的检查ORACLE数据库系统的数据备份功能是否完成安装调试，验证备份系统备份的NBU数据库是否可恢复、可用；准备条件备份系统运行正常，允许异机恢复测试方法和步骤模拟数据库数据丢失情况，进行数据恢复测试；预期结果ORACLE db能被正确备份与恢复实际结果/检查备注Result:FailedPassed恢复步骤脚本3.2.1 异机恢复与Rman建立链接手动链接 AIX（64 位）Moving libobk.a to libobk.a.backln -s /usr/openv/netbackup/bin/libobk.a64 /u01/oracle/product/11.2/lib/libobk.a3.2.1 创建权限首先在备份服务器，建立文件允许异机恢复/usr/openv/netbackup/db/altnames/No.Restrictions -master server已开启。确认hosts文件配置# cat /etc/hosts# 2000:1:1:1:209:6bff:feee:2b7f ipv6sample # ipv6 name/address loopback localhost # loopback (lo0) name/address#1 momdbdev179 momdb2 66 rmsas21 momdbdev02 3 localhost.localdomain#确认NBU 配置文件$cat /usr/openv/netbackup/bp.confSERVER = rmsas2CLIENT_NAME = momdbdevREQUIRED_INTERFACE = 1CONNECT_OPTIONS = localhost 1 0 2oraclemomdbdev $3.2.2 创建参数文件一个新的参数文件和原机器创建的配置一致，可以通过拷贝完成。按照参数文件中的内容创建相应的目录和权限。3.2.3 查找备份集找到需要恢复的备份集，在备份服务器上执行如下命令：Unix:/usr/openv/netbackup/bin在momdb2和rmsas2上君可执行列出备份集(需在对应系统oracle账号oraprd执行）# su - oraprduh W$cd /usr/openv/netbackup/binuh W$pwd/usr/openv/netbackup/binuh W$./bplist -C momdb2 -S rmsas2 -t 4 -R -l /3.2.4 恢复spfile启动RMANrman target /rmanrun allocate channel c1 type sbt_tape;send nb_ora_serv=rmsas2,nb_ora_client=momdb2;restore spfile from c-xxxxx;release channel c1;注意：nb_ora_serv -备份服务器MasterServer nb_ora_client -源备份客户端采用生产环境Pfile手工修改直接启动方式：uh W$rman target /Recovery Manager: Release .0 - Production on Tue Aug 5 09:34:24 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database (not started)RMAN set DBID=1688722520 (此步可选择是否执行）RMAN startup pfile=/u01/oracle/product/11.2/dbs/pfile.ora nomount;Oracle instance startedTotal System Global Area 16067620864 bytesFixed Size 2237368 bytesVariable Size 5268048968 bytesDatabase Buffers 10770972672 bytesRedo Buffers 26361856 bytes3.2.5 恢复控制文件启动RMANuh W$rman target /RMANrunallocate channel c1 type sbt_tape;send nb_ora_serv=rmsas2,nb_ora_client=momdb2;restore controlfile from /c-1688722520-20140805-02;release channel c1;或RMANrunallocate channel c1 type sbt_tape;send nb_ora_serv=rmsas2,nb_ora_client=momdb2;restore controlfile from c-1688722520-20140805-02;release channel c1;3.2.6 恢复数据文件Mount数据库rmanAlter database mount;根据控制文件，建立相关目录：数据文件目录、日志文件(0) 重定向数据文件脚本准备SQL select file#,name from v$datafile,; 可以创建数据文件的路径，也可以重定向数据文件select set newname for datafiel |file#| |to| |name|;from v$datafile;select set newname for datafiel |file#| |to| |name|;from v$datafile WHERE TS#=0;(1) 恢复数据文件rmanrunallocate channel c1 type sbt_tape;allocate channel c2 type sbt_tape;allocate channel c3 type sbt_tape;allocate channel c4 type sbt_tape;send nb_ora_serv=rmsas2,nb_ora_client=momdb2;set newname for datafile 1 to /data/oradata/system.259.819997661;set newname for datafile 2 to /data/oradata/sysaux.260.819997667;set newname for datafile 3 to /data/oradata/undotbs1.261.819997669;set newname for datafile 4 to /data/oradata/undotbs2.263.819997677;set newname for datafile 5 to /data/oradata/users.264.819997679;set newname for datafile 6 to /data/oradata/prd_biplatform.1189.821801979;set newname for datafile 7 to /data/oradata/prd_mds.1185.821801981;set newname for datafile 8 to /data/oradata/cmx_item_loc01.dbf;set newname for datafile 9 to /data/oradata/cmx_item_loc02.dbf;set newname for datafile 10 to /data/oradata/cmx_item_loc03.dbf;set newname for datafile 11 to /data/oradata/cmx_item_loc04.dbf;set newname for datafile 12 to /data/oradata/cmx_item_loc05.dbf;set newname for datafile 13 to /data/oradata/cmx_item_loc_hist01.dbf;set newname for datafile 14 to /data/oradata/cmx_item_loc_hist02.dbf;set newname for datafile 15 to /data/oradata/cmx_item_loc_hist03.dbf;set newname for datafile 16 to /data/oradata/cmx_item_loc_hist04.dbf;set newname for datafile 17 to /data/oradata/cmx_item_loc_hist05.dbf;set newname for datafile 18 to /data/oradata/cmx_item_loc_soh01.dbf;set newname for datafile 19 to /data/oradata/cmx_item_loc_soh02.dbf;set newname for datafile 20 to /data/oradata/cmx_item_loc_soh03.dbf;set newname for datafile 21 to /data/oradata/cmx_item_loc_soh04.dbf;set newname for datafile 22 to /data/oradata/cmx_item_loc_soh05.dbf;set newname for datafile 23 to /data/oradata/cmx_item_price01.dbf;set newname for datafile 24 to /data/oradata/cmx_item_price02.dbf;set newname for datafile 25 to /data/oradata/cmx_item_price03.dbf;set newname for datafile 26 to /data/oradata/cmx_item_sup_loc01.dbf;set newname for datafile 27 to /data/oradata/cmx_item_sup_loc02.dbf;set newname for datafile 28 to /data/oradata/cmx_item_sup_loc03.dbf;set newname for datafile 29 to /data/oradata/cmx_item_sup_loc04.dbf;set newname for datafile 30 to /data/oradata/cmx_tran_data01.dbf;set newname for datafile 31 to /data/oradata/cmx_tran_data02.dbf;set newname for datafile 32 to /data/oradata/cmx_tran_data03.dbf;set newname for datafile 33 to /data/oradata/lob_data01.dbf;set newname for datafile 34 to /data/oradata/pref01.daf;set newname for datafile 35 to /data/oradata/retek_data01.dbf;set newname for datafile 36 to /data/oradata/retek_data02.dbf;set newname for datafile 37 to /data/oradata/retek_data03.dbf;set newname for datafile 38 to /data/oradata/retek_data04.dbf;set newname for datafile 39 to /data/oradata/retek_data05.dbf;set newname for datafile 40 to /data/oradata/retek_data06.dbf;set newname for datafile 41 to /data/oradata/retek_data07.dbf;set newname for datafile 42 to /data/oradata/retek_index01.dbf;set newname for datafile 43 to /data/oradata/retek_index02.dbf;set newname for datafile 44 to /data/oradata/retek_index03.dbf;set newname for datafile 45 to /data/oradata/retek_index04.dbf;set newname for datafile 46 to /data/oradata/retek_index05.dbf;set newname for datafile 47 to /data/oradata/retek_index06.dbf;set newname for datafile 48 to /data/oradata/retek_index07.dbf;set newname for datafile 49 to /data/oradata/example01.dbf;set newname for datafile 50 to /data/oradata/dev_biacompts.1181.822245559;set newname for datafile 51 to /data/oradata/dev_biacomp.1183.822245561;set newname for datafile 52 to /data/oradata/dev_biplatform.1178.822253957;set newname for datafile 53 to /data/oradata/dev_mds.1177.822253961;set newname for datafile 54 to /data/oradata/undotbs1.1175.822486795;set newname for datafile 55 to /data/oradata/undotbs2.1174.822486859;set newname for datafile 56 to /data/oradata/retek_data08.dbf;set newname for datafile 57 to /data/oradata/retek_data09.dbf;set newname for datafile 58 to /data/oradata/retek_index08.dbf;set newname for datafile 59 to /data/oradata/retek_index09.dbf;set newname for datafile 60 to /data/oradata/tools.1203.824723009;set newname for datafile 61 to /data/oradata/retek_data10.dbf;set newname for datafile 62 to /data/oradata/retek_data11.dbf;set newname for datafile 63 to /data/oradata/retek_data12.dbf;set newname for datafile 64 to /data/oradata/retek_data13.dbf;set newname for datafile 65 to /data/oradata/retek_data14.dbf;set newname for datafile 66 to /data/oradata/retek_data15.dbf;set newname for datafile 67 to /data/oradata/retek_data16.dbf;set newname for datafile 68 to /data/oradata/retek_data17.dbf;set newname for datafile 69 to /data/oradata/undotbs1.01;set newname for datafile 70 to /data/oradata/retek_data18.dbf;set newname for datafile 71 to /data/oradata/sysaux.01.dbf;set newname for datafile 72 to /data/oradata/retek_index10.dbf;set newname for datafile 73 to /data/oradata/retek_index11.dbf;set newname for datafile 74 to /data/oradata/cmx_tran_data04.dbf;set newname for datafile 75 to /data/oradata/retek_data19.dbf;set newname for datafile 76 to /data/oradata/retek_data20.dbf;set newname for datafile 77 to /data/oradata/retek_data21.dbf;set newname for datafile 78 to /data/oradata/retek_data23.dbf;set newname for datafile 79 to /data/oradata/retek_data22.dbf;set newname for datafile 80 to /data/oradata/undotbs1.01.dbf;set newname for datafile 81 to /data/oradata/retek_data24.dbf;set newname for datafile 82 to /data/oradata/retek_data25.dbf;set newname for datafile 83 to /data/oradata/retek_data26.dbf;set newname for datafile 84 to /data/oradata/retek_data27.dbf;set newname for datafile 85 to /data/oradata/retek_index13.dbf;set newname for datafile 86 to /data/oradata/retek_index12.dbf;set newname for datafile 87 to /data/oradata/sysaux02.dbf;set newname for datafile 88 to /data/oradata/retek_data28.dbf;set newname for datafile 89 to /data/oradata/retek_data29.dbf;set newname for datafile 90 to /data/oradata/par_data_2013_02.dbf;set newname for datafile 91 to /data/oradata/par_data_2013_01.dbf;set newname for datafile 92 to /data/oradata/par_data_2014_02.dbf;set newname for datafile 93 to /data/oradata/par_data_2014_01.dbf;set newname for datafile 94 to /data/oradata/par_index_2013_02.dbf;set newname for datafile 95 to /data/oradata/par_index_2013_01.dbf;set newname for datafile 96 to /data/oradata/sysaux03.dbf;set newname for datafile 97 to /data/oradata/retek_data33.dbf;set newname for datafile 98 to /data/oradata/retek_data31.dbf;set newname for datafile 99 to /data/oradata/retek_data30.dbf;set newname for datafile 100 to /data/oradata/retek_index15.dbf;set newname for datafile 101 to /data/oradata/retek_index14.dbf;set newname for datafile 102 to /data/oradata/retek_data34.dbf;set newname for datafile 103 to /data/oradata/sysaux04.dbf;set newname for datafile 104 to /data/oradata/bip1_biplatform.635.841316169;set newname for datafile 105 to /data/oradata/bip1_mds.600.841316171;set newname for datafile 106 to /data/oradata/bip2_mds.2164.841842203;set newname for datafile 107 to /data/oradata/bip2_biplatform.2165.841842203;set newname for datafile 108 to /data/oradata/retek_data35.dbf;set newname for datafile 109 to /data/oradata/retek_data36.dbf;set newname for datafile 110 to /data/oradata/retek_data37.dbf;set newname for datafile 111 to /data/oradata/retek_data38.dbf;set newname for datafile 112 to /data/oradata/retek_data39.dbf;set newname for datafile 113 to /data/oradata/retek_data40.dbf;set newname for datafile 114 to /data/oradata/retek_index16.dbf;set newname for datafile 115 to /data/oradata/retek_index17.dbf;set newname for datafile 116 to /data/oradata/retek_index18.dbf;set newname for datafile 117 to /data/oradata/retek_index19dbf;set newname for datafile 118 to /data/oradata/retek_index20.dbf;set newname for datafile 119 to /data/oradata/retek_index21.dbf;set newname for datafile 120 to /data/oradata/retek_index22.dbf;set newname for datafile 121 to /data/oradata/retek_index23.dbf;set newname for datafile 122 to /data/oradata/retek_index24.dbf;set newname for datafile 123 to /data/oradata/retek_index25.dbf;set newname for datafile 124 to /data/oradata/cmx_item_price04.dbf;set newname for datafile 125 to /data/oradata/cmx_item_price05.dbf;set newname for datafile 126 to /data/oradata/cmx_item_loc_soh06.dbf;set newname for datafile 127 to /data/oradata/cmx_item_loc_soh07.dbf;set newname for datafile 128 to /data/oradata/cmx_item_loc_soh08.dbf;set newname for datafile 129 to /data/oradata/cmx_item_loc06.dbf;set newname for datafile 130 to /data/oradata/cmx_item_loc07.dbf;set newname for datafile 131 to /data/oradata/cmx_item_loc08.dbf;set newname for datafile 132 to /data/oradata/cmx_item_loc09.dbf;set newname for datafile 133 to /data/oradata/cmx_item_loc10.dbf;set newname for datafile 134 to /data/oradata/cmx_item_sup_loc05.dbf;set newname for datafile 135 to /data/oradata/cmx_item_sup_loc06.dbf;set newname for datafile 136 to /data/oradata/undotbs02.dbf;set newname for datafile 137 to /data/oradata/undotbs03.dbf;set newname for datafile 138 to /data/oradata/sysaux05.dbf;set newname for datafile 139 to /data/oradata/sysaux06.dbf;set newname for datafile 140 to /data/oradata/par_index_2013_03.dbf;set newname for datafile 141 to /data/oradata/par_index_2013_04.dbf;set newname for datafile 142 to /data/oradata/sysaux07.dbf;set newname for datafile 143 to /data/oradata/sysaux08.dbf;set newname for datafile 144 to /data/oradata/retek_data41.dbf;set newname for datafile 145 to /data/oradata/retek_data42.dbf;set newname for datafile 146 to /data/oradata/retek_data43.dbf;set newname for datafile 147 to /data/oradata/retek_data44.dbf;set newname for datafile 148 to /data/oradata/retek_data45.dbf;set newname for datafile 149 to /data/oradata/undotbs04.dbf;set newname for datafile 150 to /data/oradata/undotbs05.dbf;set newname for datafile 151 to /data/oradata/undotbs06.dbf;set newname for datafile 152 to /data/oradata/undotbs07.dbf;set newname for datafile 153 to /data/oradata/undotbs08.dbf;set newname for datafile 154 to /data/oradata/undotbs201.dbf;set newname for datafile 155 to /data/oradata/undotbs202.dbf;set newname for datafile 156 to /data/oradata/retek_data46.dbf;set newname for datafile 157 to /data/oradata/retek_data47.dbf;set newname for datafile 158 to /data/oradata/retek_data48.dbf;set newname for datafile 159 to /data/oradata/retek_data49.dbf;set newname for datafile 160 to /data/oradata/retek_data50.dbf;set newname for datafile 161 to /data/oradata/retek_data51.dbf;set newname for datafile 162 to /data/oradata/retek_data52.dbf;set newname for datafile 163 to /data/oradata/retek_data53.dbf;set newname for datafile 164 to /data/oradata/retek_data54.dbf;set newname for datafile 165 to /data/oradata/retek_data55.dbf;set newname for datafile 166 to /data/oradata/retek_data56.dbf;set newname for datafile 167 to /data/oradata/retek_data57.dbf;set newname for datafile 168 to /data/oradata/retek_data58.dbf;set newname for datafile 169 to /data/oradata/retek_data59.dbf;set newname for datafile 170 to /data/oradata/retek_data60.dbf;set newname for datafile 171 to /data/oradata/retek_index26.dbf;set newname for datafile 172 to /data/oradata/retek_index27.dbf;set newname for datafile 173 to /data/oradata/retek_index28.dbf;set newname for datafile 174 to /data/oradata/retek_index29.dbf;set newname for datafile 175 to /data/oradata/retek_index30.dbf;set newname for datafile 176 to /data/oradata/retek_data61.dbf;set newname for datafile 177 to /data/oradata/retek_data62.dbf;set newname for datafile 178 to /data/oradata/retek_data63.dbf;set newname for datafile 179 to /data/oradata/retek_data64.dbf;set newname for datafile 180 to /data/oradata/retek_data65.dbf;set newname for datafile 181 to /data/oradata/retek_data66.dbf;set newname for datafile 182 to /data/oradata/retek_data67.dbf;set newname for datafile 183 to /data/oradata/retek_data68.dbf;set newname for datafile 184 to /data/oradata/retek_data69.dbf;set newname for datafile 185 to /data/oradata/retek_data70.dbf;set newname for datafile 186 to /data/oradata/undotbs09.dbf;set newname for datafile 187 to /data/oradata/undotbs10.dbf;set newname for datafile 188 to /data/oradata/undotbs11.dbf;set newname for datafile 189 to /data/oradata/undotbs12.dbf;set newname for datafile 190 to /data/oradata/retek_data_ssd01.dbf;set newname for datafile 191 to /data/oradata/retek_data_ssd02.dbf;set newname for datafile 192 to /data/oradata/retek_data_ssd03.dbf;set newname for datafile 193 to /data/oradata/retek_data_ssd04.dbf;set newname for datafile 194 to /data/oradata/retek_data_ssd05.dbf;set newname for datafile 195 to /data/oradata/retek_data71.dbf;set newname for datafile 196 to /data/oradata/retek_data72.dbf;set newname for datafile 197 to /data/oradata/retek_data73.dbf;set newname for datafile 198 to /data/oradata/retek_data74.dbf