巡检项:
cpu使用率,内存使用率,文件系统使用率,日志文件大小,oracle后台日志(有无异常),oracle连接数使用情况,oracle表空间使用率,asm存储使用率,失效索引,rman备份日志(有无异常)
主巡检脚本:Oracheck.sh
[oracle@orcl scripts]$ cat oracheck.sh
#!/bin/sh
# Get Hostname
DB_CONN_STR=system/oracle
source /home/oracle/.bash_profile
logfile=oracheck_`date +%y%m%d`.log
hostinfodir=/home/oracle/oracheck
DB_UNIQUE_NAME=orcl
if [[ ! -d $hostinfodir ]]
then
mkdir -p $hostinfodir
fi
echo -e "==== Oracheck started at $(date +"%y-%m-%d %H:%M:%S") ===\n" >> $hostinfodir/$logfile
echo -e "*** step1.CPU使用率检查 \n" >> $hostinfodir/$logfile
sar 1 10 >> $hostinfodir/$logfile
echo -e "\n" >> $hostinfodir/$logfile
echo -e "*** step2.内存使用率检查 \n" >> $hostinfodir/$logfile
free -g >> $hostinfodir/$logfile
echo -e "\n" >> $hostinfodir/$logfile
echo -e "*** step3.文件系统使用率检查 \n" >> $hostinfodir/$logfile
df -h >>$hostinfodir/$logfile
echo -e "\n" >> $hostinfodir/$logfile
echo -e "*** step4.日志文件大小检查 \n" >> $hostinfodir/$logfile
echo -e "trace目录(trc,trm,alert_sid):" >> $hostinfodir/$logfile
du -sh $ORACLE_BASE/diag/rdbms/$DB_UNIQUE_NAME/$ORACLE_SID/trace >>$hostinfodir/$logfile
echo -e "alert目录(log_*.xml):" >> $hostinfodir/$logfile
du -sh $ORACLE_BASE/diag/rdbms/$DB_UNIQUE_NAME/$ORACLE_SID/alert >>$hostinfodir/$logfile
echo -e "监听日志(listener.log):" >> $hostinfodir/$logfile
du -sh $ORACLE_HOME/network/admin/listener.ora >>$hostinfodir/$logfile
echo -e "审计目录(adump):" >> $hostinfodir/$logfile
du -sh $ORACLE_BASE/admin/$DB_UNIQUE_NAME/adump >>$hostinfodir/$logfile
echo -e "\n" >> $hostinfodir/$logfile
echo -e "*** step5.oracle后台日志检查 \n" >> $hostinfodir/$logfile
tail -3000 $ORACLE_BASE/diag/rdbms/$DB_UNIQUE_NAME/$ORACLE_SID/trace/alert_$ORACLE_SID.log |grep ORA- >> $hostinfodir/$logfile
echo -e "\n" >> $hostinfodir/$logfile
echo -e "*** step6.oracle连接数检查 \n" >> $hostinfodir/$logfile
sh /home/oracle/oracheck/scripts/process_check.sh >> $hostinfodir/$logfile
echo -e "\n" >> $hostinfodir/$logfile
echo -e "*** step7.oracle表空间使用率检查 \n" >> $hostinfodir/$logfile
sh /home/oracle/oracheck/scripts/tbs_check.sh >> $hostinfodir/$logfile
echo -e "\n" >> $hostinfodir/$logfile
echo -e "*** step8.asm存储使用率检查 \n" >> $hostinfodir/$logfile
sh /home/oracle/oracheck/scripts/asm_check.sh >> $hostinfodir/$logfile
echo