Standby Server logs not applying - missing sequence

[former_member199632]

Hi,

In the standby server logs are not applying & it ends with following error message

-------------

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Oct 17 07:00:31 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> SQL> Connected.

SQL>

SQL> SQL> ORA-00279: change 4567483678 generated at 10/15/2014 18:07:53 needed for thread 1

ORA-00289: suggestion : /oracle/PRD/oraarch/standby/PRDarch1_57308_696018700.dbfORA-00280: change 4567483678 for thread 1 is in sequence #57308

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00310: archived log contains sequence 57305; sequence 57308 required

ORA-00334: archived log: '/oracle/PRD/oraarch/standby/PRDarch1_57305_696018700.dbf'

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.

--------------

In the archive log folder all the log files are available. From 57200 to 57320

Why this sort of error occurs and how to solve this. (missing the sequence,and it occurs quite regularly as well)

In above, why its ignore 57306, 57307 & asking for 57308

regards,

zerandib

[Former Member]

Hi Zerandib,

Have you tried re-registering the missing log files? We have to run command like this periodically:
ALTER DATABASE REGISTER OR REPLACE LOGFILE  'E:\Oracle\EC1\STBY_Archive\EC122662.001';

Hope that is helpful.

J. Haynes

[Reagan]

Could you supply the contents from the alert log when you are getting the above error. If the archive log sequence numbers 57306 and 57307 are applied then they are no longer required. Again check the alert log for more information.

Cheers

RB