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