《全数据库的完全恢复.doc》由会员分享,可在线阅读,更多相关《全数据库的完全恢复.doc(17页珍藏版)》请在金锄头文库上搜索。
1、1 全数据库的完全恢复 run allocate channel c11 type disk; allocate channel c12 type disk; allocate channel c21 type sbt_tape; allocate channel c22 type sbt_tape; restore controlfile; alter database mount; restore database; recover database; sql alter database open; release channel c11; release channel c12; re
2、lease channel c21; release channel c22; 恢复步骤如下:$ svrmgrlsvrmgr connect internalsvrmgr startup nomount$ rmanprod recdbs.rcv rec.log &$ tail f rec.log # 观察日志 使用以上以上的全备份可以对数据库进行全库的恢复,并可以在恢复脚本中直接实现数据库归档日志的应用,将数据库自动恢复到最近的日志记录的状态。 注意:恢复时如果有需要应用很多归档日志,则应用该日志时时间会比较长,一定要耐心等待。全恢复日志如下:Recovery Manager: Release
3、 8.0.5.2.1 - ProductionRMAN-00569: =error message stack follows=RMAN-00554: initialization of internal recovery manager package failedRMAN-04005: error from target database: ORA-01034: ORACLE not availableRecovery Manager: Release 8.0.5.2.1 - ProductionRMAN-06005: connected to target database: FJTES
4、TRMAN-06008: connected to recovery catalog databaseRMAN run2 3 allocate channel c11 type disk;4 allocate channel c12 type disk;5 allocate channel c21 type sbt_tape;6 allocate channel c22 type sbt_tape;7 restore database;8 recover database;9 sql alter database open;10 release channel c11;11 release c
5、hannel c12;12 release channel c21;13 release channel c22;14 15 RMAN-03022: compiling command: allocateRMAN-03023: executing command: allocateRMAN-08030: allocated channel: c11RMAN-08500: channel c11: sid=13 devtype=DISKRMAN-03022: compiling command: allocateRMAN-03023: executing command: allocateRMA
6、N-08030: allocated channel: c12RMAN-08500: channel c12: sid=14 devtype=DISKRMAN-03022: compiling command: allocateRMAN-03023: executing command: allocateRMAN-08030: allocated channel: c21RMAN-08500: channel c21: sid=15 devtype=SBT_TAPERMAN-03022: compiling command: allocateRMAN-03023: executing comm
7、and: allocateRMAN-08030: allocated channel: c22RMAN-08500: channel c22: sid=17 devtype=SBT_TAPERMAN-03022: compiling command: setRMAN-03022: compiling command: restoreRMAN-03025: performing implicit partial resync of recovery catalogRMAN-03023: executing command: partial resyncRMAN-08003: starting p
8、artial resync of recovery catalogRMAN-08005: partial resync completeRMAN-03022: compiling command: IRESTORERMAN-03023: executing command: IRESTORERMAN-08016: channel c21: starting datafile backupset restoreRMAN-08502: set_count=28 set_stamp=402253457RMAN-08016: channel c22: starting datafile backups
9、et restoreRMAN-08502: set_count=29 set_stamp=402253577RMAN-08019: channel c21: restoring datafile 1RMAN-08509: destination for restore of datafile 1: /dev/vx/rdsk/datadg/system01RMAN-08019: channel c22: restoring datafile 3RMAN-08509: destination for restore of datafile 3: /dev/vx/rdsk/datadg/tempaR
10、MAN-08019: channel c21: restoring datafile 2RMAN-08509: destination for restore of datafile 2: /dev/vx/rdsk/datadg/rbsaRMAN-08019: channel c22: restoring datafile 16RMAN-08509: destination for restore of datafile 16: /dev/vx/rdsk/datadg/t3s200n1RMAN-08023: channel c21: restored backup piece 1RMAN-08
11、511: piece handle=dbf_28_402253457_1 params=NULLRMAN-08024: channel c21: restore completeRMAN-08016: channel c21: starting datafile backupset restoreRMAN-08502: set_count=31 set_stamp=402253614RMAN-08019: channel c21: restoring datafile 4RMAN-08509: destination for restore of datafile 4: /dev/vx/rds
12、k/datadg/toolsRMAN-08019: channel c21: restoring datafile 7RMAN-08509: destination for restore of datafile 7: /dev/vx/rdsk/datadg/tempbRMAN-08023: channel c22: restored backup piece 1RMAN-08511: piece handle=dbf_29_402253577_1 params=NULLRMAN-08024: channel c22: restore completeRMAN-08016: channel c
13、22: starting datafile backupset restoreRMAN-08502: set_count=32 set_stamp=402253679RMAN-08019: channel c22: restoring datafile 5RMAN-08509: destination for restore of datafile 5: /dev/vx/rdsk/datadg/usersRMAN-08019: channel c22: restoring datafile 13RMAN-08509: destination for restore of datafile 13
14、: /dev/vx/rdsk/datadg/t3s1n1RMAN-08023: channel c21: restored backup piece 1RMAN-08511: piece handle=dbf_31_402253614_1 params=NULLRMAN-08024: channel c21: restore completeRMAN-08016: channel c21: starting datafile backupset restoreRMAN-08502: set_count=30 set_stamp=402253614RMAN-08019: channel c21:
15、 restoring datafile 6RMAN-08509: destination for restore of datafile 6: /dev/vx/rdsk/datadg/rbsbRMAN-08019: channel c21: restoring datafile 17RMAN-08509: destination for restore of datafile 17: /dev/vx/rdsk/datadg/t2s200n8RMAN-08023: channel c21: restored backup piece 1RMAN-08511: piece handle=dbf_30_402253614_1 params=NULLRMAN-08024: cha