Hi,
This is related to database recovery.
Yesterday my production database was crashed due to some OS/ hardware failure.
Now I am trying to do database recovery.
We have a hot backup of October 31 and applying all archive logs.
At the time of applying the logs, recovery is stuck on a particular log and giving following error;
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 89263610629 generated at 11/12/2014 17:56:28 needed for
thread 1
ORA-00289: suggestion : /arc/archive/1_122_860622797.dbf
ORA-00280: change 89263610629 for thread 1 is in sequence #122
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00328: archived log ends at change 89133742708, need later change
89263610629
ORA-00334: archived log: '/arc/archive/1_122_860622797.dbf'
Please suggest what should I do.
Thanks,
Shanks