Standby 8i and Message ORA-279

From: Fabrice <>
Date: Sat, 22 Aug 2009 15:08:05 +0200
Message-ID: <h6ofpi$mnp$>


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 Sat Aug 22 2009 - 08:08:05 CDT

Original text of this message