Oracle backup and recovery

Posted by kupa on Server Fault See other posts from Server Fault or by kupa
Published on 2010-12-07T11:39:21Z Indexed on 2010/12/27 18:55 UTC
Read the original article Hit count: 179

Filed under:

During recovery Oracle writes the following error:

RMAN-06054: media recovery requesting unknown log: thread 1 seq 9 lowscn 4034762

I have used in mount mode this command:

change archivelog all crosscheck;
delete expired archivelog all;

Then restore and tried to recover again:But still RMAN-06054 error.Than I wrote:

run{
SET UNTIL SEQUENCE 9 THREAD 1;
RESTORE DATABASE;
RECOVER DATABASE;
}

It helped me to recover database...But after that when I do the backup and then recover the same error occurs and solution is the same... I wonder to solve this problem without SET UNTIL SEQUENCE 9 THREAD 1; maybe I should unregister this archive log from control file(I am using control file not catalog) Can you tell me how?

© Server Fault or respective owner

Related posts about Oracle