Eric, How are you doing your backup - OS cold, OS hot, RMAN or other? How are you scheduling it?
For information - If you use OEM this can be achieved automatically by setting it to email on failed jobs. Otherwise, some options are: at the end of export command check %errorlevel% - if not 0 then you have an error This may well work after RMAN or ocopy but I haven't checked to confirm that. Alternatively, search the log files (via find or whatever) for strings such as "ora-", "exp-" etc Checking errorlevel will show you if it was found. Then you need to send an email - 1 freeware cmd line approach is to use blat http://www.blat.net In the past others have mentioned Automailer (http://www.duodata.de/automailer/) and I'm sure there are others. I'm sure it also could be done using Perl, Cygwin, VBScript or any other scripting tool as well. If you have some more specific questions then get back to the list. Regards, Bruce Reardon -----Original Message----- Sent: Thursday, 29 August 2002 8:09 Does anyone have a script (or some method) that works on NT to send an email to someone if a backup failed? There are two types of backups currently running including an export and hot backup. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
