Joe,

Our DBA's have their backup scripts send an email with success or failure
messages. The sys admins turn on sendmail on the Solaris servers and have it
forward to our mail servers. We then build distribution lists in sendmail
for the various messaging needs. Here's a sample of the email notification
piece of the RMAN scripts.

###########################################################
#  Check for errors returned from RMAN
###########################################################
if [ $? -gt 0 ];
then
   opendb
   CURTIME=`date '+%m-%d-%Y %H:%M'`
   echo "" >> $LogFile
   echo "Oracle full backup failed for instance \"${TARGET_SID}\"" >>
$LogFile
   echo "due to bad return code from RMAN at \"${CURTIME}\"" >> $LogFile
   mailx -s "${TARGET_SID} full backup failed at: $CURTIME" \
        rman_backups@sasmcd40 \
        < /dev/null
   exit 2
else
   CURTIME=`date '+%m-%d-%Y %H:%M'`
   echo "" >> $LogFile
   echo "Full backup of instance \"${TARGET_SID}\"" >> $LogFile
   echo "completed successfully at \"${CURTIME}\"" >> $LogFile
   mailx -s "${TARGET_SID} full backup succeeded at: $CURTIME" \
        rman_backups@sasmcd40 \
        < /dev/null
fi

Eric Cowperthwaite
EDS

> -----Original Message-----
> From: Wholey, Joseph (TGA\MLOL) [mailto:JWholey AT EXCHANGE.ML DOT COM]
> Sent: Tuesday, October 22, 2002 6:26 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Monitoring oracle Backups
>
>
> Recently installed TDP for Oracle.  DBA's would like to be
> paged "real time" if a database backup fails.  Aside from the
> paging part, does anyone know where I can pull the status of
> an Oracle database
> backup as soon as it completes.  I don't want to extract from
> the client logs (when would I start looking?)  And the
> Activity log does not supply all that much useful
> information.  Any help would be
> greatly appreciated.
>
> thx.  -joe-
>