oracle@hostname#cat somescript
#/bin/bash
sqlplus -s scott/tiger <<EOF
--include your formatting commands
spool /tmp/script.log
select * from dept;
spool off;
exit;
EOF
mailx -s 'Your Meaninful subject' someone@somewhere.com < /tmp/script.log

mailx -s 'MDEV_backup_validation' someone@somewhere.co.uk < somelogfile.log

mailx -s 'MDEV_backup_validation' someone@somewhere.co.uk <<EOF
something important enough to email has just occurred
EOF 

oracle@hostname#cat somermanscript
export ORACLE_SID=yoursid
export ORACLE_BASE=yourbase
export ORACLE_HOME=yourhome
export NLS_DATE_FORMAT='MON DD YYYY HH24:MI:SS'#
export SERVER=`uname -n`
export DB=yourdatabaseNAME
export MAILLIST="person1@work.com person2@work.com" # your mailing list. one or more persons who get mailed.
export LOG=/the_place_where_you_savethe_logfiles/yourlogfile.log
#
$ORACLE_HOME/bin/rman msglog 'yourlogfile.log' << EOF
connect target / ; #add your target information
connect rcvcat rmut/rmut@rmandb; #your catalog information
run
{
#All you want to do
}
exit;
EOF
#
cd /the_place_where_you_savethe_logfiles
grep "error message stack follows" yourlogfile.log > alert_rman
#
if test -s alert_rman
then
mailx -s "ALERT -> Youraction on $DB somestatus(failed/busted)" $MAILLIST <$LOG
mailx -s "ALERT -> Youraction on $DB somestatus(failed/busted)" somepageraddress@address < alert_rman
else
mailx -s "Status -> $DB operation somestatus " $MAILLIST < $LOG
fi