Re: Data Guard - Checking Current Status
Date: Mon, 29 Dec 2014 16:08:48 -0800
Message-ID: <CAPt39tskEYgBOXf2v3TUA_-v1=+c6dmzHVuRJWzxbWQ4n6kEwA_at_mail.gmail.com>
Thanks Ivica, if I'm using standby redo logs do you know how to tell if the last commit in the primary redolog files (available on duplexed drive) was also applied to the standby redo logs?
On Mon, Dec 29, 2014 at 3:15 PM, Ivica Arsov <iarsov_at_outlook.com> wrote:
> Hi Michael,
>
> You can determine applied archive logs (start and end SCNs) from
> V$ARCHIVE_LOG dictionary view.
> V$ARCHIVE_LOG has a column named APPLIED which is relevant only for
> standby database.
>
>
> Regards,
> Ivica
>
>
> ------------------------------
> Date: Mon, 29 Dec 2014 15:03:26 -0800
> Subject: Data Guard - Checking Current Status
> From: napacunningham_at_gmail.com
> To: oracle-l_at_freelists.org
>
>
> Hello, we are looking for the best way to check if the standby is
> up-to-date (or at least how up-to-date it really is) when it is necessary
> to fail over.
>
> Oracle 12cR1 on Linux
>
> The scenario is the primary server has crashed and we are faced with
> finding out how up-to-date the standby is. It would be nice to know the
> scn if possible.
>
> We are configured with standby redo logs in Maximum Performance mode. If
> this is not enough info please let me know.
>
> P.S. We are currently querying v$dataguard_stats and we can see the datum
> info, but we are curious if there is better info we could/should be looking
> at.
>
> --
> Michael Cunningham
>
-- Michael Cunningham -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 30 2014 - 01:08:48 CET