Srinivasa Yv
asked on
while recovering geting erros
i am facing same problem
SQL> recover database using BACKUP CONTROLFILE until cancel;
ORA-00279: change 7918209709 generated at 06/20/2018 14:57:16 needed for threa
1
ORA-00289: suggestion : I:\ORACLE\AE1\ORAARCH\AE1A RCH1_25698 0_92624441 0.DBF
ORA-00280: change 7918209709 for thread 1 is in sequence #256980
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
I:\oracle\AE1\oraarch_bkp\ AE1ARCH1_2 56980_9262 44410.DBF
ORA-00279: change 7918242496 generated at 06/20/2018 15:00:28 needed for threa
1
ORA-00289: suggestion : I:\ORACLE\AE1\ORAARCH\AE1A RCH1_25698 1_92624441 0.DBF
ORA-00280: change 7918242496 for thread 1 is in sequence #256981
ORA-00278: log file 'I:\oracle\AE1\oraarch_bkp \AE1ARCH1_ 256980_926 244410.DBF '
no longer needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
I:\oracle\AE1\oraarch_bkp\ AE1ARCH1_2 56981_9262 44410.DBF
ORA-00279: change 7918292819 generated at 06/20/2018 15:02:46 needed for threa
1
ORA-00289: suggestion : I:\ORACLE\AE1\ORAARCH\AE1A RCH1_25698 2_92624441 0.DBF
ORA-00280: change 7918292819 for thread 1 is in sequence #256982
ORA-00278: log file 'I:\oracle\AE1\oraarch_bkp \AE1ARCH1_ 256981_926 244410.DBF '
no longer needed for this recovery
SQL> recover database using BACKUP CONTROLFILE until cancel;
ORA-00279: change 7918209709 generated at 06/20/2018 14:57:16 needed for threa
1
ORA-00289: suggestion : I:\ORACLE\AE1\ORAARCH\AE1A
ORA-00280: change 7918209709 for thread 1 is in sequence #256980
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
I:\oracle\AE1\oraarch_bkp\
ORA-00279: change 7918242496 generated at 06/20/2018 15:00:28 needed for threa
1
ORA-00289: suggestion : I:\ORACLE\AE1\ORAARCH\AE1A
ORA-00280: change 7918242496 for thread 1 is in sequence #256981
ORA-00278: log file 'I:\oracle\AE1\oraarch_bkp
no longer needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
I:\oracle\AE1\oraarch_bkp\
ORA-00279: change 7918292819 generated at 06/20/2018 15:02:46 needed for threa
1
ORA-00289: suggestion : I:\ORACLE\AE1\ORAARCH\AE1A
ORA-00280: change 7918292819 for thread 1 is in sequence #256982
ORA-00278: log file 'I:\oracle\AE1\oraarch_bkp
no longer needed for this recovery
those are not errors, those are feedback messages asking what you want to do
in principal, check if the file exists, and hit enter it does
type cancel and enter if the does not exist
in principal, check if the file exists, and hit enter it does
type cancel and enter if the does not exist
>>type cancel and enter if the does not exist
I agree but wanted to point out that canceling will result in an incomplete recovery and likely data loss.
I agree but wanted to point out that canceling will result in an incomplete recovery and likely data loss.
Without all the information, we don't know if or when cancelling is correct.
The big question is why are you doing a recovery using backup controlfile?
If you are doing a complete recovery, when you get to the last archive and it prompts for another one, the last "archive" is the current online log. You will have to give the full path of the online log, Oracle can't figure that part out. If you give it the wrong online log, don't worry, it will give you a message and you can try again. I don't believe that it will give a recovery complete message when it gets to the end of that log, it may prompt again (I'm not sure I ever did a complete recovery with the USING BACKUP CONTROLFILE clause), if it does, then cancel is the right thing as there is no way you can recover further.
I would also say that if you are going to go through all the logs in the directory and are just hitting return at the prompt, use AUTO. That is exactly what it will do, do through the archives that it can find in order. When it can't find one, it stops. Then if you have more somewhere, you can start the recovery again.
That being said, if you are doing a USING BACKUP CONTROLFILE UNTIL CANCEL, you are intending to do an incomplete recovery and data loss would be expected.
The big question is why are you doing a recovery using backup controlfile?
If you are doing a complete recovery, when you get to the last archive and it prompts for another one, the last "archive" is the current online log. You will have to give the full path of the online log, Oracle can't figure that part out. If you give it the wrong online log, don't worry, it will give you a message and you can try again. I don't believe that it will give a recovery complete message when it gets to the end of that log, it may prompt again (I'm not sure I ever did a complete recovery with the USING BACKUP CONTROLFILE clause), if it does, then cancel is the right thing as there is no way you can recover further.
I would also say that if you are going to go through all the logs in the directory and are just hitting return at the prompt, use AUTO. That is exactly what it will do, do through the archives that it can find in order. When it can't find one, it stops. Then if you have more somewhere, you can start the recovery again.
That being said, if you are doing a USING BACKUP CONTROLFILE UNTIL CANCEL, you are intending to do an incomplete recovery and data loss would be expected.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
It has been a long time since I had to perform a recover until cancel but it seems to be going through the archived redo logs fine.