我的oracl监控脚本.docVIP

我的oracle监控脚本 ----检查磁盘空间------------------ bin/shd1=`df -h | grep /home | awk {print $5} | awk -F% {print $1}`if [ $d1 -ge 80 ]thenecho `date +%F %H:%M:%S` The disk is not enough ,the message from ip | mail -s primary_ipdisk alert jie.du@mailfi ------------检查oracle standby服务器的状态--------------------------- #!/bin/bashprimary_log=`ls -t /home/oracle/archive_log | head -n 1 | awk -F_ {print $2}`standby_log=`ssh -p65508 oracle@3 ls -t /home/oracle/archive_log | head -n 1 |awk -F_ {print $2}`apply_log=`ssh -p65508 oracle@3 grep Media Recovery Log /home/oracle/admin/sfgame/bdump/alert_sfgame.log| tail -n 1| awk -F/ {print $5} | awk -F_ {print $2}` d1=`expr $primary_log - $standby_log `d2=`expr $standby_log - $apply_log ` echo $primary_logecho $standby_logecho $apply_log if [ $d1 -ge 2 ]thenecho ------ `date +%F %H:%M:%S` check_stantdby_status.logecho The archive_log was not sended check_stantdby_status.log echo The archive_log was not sended | mail -s standby_ip jie.du@email if [ $d2 -ge 2 ]thenecho ------ `date +%F %H:%M:%S` check_stantdby_status.logecho The archived_log was not applied check_stantdby_status.log echo The archive_log was not applied | mail -s standby_ipalert jie.du@email --------数据库备份脚本--------- rman target / EOFrun {allocate channel c1 type disk;allocate channel c2 type disk;backupfilesperset 5fullformat /home/oracle/dbbackup/sfgame_full_p%p_s%s_t%t_%T.bak(database include current controlfile);}exitEOF if [ $? -ge 0 ]thenecho `date +%F %H:%M:%S` backup failed dbbackup.logfi ------日志备份脚本------------- primary_log=`ls -t /home/oracle/archive_log | head -n 1 | awk -F_ {print $2}`standby_log=`ssh -p65508 oracle@3 ls -t /home/oracle/archive_log | head -n 1 |awk -F_ {print $2}` d1=`expr $primary_log - $standby_log `time=`date +%H` if [ $d1 -le 2 ]then #-------delete data of 5 days ago if standby log can normal archived if [ $time = 00 ]thencd /home/oracle/oracle_maintenance$ORACLE_HOME/bin/sqlplus /nologEOF co