rman备份脚本 发送邮件通知

脚本大部分内容载录网上，本人仅添加邮件发送内容。邮件使用sendEmail包实现，需要自己单独安装。然后再次封装。

#!/bin/bash

#use Oracle Env.

source ~/.bash_profile

#Def backupdir

dirname=`date "+%Y-%U"`

lastweek=`date -d "-3 week" +%Y-%U`

backupdir=/mnt/usbp/u01/database/rman_bak/$dirname

rmdir=/mnt/usbp/u01/database/rman_bak/$lastweek

#check backdir

if [ ! -d $backupdir ];then

    mkdir -p $backupdir

fi

#

#Get Time And Set Backup Level.

#

Dayname=`date +%a`

if [ $Dayname = 'Sun' ]; then

        Level=0

   elif [ $Dayname = 'Thu' ];then

        Level=1

   else 

        Level=2

fi

#Wed means wedsday

#

#Define Backup Type.

#

if [ $Level = 0 ]; then  

        BACKUP_TYPE="incremental level 0" 

   elif [ $Level = 1 ]; then      

        BACKUP_TYPE="incremental level 1"

   else

        BACKUP_TYPE="incremental level 2"

fi

#

#Log.

#

logdate=`date +"%Y%m%d"`

logdate2=`date +%F`

logfile=$backupdir/racdb_rman_"$logdate".log

echo `date +'%Y%m%d %T'`' start backup-----' >> $logfile

cat >$logfile <<EOF

#

#This is RMAN Backup log.

#

#Today is $logdate2,$Dayname.The RMAN Backup Level is $Level and Backup type is $BACKUP_TYPE.

#

#RMAN Bakcup Process starting.

EOF

#backup body

rman target / log $logfile append <<EOF

     run{

        allocate channel a1 type disk;

        crosscheck backup;

        delete noprompt expired backup;

        crosscheck archivelog all;

        delete noprompt expired archivelog all;

        backup as compressed backupset $BACKUP_TYPE database  format '${backupdir}/incr${Level}_%T_%d_%s_%p.bak' filesperset=8;

        sql 'alter system archive log current';

        backup as compressed backupset archivelog all format  '${backupdir}/arc_%T_%d_%s_%p.bak' delete all input;

        backup current controlfile format '${backupdir}/ctl_%T_%d_db_%s_%p.bak';

        release channel a1;

        }

EOF

echo `date +'%Y%m%d %T'`' end backup-----' >> $logfile

#delete last week backup.

if [ -d $rmdir ];then

        rm -rf $rmdir

echo `date +'%Y%m%d %T'`' end rm_his-----' >> $logfile

echo 'hello'

fi

#send mail to smc,if it have some error in backing

if [ -f ${logfile} ];then

sum=`cat ${logfile} | grep -E "RMAN-|ORA-"|wc -l`

if [ ${sum} -lg 0 ];then

sh /home/oracle/shell/mail_pl.sh "***.sohu.com" '备份报警' "`cat ${logfile} | grep -E 'RMAN-|ORA-'`" "${logfile}"

fi

fi

exit 0

-----------------------------------------------------------------------------------------------

mail_pl.sh脚本内容：

#!/bin/bash

SMTP_server='***.sohu.com'

username='*****'

password='****'

from_email_address='***.sohu.com'

to_email_address="$1"

message_subject_utf8="$2"

message_body_utf8="$3"

attachment="$4"

message_subject_gb2312=`iconv -t UTF-8 -f UTF-8 << EOF

$message_subject_utf8

EOF`

[ $? -eq 0 ] && message_subject="$message_subject_gb2312" || message_subject="$message_subject_utf8"

message_body_gb2312=`iconv -t UTF-8 -f UTF-8 << EOF

$message_body_utf8

EOF`

[ $? -eq 0 ] && message_body="$message_body_gb2312" || message_body="$message_body_utf8"

sendEmail='/home/oracle/shell/sendEmail.pl'

if [ -e ${message_body} ];then

$sendEmail -s "$SMTP_server" -xu "$username" -xp "$password" -f "$from_email_address" -t "$to_email_address" -u "$message_subject" -o message-file="$message_body" -a ${attachment} -o message-content-type=text -o message-charset=gb2312

else

$sendEmail -s "$SMTP_server" -xu "$username" -xp "$password" -f "$from_email_address" -t "$to_email_address" -u "$message_subject" -m "$message_body" -a ${attachment} -o message-content-type=text -o message-charset=gb2312

fi

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28572479/viewspace-2123959/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28572479/viewspace-2123959/