TSM+ORACLE备份恢复测试报告

1、oracle数据库备份恢复测试报告名目1. 背景概述11.1 恢复测试目的11.2 恢复测试方法11.3 数据库备份架构12. 恢复所需资源22.1 主机资源22.2 实施环境23. 数据库恢复测试步骤33.1 安装配置测试主机33.2 全库恢复33.3 测试主机-tsm恢复配置33.4 测试主机-设定数据库环境变量43.5 测试主机-启动数据库到nomount状态43.6 测试主机-恢复把握文件43.7 测试主机-更改数据库到mount状态53.8 测试主机-恢复数据文件53.9 测试主机-恢复归档日志93.10 测试主机-以resetlogs方法打开数据库113.11 测试主机-重启数据库

2、114. 恢复结果121. 背景概述1.1 恢复测试目的第12页1.2 恢复测试方法为了验证数据库的备份有效性，我们进行了此次的数据库恢复测试，用来确保数据库备份的正确性，可恢复性。异机恢复由于生产数据库已经在使用，我们不能在生产数据库上进行本机恢复测试，为了不影响生产数据库的正常使用，我们将在测试机上进行恢复测试。1.3 数据库备份架构1. 备份系统接受ibm tivoli备份软件；2. 带库使用adic磁带库。2. 恢复所需资源2.1 主机资源恢复测试主机信息需要预备恢复的测试主机，最佳做法是恢复测试主机的硬件架构、操作系统版本和生产主机全都。角色主机名ip 地址操作系统测试机zjb_fw

3、skdb78.20.63.13ibm aix 5.3备份主机shfwskdb178.20.53.13ibm aix 5.32.2 实施环境软件版本tsm sever for windows5.3.2.4oracle 9i9.2.0.7.83. 数据库恢复测试步骤3.1 安装配置测试主机由于测试机完全拷贝备份主机，故测试机与生产机环境全都，确保测试主机已经正常3.2 全库恢复运行，并能于要恢复的生产主机，备份主机网络连通。利用tsm软件界面，调用原来所备份的数据库，以及相应的数据库恢复工具rman的脚本，进行oracle 数据库系统的全库恢复。3.3 测试主机-tsm恢复配置由于测试主机与生产主

4、机架构相同，故只需在tsm server上定义san server。如下：define server sh_fwsk_db_sc_sta_01 serverpassword=admin hladdress=78.20.63.13 lladdress=1500 validateprotocol=alldefine path sh_fwsk_db_sc_sta_01 mt0.2.0.3 srctype=server desttype=drive libr=lb0.1.0.3 device=/dev/rmt0 define path sh_fwsk_db_sc_sta_01 mt0.3.0.3 sr

5、ctype=server desttype=drive libr=lb0.1.0.3 device=/dev/rmt1 define path sh_fwsk_db_sc_sta_01 mt0.4.0.3 srctype=server desttype=drive libr=lb0.1.0.3 device=/dev/rmt2 define path sh_fwsk_db_sc_sta_01 mt0.5.0.3 srctype=server desttype=drive libr=lb0.1.0.3 device=/dev/rmt3在客户端/usr/tivoli/tsm/storageagen

6、t/bin 名目下执行以下命令：#dsmsta setstorageserver myname=sh_fwsk_db_sc_sta_01 mypassword=admin myhladdress=78.20.63.13 servername=tsmserver serverpassword=admin hladdress=78.20.53.241 lladdress=1500启动tsm san storage agent# cd /usr/tivoli/tsm/storageagent/bin # nohup ./dsmsta &3.4 测试主机-设定数据库环境变量export ora

7、cle_sid=fwsk1接下来的步骤都要求以用户oracle运行，并要求环境变量oracle_sid设置为需要恢复的数据库。在测试主机上，设置用户oracle的环境变量oracle_sid为需要恢复的数据库：3.5 测试主机-启动数据库到nomount状态在测试主机上，以oracle用户登陆数据库，以dba权限启动数据库到nomount状态：$ rman target /recovery manager: release 9.2.0.7.0 - 64bit productioncopyright (c) 1995, 2002, oracle corporation. all rights r

8、eserved.connected to target database (not started)rman> startup nomount;oracle instance startedtotal system global area11027857208 bytesfixed size757560 bytesvariable size2432696320 bytesdatabase buffers8589934592 bytesredo buffers4468736 bytes3.6 测试主机-恢复把握文件在测试主机上，使用工具rman来恢复数据库的把握文件：rman> ru

