Re: Interesting but URGENT Case: Online Backup which never gets consistent

"Eric Tallas" <user_at_example.net> wrote in message news:fdPqb.6$_47.809_at_se2-fa199-9.gva.ch.colt.net...
> Richard Foote wrote:
>
>
> I copied all the redo logs and archived redo logs to the other machine.
> That's what happens when I do an incomplete recovery:
>
> SQL> recover database until cancel;
> ORA-00279: change 566155031 generated at 11/07/2003 04:37:05 needed for
> thread
> 1
> ORA-00289: suggestion : /opt/oracle/arch/DB/arch_1_6426.arc
> ORA-00280: change 566155031 for thread 1 is in sequence #6426
>
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>
> ORA-00279: change 566156031 generated at 11/07/2003 04:46:33 needed for
> thread
> 1
> ORA-00289: suggestion : /opt/oracle/arch/DB/arch_1_6427.arc
> ORA-00280: change 566156031 for thread 1 is in sequence #6427
> ORA-00278: log file '/opt/oracle/arch/DB/arch_1_6426.arc' no longer needed
> for this recovery
>
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>
> ORA-00279: change 566156864 generated at 11/07/2003 05:06:46 needed for
> thread
> 1
> ORA-00289: suggestion : /opt/oracle/arch/DB/arch_1_6428.arc
> ORA-00280: change 566156864 for thread 1 is in sequence #6428
> ORA-00278: log file '/opt/oracle/arch/DB/arch_1_6427.arc' no longer needed
> for this recovery
>
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> cancel
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
> below
> ORA-01196: file 1 is inconsistent due to a failed media recovery session
> ORA-01110: data file 1: '/opt/oracle/oradata/DB/system01.dbf'
>
>
> ORA-01112: media recovery not started
>
> No matter the way I do the incomplete recover, using backup controlfile
> or generating a new controlfile, I never can open the database. Any idea?
>
> Thanks in advance,
>
> Eric

The error is in your recovery command. Since you copied across a binary version of the control file, the correct recovery command must be:

recover database until cancel using backup control file;

When prompted for the bit of redo you don't have, type the word 'cancel'. Then issue an 'alter database open resetlogs'.

Regards
HJR Received on Fri Nov 07 2003 - 12:58:04 CST