Oracle 11g如何将dataguard的主库数据恢复到Oracle单机(2)

因为前面恢复了整个spfile已经controlfile,所以接下来恢复所有库的话,就不用带参数,直接恢复restore database就可以 ;

RMAN> restore database; Starting restore at 26-NOV-15 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /home/oradata/orcstu/system01.dbf channel ORA_DISK_1: restoring datafile 00002 to /home/oradata/orcstu/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00003 to /home/oradata/orcstu/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00004 to /home/oradata/orcstu/users01.dbf channel ORA_DISK_1: restoring datafile 00005 to /home/oradata/orcstu/orcstuk01.dbf channel ORA_DISK_1: restoring datafile 00006 to /home/oradata/orcstu/plas01.dbf channel ORA_DISK_1: restoring datafile 00007 to /home/oradata/orcstu/pl01.dbf channel ORA_DISK_1: restoring datafile 00008 to /home/oradata/orcstu/help01.dbf channel ORA_DISK_1: restoring datafile 00009 to /home/oradata/orcstu/adobelc01.dbf channel ORA_DISK_1: restoring datafile 00010 to /home/oradata/orcstu/sms01.dbf channel ORA_DISK_1: restoring datafile 00011 to /home/oradata/orcstu/plcrm01.dbf channel ORA_DISK_1: restoring datafile 00012 to /home/oradata/orcstu/orcstuk02.dbf channel ORA_DISK_1: restoring datafile 00013 to /home/oradata/orcstu/datagm01.dbf channel ORA_DISK_1: reading from backup piece /data/impdp/2015-11-26/full_orcstu_20151126_5037.bak channel ORA_DISK_1: piece handle=/data/impdp/2015-11-26/full_orcstu_20151126_5037.bak tag=TAG20151126T030008 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:32:50 Finished restore at 26-NOV-15 RMAN>

1

5,recover数据库 RMAN> recover database; Starting recover at 26-NOV-15 using channel ORA_DISK_1 starting media recovery channel ORA_DISK_1: starting archived log restore to default destination channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=39674 channel ORA_DISK_1: reading from backup piece /data/impdp/2015-11-26/arch_orcstu_20151126_5038.bak channel ORA_DISK_1: piece handle=/data/impdp/2015-11-26/arch_orcstu_20151126_5038.bak tag=TAG20151126T032346 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 archived log file name=/oracle/app/oracle/flash_recovery_area/archivelog1_39674_821708334.dbf thread=1 sequence=39674 unable to find archived log archived log thread=1 sequence=39675 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 11/26/2015 21:48:13 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 39675 and starting SCN of 11688009482 RMAN> 后台alert日志: 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 Completed: alter database recover datafile list 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 alter database recover if needed start until cancel using backup controlfile Media Recovery Start started logmerger process Parallel Media Recovery started with 4 slaves ORA-279 signalled during: alter database recover if needed start until cancel using backup controlfile ... alter database recover logfile '/oracle/app/oracle/flash_recovery_area/archivelog1_39674_821708334.dbf' Media Recovery Log /oracle/app/oracle/flash_recovery_area/archivelog1_39674_821708334.dbf ORA-279 signalled during: alter database recover logfile '/oracle/app/oracle/flash_recovery_area/archivelog1_39674_821708334.dbf'... Thu Nov 26 21:48:13 2015 alter database recover cancel Media Recovery Canceled Completed: alter database recover cancel

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/9478e6232080127c2f522a13024b5468.html