Re: Standby 8i and Message ORA-279
Date: Mon, 31 Aug 2009 22:35:07 -0700 (PDT)
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
On Aug 22, 9:08 pm, "Fabrice" <emouc..._at_spaminfonietest.fr> wrote:
> 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
> 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
Received on Tue Sep 01 2009 - 00:35:07 CDT