Re: Poor man's standby monitoring

  • From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
  • To: William.Blanchard@xxxxxxxxxxxxx
  • Date: Tue, 21 Dec 2010 19:02:51 +0530

you want to find out the gap between priamry and standby database archives
shipped

use the view v$archive_gap on primary

Thanks!
Subodh

On 21 December 2010 03:21, Blanchard, William G <
William.Blanchard@xxxxxxxxxxxxx> wrote:

>  Does anyone have a script or know a way to monitor a poor man’s standby
> (log shipping) to see how far behind it is and send an alert if it falls x
> minutes behind?
>
>
>
> DB: 10g & 11g
>
> OS: Windows, Solaris, Linux, AIX
>
>
>
>
>
> Thank you,
>
>
>
> WGB
> _____________
>
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i) delete the
> message and all copies; (ii) do not disclose, distribute or use the message
> in any manner; and (iii) notify the sender immediately. In addition, please
> be aware that any message addressed to our domain is subject to archiving
> and review by persons other than the intended recipient. Thank you.
> _____________
>



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

Other related posts: