| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Notification of failed backup
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: Bruce.Reardon_at_comalco.riotinto.com.au
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: ListGuru_at_fatcity.com (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). Received on Wed Aug 28 2002 - 19:08:23 CDT
 |
 |