检查当天的警告日志并发邮件

转自： http://space.itpub.net/16566331/viewspace-670102

#!/bin/bash
SID=my7g
DBAMAIL=[e-mail]
cd $ORACLE_BASE/admin/${SID}/bdump
if [ -f alert_${SID}.log ]
then
mv alert_${SID}.log alert_work.log
touch alert_${SID}.log
cat alert_work.log>>alert_${SID}.hist
grep -i ORA- alert_work.log>alert.err
fi

if [ `cat alert.err|wc -l` -gt 0 ]
then
mutt -s "${SID} ORACLE ALERT ERRORS" $DBMAIL <alert.err
fi
rm -rf alert.err
rm -rf alert_work.log