Re: Checking Dataguard Physical Log apply status

On Mar 11, 5:23 pm, "Pete's" <empete2..._at_yahoo.com> wrote:
> Setup:
>
> 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.
>
> Question:
>
> 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.
>
> select inst_id,dest_id,log_sequence
> from gv$archive_dest;
>
> 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,
> V$LOG L
> 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).
>
> TIA,
> Pete's

In addition to what has already been posted, I use the following on the standby...

select max(trunc((sysdate - applied_time) * 86400))

        from v$standby_apply_snapshot
/

...that will show you the delay in seconds of what has been applied compared to real time. Received on Wed Mar 12 2008 - 14:23:56 CDT