Standby 8i and Message ORA-279
Fabrice
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.
John Hurley
snip
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 ).
ddf
I see no disconnect in this script, so is this running in the same
session which started from a previous run of this script? The error
appears to be notifying you that autorecovery is already on.
David Fitzjarrell
Hemant K Chitale
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