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

From: Frank <fbortel_at_nescape.net>
Date: Wed, 26 Nov 2003 21:40:51 +0100
Message-ID: <bq32kp$3bc$2@news4.tilbu1.nb.home.nl>

Eric Tallas wrote:

> 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
>

OK - got ya.

After the cancel, did you try shutdown, mount, recover database, open resetlogs? Sometimes you need to be rather hard on oracle to allow incomplete recovery ;-)

-- 
Regards, Frank van Bortel

Received on Wed Nov 26 2003 - 14:40:51 CST