Re: Checking Dataguard Physical Log apply status

From: <fitzjarrell_at_cox.net>
Date: Wed, 12 Mar 2008 08:57:23 -0700 (PDT)
Message-ID: <45a31958-fb15-4a4e-970b-ca4566ba7137@v3g2000hsc.googlegroups.com>


On Mar 12, 10:53 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Mar 12, 8:00 am, "Pete's" <empete2..._at_yahoo.com> wrote:
>
>
>
>
>
> > On Mar 11, 4: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
>
> > My apologies, I forgot to mention it was 10.2.0.3 for Oracle.
>
> > Pete's- Hide quoted text -
>
> > - Show quoted text -
>
> And querying V$ARCHIVE_GAP doesn't provide any useful information?
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

Or, better yet, query V$ARCHIVE_DEST_STATUS from the primary.

David Fitzjarrell Received on Wed Mar 12 2008 - 10:57:23 CDT

Original text of this message