Re: Physical Standby Montoring

From: goran bogdanovic <goran00_at_gmail.com>
Date: Sun, 2 Oct 2011 11:34:13 +0200
Message-ID: <CAGyPXK6Rw04fsQDX6BR=aaqDwYSD5N+A_1yPHLwo2o_JjKpRAA_at_mail.gmail.com>

I am not sure if column archive_gap in v$archive_dest_status on primary is updated correctly and always accurate.
For standby monitoring I collect information from both primary and standby which will give 100% accuracy.

On Tue, Sep 20, 2011 at 8:09 PM, Michael Dinh <mdinh_at_xifin.com> wrote:

> I use cron to monitor
>
>
> select message, severity, timestamp
> from v$dataguard_status
> where severity in ('Error','Fatal')
> and timestamp > sysdate-15/1440;
>
> SELECT sysdate,
> dest_id,status,db_unique_name,recovery_mode,archived_seq#,applied_seq#,
> (CASE WHEN archived_seq#-applied_seq# > 10
> THEN 'Error-' || TO_CHAR (archived_seq# - applied_seq#)
> ELSE TO_CHAR (archived_seq# - applied_seq#)
> END ) archive_gap,
> gap_status
> FROM v$archive_dest_status
> WHERE dest_id = 2;
>
> v$archive_dest_status.gap_status is 11.2.0.2 NF
>
> Michael Dinh
>
> Disparity Breaks Automation (DBA)
>
> NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
> individual or entity to which it is addressed, and may contain information
> that is privileged, confidential and exempt from disclosure under applicable
> laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH
> INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING,
> AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI
> CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT
> NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS
> MESSAGE. If the reader of this email (and attachments) is not the intended
> recipient, you are hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited. Please notify the
> sender of the error and delete the e-mail you received. Thank you.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Uzzell, Stephan
> Sent: Tuesday, September 20, 2011 10:51 AM
> To: Oracle L
> Subject: Physical Standby Montoring
>
> Hey Listers,
> Any cool tricks for monitoring a bunch of physical standby environments? We
> have 20 or so physical standby databases, and are having trouble figuring
> the best strategy to monitor them. We do not currently have enough DBAs to
> sit around watching them.
>
> We are currently using two scheduled tasks to grab the current_scn from
> v$database, alternating every 45 minutes or so; we then parse the two output
> files using perl, do some quick math, and as long as there is a change in
> the SCN, we feel things are probably OK.
>
> The problem is that the SCN does not advance at a regular interval. Some
> database are busier than others. Some database therefore do not have the SCN
> advance between a pair of tests; other times one of the scheduled tasks
> hangs. So we get periodic "BAD" reports that are not really bad.
>
> Definitely not the best system. Any recommendations for the best way to
> monitor - to only get alerts if / when there is actually something wrong?
>
> Thanks!
>
> Stephan Uzzell
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Oct 02 2011 - 04:34:13 CDT