Error : Starting recover at 24-APR-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1072 device type=DISK starting media recovery media recovery failed RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 04/24/2018 14:54:07 ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed start until cancel using backup controlfile ORA-00283: recovery session canceled due to errors ORA-38760: This database instance failed to turn on flashback database
Cause :
Database was in flashback mode.
Solution :
trun off flashback mode and rerun recovery.
SQL> alter database flashback off; Database altered. SQL> RMAN> run { set until sequence 576; recover database; }2> 3> 4> 5> executing command: SET until clause Starting recover at 24-APR-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1072 device type=DISK 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=573 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=574 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=575 channel ORA_DISK_1: reading from backup piece /d02/dbbackup/RMAN_backup1/RMAN_BKPMon_23Apr18/ar_974238549_2165_1 channel ORA_DISK_1: errors found reading piece handle=/d02/dbbackup/RMAN_backup1/RMAN_BKPMon_23Apr18/ar_974238549_2165_1 channel ORA_DISK_1: failover to piece handle=/d01/oracln/backup/RMAN_BKPMon_23Apr18/ar_974238549_2165_1 tag=TAG20180423T211704 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:02:25 archived log file name=/d01/oracln/data/archive1_573_970862557.dbf thread=1 sequence=573 archived log file name=/d01/oracln/data/archive1_574_970862557.dbf thread=1 sequence=574 archived log file name=/d01/oracln/data/archive1_575_970862557.dbf thread=1 sequence=575 media recovery complete, elapsed time: 00:00:27 Finished recover at 24-APR-18 RMAN>
Recovery Manager complete.