RE: RMAN validate

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 8 Mar 2007 14:18:44 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08C03@EXCNYSM0A1AJ.nysemail.nyenet>

Ryan,

Rman is pretty consistent with error reporting. I always grep for two things: for the string RMAN-00569 for errors, and for the string "Recovery Manager complete." To make sure that it ran to completion. If Rman just plain dies, the log file just stops. The second grep checks to see if Rman finished.  

Tom    

if [ `grep -l RMAN-00569 $JOBLOG | wc -l` -gt 0 ]; then

   mailx -s "${MAILMSG} ** Failure ** " $MAIL_LIST < $JOBLOG

fi  

# This grep checks for the "Recovery Manager Complete" string

if [ `grep -l "Recovery Manager complete." $JOBLOG | wc -l` -eq 0 ]; then

   mailx -s "${MAILMSG} ** Failure **" $MAIL_LIST < $JOBLOG

fi  

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan_gaffuri_at_comcast.net
Sent: Thursday, March 08, 2007 1:53 PM
To: oracle-l_at_freelists.org
Subject: RMAN validate  

There are lots of examples of successful validate outputs. Does anyone have an example of a failure or preferably some keywords that are in an output of a validate that fails? I need something to grep for so I can send out an email if a validate fails.  

thanks

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

Received on Thu Mar 08 2007 - 13:18:44 CST