High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

v$archived_log on standby is showing wrong info for dest_id=2

Hi There,

While checking the archive log gap between primary and standby databases, found some interesting information, for  which I would like to know the reason behind.

Primary and standby both are in synch as per alert log and MRP status, but querying  v$archived_log on standby is showing wrong information for dest_id=2  [ primary database archive location ].

On Primary

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

SELECT MAX(SEQUENCE#) from v$archived_log WHERE DEST_ID=1 AND ARCHIVED='YES';   --> latest archive which is been archived on primary

MAX(SEQUENCE#)

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

169327

SELECT MAX(SEQUENCE#) from v$archived_log WHERE DEST_ID=2 AND ARCHIVED='YES';

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