Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

v$archived_log still showing older sequence after failover in datagaurd

user12194321Nov 7 2012 — edited Nov 8 2012

Hi,

oracle version : 11.2.0.2

os : redhat linux 5.8

We did failover due to failure of production database in datagaurd but if i query v$archived_log still it showing older sequences

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
23541

where current sequence is

SQL> select max(sequence#) from v$log;

MAX(SEQUENCE#)
--------------
859

any inputs please

This post has been answered by Shivananda Rao on Nov 7 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2012

Added on Nov 7 2012

#data-guard, #performance-availability

6 comments

1,774 views