Another solution I think of would be to set up a DBMS job using UTL_FILE
to read (and parse) the export log file and UTL_SMTP to send alerts (or
messages saying 'OK'). A bit more difficult with the hot backup, but if
the procedure is able to log failure somewhere then the same principle
could be applied. Not NT specific, BTW.
"Reardon, Bruce (CALBBAY)" wrote:
>
> 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: Stephane Faroult
INET: sfaroult_at_oriole.com
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 Thu Aug 29 2002 - 02:48:24 CDT
