自动汇总awr报告，并发出邮件！

1 自动生成awr

-----------------------awr.sh-------------------------------

export ORACLE_SID=PROD
export AWR_HOME=/home/oraprod/awrfile
source /home/oraprod/.bash_profile
mv $AWR_HOME/*  /tmp

m=`sqlplus / as sysdba <<EOF
set heading off;
select max(snap_id) from dba_hist_snapshot;
EOF`

x=${m#*>}
y=${x#*>}
n=`echo $y | awk  '{print $1}'`

echo $y
echo $n
x=$((n-24))
y=$((n-14))


sqlplus / as sysdba <<EOF
@?/rdbms/admin/awrrpt.sql;
html
2
${x}
${y}
$AWR_HOME/awr_${ORACLE_SID}_${x}_${y}.html
EOF

----------------awr.sh------------

crontab -e

20 18  *   *   * sh   /home/oracle/awr.sh

2自动汇总awr，发出邮件

安装sendemail

---------------------sendawr.sh-------------------------------

mv /awrfile/* /tmp

#db1
scp root@10.10.1.3:/home/oraprod/awrfile/*  /awrfile
#db2
scp root@10.10.1.8:/home/oracle/awrfile/*   /awrfile

cd  /awrfile
zip -r  allawr.zip  /awrfile/*
/usr/local/bin/sendEmail -f hanbowu@139.com -t bowu.han@tx.com  -s smtp.139.com -u "ORACLE_DB_awr" -a allawr.zip -xu hanbowu@139.com -xp 1234  -o message-content-type=html  -o message-charset=utf8 < awr_PROD_*

---------------------sendawr.sh-------------------------------

30 18  *   *   *  sh   sendawr.sh