Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to perform media recovery because of missing archive log

venkat vankayalaMay 3 2012 — edited May 14 2012
Hello ,

I am restoring database using old rman backup , during the recovery point i am facing below errors , i do not have any archive log file the media recovery is looking . Is there any way that i can open the database using until scn or until sequence ( i tried both which did not go thru ) . Please suggest

RMAN> recover database;

Starting recover at 03-MAY-12
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8

starting media recovery

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/03/2012 16:30:08
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 10 and starting SCN of 259735916381 found to restore

Thanks
Venkat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2012
Added on May 3 2012
2 comments
9,227 views