RE: Poor man's standby monitoring
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <deshpande.subodh@xxxxxxxxx>, <William.Blanchard@xxxxxxxxxxxxx>
- Date: Wed, 22 Dec 2010 11:02:08 -0500
I've used
SELECT max(decode(PROCESS, 'MRP0',
sequence#))-max(decode(process,'RFS',decode(CLIENT_PROCESS,'LGWR',
SEQUENCE#),NULL))current_log_gap
FROM V$MANAGED_STANDBY;
for a long time to find my gaps. Works like a dream. Expected value is
0, anything else is trouble.
Dick Goulet
Senior Oracle DBA
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Subodh Deshpande
Sent: Tuesday, December 21, 2010 8:33 AM
To: William.Blanchard@xxxxxxxxxxxxx
Cc: ORACLE-L
Subject: Re: Poor man's standby monitoring
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:
