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

From: Eric Tallas <user_at_example.net>
Date: Fri, 07 Nov 2003 13:26:48 GMT
Message-ID: <s4Nqb.5$_47.639@se2-fa199-9.gva.ch.colt.net>

Frank wrote:

> 1st of all, you run hot backups, so they are never consistent.
> By definition.

ACK, but I think you know what I mean: "I can't open the database after incomplete recovery".

> And why do you offer the 6425 file when Oracle asks for the 6424?

What I forgot to copy & paste was:

SQL> RECOVER DATABASE
ORA-00279: change 566146715 generated at 11/07/2003 04:03:48 needed for thread
1
ORA-00289: suggestion : /shop/oracle/arch/ISTOY2/arch_1_6424.arc ORA-00280: change 566146715 for thread 1 is in sequence #6424

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00328: archived log ends at change 566147250, need later change 281474976710655
ORA-00334: archived log: '/shop/oracle/arch/ISTOY2/arch_1_6424.arc'

After that I offered 6425 to see if change 566146715 was in this file.

Regards,

Eric Received on Fri Nov 07 2003 - 07:26:48 CST