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

From: Eric Tallas <user_at_example.net>
Date: Fri, 07 Nov 2003 15:52:43 GMT
Message-ID: <fdPqb.6$_47.809@se2-fa199-9.gva.ch.colt.net>

Richard Foote wrote:

> Ooooppps, something I forgot to mention.
>
> After you performed your online backup, did you make sure you archived the
> current online redo log and copied it across as well ?
>
> You'll need all the redo logs generated during the backup to ensure that the
> database can resync itself. And that'll hence include the current online
> redo as well.

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 Received on Fri Nov 07 2003 - 09:52:43 CST