Re: Checking Dataguard Physical Log apply status

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 Received on Wed Mar 12 2008 - 10:53:44 CDT