数据库归档告警监控脚本

文件系统型归档：

 1 MSG_QD="ahqd1 "
 2 MSG=`df -g|grep /archlog | awk '{if($4/1> 60)print $4,$NF}';`    
 3 SUM3=`df -g|grep /archlog | awk '{if($4/1>60)print $4,$NF}'|wc -l`
 4   if [ $SUM3 -gt 0 ]
 5     then
 6        {
 7     /usr/java5/jre/bin/java -jar /opt/ty/NotifyAgent.jar -a 1 -p 18999999999   -c $MSG_QD$MSG  
 8    }
 9   else
10       {
11          MSG_HB="normal"
12          echo "$DATE $MSG_HB"
13        } 
14   fi

ASM类型归档：

#!/bin/sh
PATH=$PATH:$HOME/bin

export PATH
export ORACLE_SID=srlzdb
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export LD_LIBARY_PATH=$ORACLE_HOME/lib
export PATH
export NLS_LANG=american_america.ZHS16GBK

MSG_QD="srlzdb /arch "

MSG=`
sqlplus -s /nolog <<EOF
set echo off feedback off heading off underline off;
conn / as sysdba;
select trunc((1-FREE_MB/TOTAL_MB)*100)||'%' from v\\$asm_diskgroup where name='ARCH';
EOF`

SUM=`
sqlplus -s /nolog <<EOF
set echo off feedback off heading off underline off;
conn / as sysdba;
select trunc((1-FREE_MB/TOTAL_MB)*100) from v\\$asm_diskgroup where name='ARCH';
EOF`

  if [ "$SUM" -gt 60 ]
    then
       {
    /usr/bin/java -jar /opt/ty/NotifyAgent.jar -a 1 -p 18999999999  -c $MSG_QD$MSG
   }
  else
      {
         MSG_HB="normal"
         echo "$DATE $MSG_HB"
       } 
  fi

 

posted @ 2017-09-28 20:41  tonnytangy  阅读(243)  评论(0)    收藏  举报