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';