RMAN> recover database;

Starting recover at 17-MAR-16 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=1428 channel ORA_DISK_1: reading from backup piece /oracle/backup/2016-03-17/arch_POWERDES_20160317_16.bak channel ORA_DISK_1: piece handle=/oracle/backup/2016-03-17/arch_POWERDES_20160317_16.bak tag=TAG20160317T202918 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/POWERDES/archivelog/2016_03_17/o1_mf_1_1428_cgog3ons_.arc thread=1 sequence=1428 channel default: deleting archived log(s) archived log file name=/oracle/app/oracle/flash_recovery_area/POWERDES/archivelog/2016_03_17/o1_mf_1_1428_cgog3ons_.arc RECID=2 STAMP=906760822 unable to find archived log archived log thread=1 sequence=1429 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 03/17/2016 22:00:29 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1429 and starting SCN of 31576222

RMAN> 

解决:直接恢复到SCN点31576222上

RMAN> recover database until scn 31576222;

Starting recover at 17-MAR-16 using channel ORA_DISK_1

starting media recovery media recovery complete, elapsed time: 00:00:00

Finished recover at 17-MAR-16


转载 作者:csdnhadoop 来源:CSDN 原文:https://blog.csdn.net/csdnhadoop/article/details/50967995