Re: Standby 8i and Message ORA-279
Date: Sat, 22 Aug 2009 09:20:10 -0700 (PDT)
On Aug 22, 9:08 am, "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
It's been a while since I have been responsible for a standby database but that looks pretty reasonable to me.
Did you take a look at metalink?
If you are now inheriting responsibility for this system it is probably a good time to document exactly how it was setup and how it is being maintained ( or not ). Received on Sat Aug 22 2009 - 11:20:10 CDT