Standby 8i and Message ORA-279
Date: Sat, 22 Aug 2009 15:08:05 +0200
Message-ID: <h6ofpi$mnp$1_at_s1.news.oleane.net>
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 Sat Aug 22 2009 - 08:08:05 CDT