9、n2> allocate channel d1 device type sbt parms ”env=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)”;3> restore controlfile from ”c-1625137697-20110826-01”; 4> release channel d1;5> using target database controlfile instead of recovery catalog allocated channel: d1channel d1:

10、sid=15 devtype=sbt_tapechannel d1: tivoli data protection for oracle: version 5.2.0.0starting restore at 26-aug-11channel d1: restoring controlfile channel d1: restore complete replicating controlfileinput filename=/dev/rlvfwsk_cntrl1 output filename=/dev/rlvfwsk_cntrl2 output filename=/dev/rlvfwsk_

11、cntrl3 finished restore at 26-aug-11released channel: d13.7 测试主机-更改数据库到mount状态在测试主机上，等把握文件恢复完成后，更改数据库到mount状态：rman> alter database mount;database mounted3.8 测试主机-恢复数据文件rman> run 2> allocate channel d1 device type sbt parms”env=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)”;3&g

12、t; allocate channel d2 device type sbt parms ”env=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)”;4> restore database;5> allocated channel: d1channel d1: sid=15 devtype=sbt_tapechannel d1: tivoli data protection for oracle: version 5.2.0.0allocated channel: d2channel d2: sid=17 de

13、vtype=sbt_tapechannel d2: tivoli data protection for oracle: version 5.2.0.0starting restore at 26-aug-11channel d1: starting datafile backupset restorechannel d1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /dev/rlvfwsk_systemrestoring datafile 00002 to /dev/rlvfws

14、k_undotbs1 restoring datafile 00004 to /dev/rlvfwsk_08g_01 restoring datafile 00007 to /dev/rlvfwsk_08g_03 restoring datafile 00010 to /dev/rlvfwsk_16g_02 restoring datafile 00012 to /dev/rlvfwsk_16g_04 restoring datafile 00013 to /dev/rlvfwsk_08g_06 restoring datafile 00015 to /dev/rlvfwsk_16g_06 r

15、estoring datafile 00017 to /dev/rlvfwsk_16g_08 restoring datafile 00019 to /dev/rlvfwsk_08g_07 restoring datafile 00021 to /dev/rlvfwsk_16g_10 restoring datafile 00023 to /dev/rlvfwsk_08g_09 restoring datafile 00024 to /dev/rlvfwsk_04g_02 restoring datafile 00026 to /dev/rlvfwsk_016g_12 restoring da

16、tafile 00029 to /dev/rlvfwsk_08g_10restoring datafile 00030 to /dev/rlvfwsk_16g_14 restoring datafile 00032 to /dev/rlvfwsk_16g_16 restoring datafile 00034 to /dev/rlvfwsk_02g_01 restoring datafile 00037 to /dev/rlvfwsk_04g_04 restoring datafile 00039 to /dev/rlvfwsk_16g_18 restoring datafile 00040

17、to /dev/rlvfwsk_08g_12 restoring datafile 00041 to /dev/rlvfwsk_04g_06 restoring datafile 00043 to /dev/rlvfwsk_16g_19 restoring datafile 00044 to /dev/rlvfwsk_16g_20 restoring datafile 00046 to /dev/rlvfwsk_02g_03 restoring datafile 00048 to /dev/rlvfwsk_16g_22 restoring datafile 00051 to /dev/rlvf

18、wsk_16g_24 restoring datafile 00054 to /dev/rlvfwsk_16g_27 restoring datafile 00056 to /dev/rlvfwsk_16g_29 restoring datafile 00057 to /dev/rlvfwsk_08g_14 restoring datafile 00060 to /dev/rlvfwsk_08g_16 restoring datafile 00062 to /dev/rlvfwsk_08g_18 restoring datafile 00064 to /dev/rlvfwsk_08g_20 r

19、estoring datafile 00068 to /dev/rlvfwsk_08g_22 restoring datafile 00070 to /dev/rlvfwsk_16g_33 restoring datafile 00071 to /dev/rlvfwsk_16g_34 restoring datafile 00074 to /dev/rlvfwsk_08g_24 restoring datafile 00075 to /dev/rlvfwsk_08g_25 restoring datafile 00078 to /dev/rlvfwsk_08g_27 restoring dat

20、afile 00079 to /dev/rlvfwsk_16g_37 restoring datafile 00080 to /dev/rlvfwsk_16g_38 channel d2: starting datafile backupset restorechannel d2: specifying datafile(s) to restore from backup setrestoring datafile 00003 to /dev/rlvfwsk_undotbs2 restoring datafile 00005 to /dev/rlvfwsk_08g_02 restoring d

