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
Oracle
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