monitor_dg_例行巡檢，顯示正常或不正常

lusklusklusk發表於2017-05-25
#使用crontab定時呼叫，檢視郵件顯示結果

#!/bin/bash
source ~/.bash_profile 


$ORACLE_HOME/bin/sqlplus -silent "/ as sysdba" </tmp/check_dg.log
set pagesize 0 feedback off verify off heading off echo off 
select ceil((sysdate-next_time)*24*60) "M" 
from v\$archived_log  
where applied='YES' AND SEQUENCE#=(SELECT MAX(SEQUENCE#)  FROM V\$ARCHIVED_LOG WHERE applied='YES');
exit;
XFF


$ORACLE_HOME/bin/sqlplus -silent "/ as sysdba" </tmp/dg_switch_check.log
set pagesize 0 feedback off verify off heading off echo off 
select SEQUENCE#,to_char(completion_time,'yyyy-MM-dd HH24:mi:ss'),APPLIED from v\$archived_log where to_date(completion_time)=to_date(sysdate) order by SEQUENCE# desc;
exit;
XFF



GET_M=`cat /tmp/check_dg.log`
COUNT=`cat /tmp/dg_switch_check.log |grep "NO" |wc -l`



if [ 120 -lt ${GET_M} -o ${COUNT} -gt 5 ]; 
then
cat /tmp/dg_switch_check.log | mailx -s "BAD!!! WFDG 192.168.30.174 DOWN" xx@yy.com    
else
cat /tmp/dg_switch_check.log | mailx -s "GOOD NEWS, WFDG 192.168.30.174 WORK" xx@yy.com
fi


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30126024/viewspace-2139878/，如需轉載，請註明出處，否則將追究法律責任。

相關文章