Re: Standby 8i and Message ORA-279
Date: Mon, 31 Aug 2009 22:35:07 -0700 (PDT)
Message-ID: <d4ef9f22-f5b6-4405-bf23-48409e2fdd65_at_y10g2000prg.googlegroups.com>
ORA-279 (and ORA-280) isn't an error. It is only a message.
The "CONTINUE DEFAULT" appears because you've set AUTORECOVERY ON, else, Oracle would have continued waiting for the log file.
Hemant K Chitale
http://hemantoracledba.blogspot.com
On Aug 22, 9:08 pm, "Fabrice" <emouc..._at_spaminfonietest.fr> wrote:
> Hello,
>
> I have a production database and a standby under 8i.
> I transfer the archived redo from the production to the standby by script.
>
> Regularly on the standby a script is executed to apply the redo transfered
> on the standby.
>
> The script execute this command :
>
> set autorecovery on
> recover standby database
>
> Everytime Oracle execute my script and apply the redo, I get ORA-279 message
> in the alert.log.
> Oracle always write this message in the alert.log before playing the redo
> logs.
>
> For example, redo files with the sequence 100, 101 and 102 are in the
> directory of the standby.
> The recover is executed by script and I get the message :
>
> ORA-279 signalled during: ALTER DATABASE RECOVER standby database ...
> ALTER DATABASE RECOVER CONTINUE DEFAULT
>
> And in the spool file of my command I can see the ORA-00279, ORA-00289 ... :
>
> ORA-00279: change 51667831821 generated at 07/02/2009 01:19:40 needed for
> thread 1
> ORA-00289: suggestion : /nodal-archive/archive/1_55121_652209172.arc
> ORA-00280: change 51667831821 for thread 1 is in sequence #55121
> ORA-00278: log file '/nodal-archive/archive/1_55120_652209172.arc' no longer
> needed for this recovery
>
> Message ORA-279 before applying each archived redo is a normal behavior ?
>
> Tha,ks for your help
> fabrice.
Received on Tue Sep 01 2009 - 00:35:07 CDT