Checking Dataguard Physical Log apply status
Date: Tue, 11 Mar 2008 14:23:56 -0700 (PDT)
2 node Rac cluster on AIX 5.3 tl05 sp04 setup with dataguard shipping logs to a single instance standby. Standby redo logs are created and is in Maximum Availability Mode.
What's the best way in checking the status of which log sequences have been applied? I have looked at gv$archive_dest comparing the log sequences.
For checking the sequence number, this works most of the time, however, once in a while there is a log that is not applied and therefore, they standby is out of sync with the primary. When this has happened, I then have run the following:
SELECT MAX(R.SEQUENCE#) LAST_SEQ_RECD, MAX(L.SEQUENCE#) LAST_SEQ_SENT
FROM V$ARCHIVED_LOG R,
WHERE R.DEST_ID=2 AND L.ARCHIVED='YES'; But, this does not appear to reveal which logs have been applied. Any advice on how to check how closely the Standby is synchronized with the Primary? Obviously I want to run checks on a time interval(at a minimum).
Pete's Received on Tue Mar 11 2008 - 16:23:56 CDT