泉源：网海拾贝
AIX平台：4.3.3
Oracle版本： 8.0.5
从节点RS/6000 h50b备份的数据现恢复到节点43p-db。
43p-db：
一、把43p-db的tdpo_node文件的TDPO_NODE改为 h50b的node name
# vi /usr/tivoli/tsm/client/oracle/bin/tdpo.opt TDPO_NODE tdp_h50b # cd /usr/tivoli/tsm/client/oracle/bin/ # tdpoconf password 引导引导引导引导引导引导引导引导引导引导 * Tivoli Data Protection for Oracle Utility * * Password file initialization/update program * * ROOT privilege needed to update value * 引导引导引导引导引导引导引导引导引导引导* Please enter current password: Please enter new password: Please reenter new password for verification: ANU0260I Password successfully changed.
二、Copy h50B的configora8_sb.ora initora8_sb.ora和口令文件到43p-db呼应目录。全部呼应的目录都要事后树立好。
三、43p-db的oracle为Startup nomount环境。
在H50b: 恢复节制文件 $ export ORACLE_SID=ora8_sb $ rman target system/passwd1@43p-db rcvcat rman/rman@forjy Recovery Manager: Release 8.0.5.2.1 - Production RMAN-06006: connected to target database: ora8_sb (not mounted) RMAN-06008: connected to recovery catalog database RMAN> run { allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)'; restore controlfile to '/sbfs/ctl01sb.ctl'; release channel t1; allocate channel d1 type disk; replicate controlfile from '/sbfs/ctl01sb.ctl'; sql 'alter database mount'; release channel d1; } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: t1 RMAN-08500: channel t1: sid=12 devtype=SBT_TAPE RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel t1: starting datafile backupset restore RMAN-08502: set_count=0 set_stamp=0 RMAN-08021: channel t1: restoring controlfile RMAN-08505: output filename=/sbfs/ctl01sb.ctl RMAN-08023: channel t1: restored backup piece 1 RMAN-08511: piece handle=ORA8_SB_full_497711454_17_1 params=NULL RMAN-08024: channel t1: restore complete RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: t1 RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=12 devtype=DISK RMAN-03022: compiling command: replicate RMAN-03023: executing command: replicate RMAN-08058: replicating controlfile RMAN-08506: input filename=/sbfs/ctl01sb.ctl RMAN-08505: output filename=/sbfs/sbdata1/ctl02sb.ctl RMAN-08505: output filename=/sbfs/sbdata2/ctl03sb.ctl RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter database mount RMAN-03023: executing command: sql RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: d1 RMAN>exit Recovery Manager complete.
四、获取比来ARCHIVED REDO LOGS线程中最小的SCN号，中断不完全恢复。
在h50b上 SQL> SELECT min(scn) FROM (SELECT max(next_change#) scn FROM v$archived_log GROUP BY thread#); MIN(SCN) ---------- 99561745
五、恢双数据文件
$ rman target system/passwd1@43p-db rcvcat rman/rman@forjy Recovery Manager: Release 8.0.5.2.1 - Production RMAN-06005: connected to target database: ORA8_SB RMAN-06008: connected to recovery catalog database RMAN> run { set until scn= 99561745; allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)'; restore database; recover database; release channel t1; sql "alter database open resetlogs"; } RMAN-03022: compiling command: set RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: t1 RMAN-08500: channel t1: sid=10 devtype=SBT_TAPE RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel t1: starting datafile backupset restore RMAN-08502: set_count=17 set_stamp=497711454 RMAN-08019: channel t1: restoring datafile 1 RMAN-08509: destination for restore of datafile 1: /sbfs/system01sb.dbf RMAN-08019: channel t1: restoring datafile 2 RMAN-08509: destination for restore of datafile 2: /sbfs/rbs01sb.dbf RMAN-08019: channel t1: restoring datafile 3 RMAN-08509: destination for restore of datafile 3: /sbfs/temp01sb.dbf RMAN-08019: channel t1: restoring datafile 4 RMAN-08509: destination for restore of datafile 4: /sbfs/tools01sb.dbf RMAN-08019: channel t1: restoring datafile 5 RMAN-08509: destination for restore of datafile 5: /sbfs/users01sb.dbf RMAN-08019: channel t1: restoring datafile 6 RMAN-08509: destination for restore of datafile 6: /sbfs/sb01.dbf RMAN-08019: channel t1: restoring datafile 7 RMAN-08509: destination for restore of datafile 7: /sbfs/isb01.dbf RMAN-08019: channel t1: restoring datafile 8 RMAN-08509: destination for restore of datafile 8: /sbfs/rman/rman_sc.dbf RMAN-08023: channel t1: restored backup piece 1 RMAN-08511: piece handle=ORA8_SB_full_497711454_17_1 params=NULL RMAN-08024: channel t1: restore complete RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete RMAN-03022: compiling command: recover RMAN-03022: compiling command: recover(1) RMAN-03023: executing command: partial resync RMAN-03022: compiling command: recover(2) RMAN-03022: compiling command: recover(3) RMAN-03023: executing command: recover(3) RMAN-08054: starting media recovery RMAN-08060: unable to find archivelog RMAN-08510: archivelog thread=1 sequence=12 RMAN-03022: compiling command: recover(4) RMAN-03023: executing command: recover(4) RMAN-08017: channel t1: starting archivelog restore to default destination RMAN-08022: channel t1: restoring archivelog RMAN-08510: archivelog thread=1 sequence=12 RMAN-08023: channel t1: restored backup piece 1 RMAN-08511: piece handle=ORA8_SB_arch_497711757_18_1 params=NULL RMAN-08024: channel t1: restore complete RMAN-08515: archivelog filename=/user/oracle/app/oracle/product/8.0.5/dbs/arch1_12.dbf thread=1 sequence=12 RMAN-08055: media recovery complete RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: t1 RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter database open resetlogs RMAN-03023: executing command: sql RMAN>
版权声明： 原创作品，应允转载，转载时请务必以超链接体式格局标明文章 原始来由 、作者信息和本声明。否则将追究轨则责任。