Database Administration (MOSC)

MOSC Banner

Primary and Standby Database archive log sequence issue.

edited May 25, 2014 12:00PM in Database Administration (MOSC) 3 commentsAnswered

Hello,

On my primary database,

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIM NEXT_TIME

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

        90 15-MAY-14 16-MAY-14

        90 15-MAY-14 16-MAY-14

        91 16-MAY-14 16-MAY-14

        91 16-MAY-14 16-MAY-14

        92 16-MAY-14 16-MAY-14

        92 16-MAY-14 16-MAY-14

172 rows selected.

SQL>

You could see the above output of select statement is giving duplicate  SEQUENCE# (like 90,90 | 91,91) etc.

The issue is only exist on primary database.

Please suggest action for the above issue.

Regards,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center