Standby database errors

[omegamark]

When trying to sync the standby with the primary I am getting the ORA-279 errors .What type of action should be taken ...

Tue Oct 23 09:04:54 2001
ALTER DATABASE RECOVER standby database
Tue Oct 23 09:04:54 2001
Media Recovery Start
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER standby database ...
Tue Oct 23 09:04:59 2001
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log /oradata/archive/SPRDPROD/SPRDPROD59330.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Oct 23 09:05:04 2001
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log /oradata/archive/SPRDPROD/SPRDPROD59331.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ..

[Raminder]

Excerpt from oracle documentation

ORA-00279 change string generated at string needed for thread string
Cause: The requested log is required to proceed with recovery.
Action: Supply the requested log with ALTER DATABASE RECOVER LOGFILE filename or cancel recovery with ALTER DATABASE RECOVER CANCEL.

Obviously you are missing a redo log.

[omegamark]

If one logfile is missing how does the recovery proceeds ???
I have put the recovery in the auto mode .The recovery is going on ???If there is no logfile should not it stop


ORA-00279: change 235004010 generated at 10/22/2001 21:23:49 needed for thread 1
ORA-00289: suggestion : /oradata/archive/SPRDPROD/SPRDPROD59384.arc
ORA-00280: change 235004010 for thread 1 is in sequence #59384
ORA-00278: log file '/oradata/archive/SPRDPROD/SPRDPROD59383.arc' no longer need
ed for this recovery
Log applied.
ORA-00279: change 235030416 generated at 10/22/2001 21:56:15 needed for thread 1
ORA-00289: suggestion : /oradata/archive/SPRDPROD/SPRDPROD59385.arc
ORA-00280: change 235030416 for thread 1 is in sequence #59385
ORA-00278: log file '/oradata/archive/SPRDPROD/SPRDPROD59384.arc' no longer need
ed for this recovery
Log applied.
ORA-00279: change 235056770 generated at 10/22/2001 22:24:58 needed for thread 1
ORA-00289: suggestion : /oradata/archive/SPRDPROD/SPRDPROD59386.arc
ORA-00280: change 235056770 for thread 1 is in sequence #59386
ORA-00278: log file '/oradata/archive/SPRDPROD/SPRDPROD59385.arc' no longer need
ed for this recovery
Log applied.
ORA-00279: change 235082620 generated at 10/22/2001 23:48:20 needed for thread 1
ORA-00289: suggestion : /oradata/archive/SPRDPROD/SPRDPROD59387.arc
ORA-00280: change 235082620 for thread 1 is in sequence #59387
ORA-00278: log file '/oradata/archive/SPRDPROD/SPRDPROD59386.arc' no longer need
ed for this recovery

[noplasma]

The manual recovery will always ask for the "next" redo log, even it has applied all logs that exist. Just apply the archive logs from your gap, and then put it in managed recovery mode.