Link to home
Start Free TrialLog in
Avatar of Srinivasa Yv
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\AE1ARCH1_256980_926244410.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_256980_926244410.DBF
ORA-00279: change 7918242496 generated at 06/20/2018 15:00:28 needed for threa
1
ORA-00289: suggestion : I:\ORACLE\AE1\ORAARCH\AE1ARCH1_256981_926244410.DBF
ORA-00280: change 7918242496 for thread 1 is in sequence #256981
ORA-00278: log file 'I:\oracle\AE1\oraarch_bkp\AE1ARCH1_256980_926244410.DBF'
no longer needed for this recovery


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
I:\oracle\AE1\oraarch_bkp\AE1ARCH1_256981_926244410.DBF
ORA-00279: change 7918292819 generated at 06/20/2018 15:02:46 needed for threa
1
ORA-00289: suggestion : I:\ORACLE\AE1\ORAARCH\AE1ARCH1_256982_926244410.DBF
ORA-00280: change 7918292819 for thread 1 is in sequence #256982
ORA-00278: log file 'I:\oracle\AE1\oraarch_bkp\AE1ARCH1_256981_926244410.DBF'
no longer needed for this recovery
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

What is the error?

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.
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
>>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.
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.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.