Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database recovery failed

808880Dec 21 2011 — edited Dec 21 2011
All,

I'm doing backup restore for RAC Database to Single instance On another node.I'm getting following error .

Version : 11.2.0.2.0 Platform : Linux
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 10397075928425 generated at 12/09/2011 02:47:38 needed for
thread 1
ORA-00289: suggestion :
/mounts/dprd_restore/owctst/arch/owcprd_arch_R745240531_T1_S19607.arc
ORA-00280: change 10397075928425 for thread 1 is in sequence #19607


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/mounts/dprd_restore/owctst/arch/owcprd_arch_R745240531_T1_S19607.arc
ORA-00279: change 10397075928425 generated at  needed for thread 2


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/mounts/dprd_restore/owctst/oradata/owctst/dbfiles/system01.dbf'
Can you please advice on this?

Thanks.
This post has been answered by unknown-698157 on Dec 21 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2012
Added on Dec 21 2011
4 comments
974 views