21、atafile 00006 to /dev/rlvfwsk_04g_01restoring datafile 00008 to /dev/rlvfwsk_16g_01 restoring datafile 00009 to /dev/rlvfwsk_08g_05 restoring datafile 00011 to /dev/rlvfwsk_16g_03 restoring datafile 00014 to /dev/rlvfwsk_16g_05 restoring datafile 00016 to /dev/rlvfwsk_16g_07 restoring datafile 00018

22、 to /dev/rlvfwsk_08g_04 restoring datafile 00020 to /dev/rlvfwsk_16g_09 restoring datafile 00022 to /dev/rlvfwsk_16g_11 restoring datafile 00025 to /dev/rlvfwsk_08g_08 restoring datafile 00027 to /dev/rlvfwsk_04g_03 restoring datafile 00028 to /dev/rlvfwsk_16g_13 restoring datafile 00031 to /dev/rlv

23、fwsk_16g_15 restoring datafile 00033 to /dev/rlvfwsk_16g_17 restoring datafile 00035 to /dev/rlvfwsk_06g_01 restoring datafile 00036 to /dev/rlvfwsk_04g_05 restoring datafile 00038 to /dev/rlvfwsk_08g_11 restoring datafile 00042 to /dev/rlvfwsk_quest_01 restoring datafile 00045 to /dev/rlvfwsk_02g_0

24、2 restoring datafile 00047 to /dev/rlvfwsk_16g_21 restoring datafile 00049 to /dev/rlvfwsk_16g_23 restoring datafile 00050 to /dev/rlvfwsk_08g_13 restoring datafile 00052 to /dev/rlvfwsk_16g_25 restoring datafile 00053 to /dev/rlvfwsk_16g_26 restoring datafile 00055 to /dev/rlvfwsk_16g_28 restoring

25、datafile 00058 to /dev/rlvfwsk_16g_30 restoring datafile 00059 to /dev/rlvfwsk_08g_15 restoring datafile 00061 to /dev/rlvfwsk_08g_17 restoring datafile 00063 to /dev/rlvfwsk_08g_19 restoring datafile 00065 to /dev/rlvfwsk_16g_31 restoring datafile 00066 to /dev/rlvfwsk_08g_21 restoring datafile 000

26、67 to /dev/rlvfwsk_04g_07restoring datafile 00069 to /dev/rlvfwsk_16g_32 restoring datafile 00072 to /dev/rlvfwsk_08g_23 restoring datafile 00073 to /dev/rlvfwsk_16g_35 restoring datafile 00076 to /dev/rlvfwsk_08g_26 restoring datafile 00077 to /dev/rlvfwsk_16g_36 restoring datafile 00081 to /dev/rl

27、vfwsk_08g_28 channel d2: restored backup piece 1piece handle=fwsk_1_20110826_10256 tag=level0 params=nullchannel d2: restore complete channel d1: restored backup piece 1piece handle=fwsk_1_20110826_10255 tag=level0 params=null channel d1: restore completefinished restore at 26-aug-11 released channe

28、l: d1released channel: d23.9 测试主机-恢复归档日志我们需要恢复对应的归档日志来确保数据库中数据的全都性。rman> run2> allocate channel d1 device type sbt parms ”env=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)”; 3> allocate channel d2 device type sbt parms ”env=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdp

29、o.opt)”; 4> recover database;5> allocated channel: d1channel d1: sid=15 devtype=sbt_tapechannel d1: tivoli data protection for oracle: version 5.2.0.0allocated channel: d2channel d2: sid=17 devtype=sbt_tapechannel d2: tivoli data protection for oracle: version 5.2.0.0starting recover at 26-aug

30、-11starting media recoverychannel d2: starting archive log restore to default destination channel d1: starting archive log restore to default destination channel d2: restoring archive logarchive log thread=1 sequence=9855 channel d1: restoring archive log archive log thread=2 sequence=7487 channel d

31、2: restoring archive log archive log thread=1 sequence=9856 channel d1: restoring archive log archive log thread=2 sequence=7488 channel d1: restored backup piece 1piece handle=fwsk_arch_20110826_10260 tag=tag20110826t025713 params=null channel d1: restore completechannel d2: restored backup piece 1piece handle=fwsk_arch_20110826_10259 tag=tag20110826t025713 params=null channel d2: restore completearchive log filename=/fwsk/fwskarch11/1_9855.dbf thread=1 sequence=9855 archive log filename=/fwsk/fwskarch11/2_74