Primary and Standby Database archive log sequence issue.
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,