Re: Physical Standby Montoring

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Wed, 21 Sep 2011 20:14:58 +0530
Message-ID: <CAJsOtB67K7-a-HvWPXynDONN+E-+wRjca0mOX+ZN40TB8gMm5A_at_mail.gmail.com>

how about writing a shell
taks for the shell will be
0) will fire a query and will grab the scn nos from both sides and also will check archive applied status
1) once you get the scn it will store the difference in a variable 2) if the value stored in the varible > 0 then it will collect the name of the primary, scn no and standby db name and scn no this info, will call mailx or send mail program and will mail to the concerned..

thanks...subodh
On 20 September 2011 23:21, Uzzell, Stephan <SUzzell_at_micros.com> wrote:

> 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
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================


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

Received on Wed Sep 21 2011 - 09:44:58 CDT