Oracle backup and recovery
- by kupa
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?
