William,
I have a shell-script named "stdby_chk.sh" posted at
http://www.EvDBT.com/tools.htm that might be helpful. At it's core,
it is a query against V$LOG_HISTORY and just compares the
differences between the latest archived log SEQUENCE# on each
database.
FYI: for true "poor man's standby", I've also posted three other
venerable shell-scripts (dating from the mid-1990s but used in anger
only a few years ago, for Std Edition standby) named
"stdby_init.sh", "stdby_ship.sh", and "stdby_applylogs.sh", on the
same page.
Hope this helps...
Tim Gorman
consultant -> Evergreen Database Technologies, Inc.
postal => 13087 West Cedar Drive #225, Lakewood CO 80228
website => http://www.EvDBT.com/
email => Tim@xxxxxxxxx
mobile => +1-303-885-4526
fax => +1-303-484-3608
Lost Data? => http://www.ora600.be/ for info about DUDE...
On 12/20/2010 2:51 PM, Blanchard, William G 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.
_____________
--
//www.freelists.org/webpage/oracle-l
|
