(Datagurad)監控指令碼

dg監控指令碼
功能

郵箱告警，primary伺服器當機，資料庫被關閉，datagurad伺服器不同步standby就會發起告警郵件

#!/bin/bash
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin
umask 022
PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib
ORACLE_BASE=/filedata/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1
ORACLE_SID=oracle11
LD_LIBRARY_PATH=$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin:$PATH
export PATH LD_LIBRARY_PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID
#export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export PATH

#use ssh decide network status
#decide no 0 network at questio
#RETVAL return 0 AUTO SWITCH DATAGURAD
#It didn't gap execute
gap_log=$(su - oracle -c "sqlplus -silent / as sysdba" << m >>/home/oracle/dg.log 2>&1
set pagesize 0 feedback off verify off heading off echo off numwidth 4
select low_sequence# from v\$archive_gap;
exit
m
)
oracle=$(ssh smsplatform01 ps -ef |grep ora_|grep -v "grep"|wc -l)
ssh smsplatform01 date >> /home/oracle/oracle.log 2>&1  
RE=$?     
if [[  $oracle -gt 0   &&  $gap_log -eq 0  &&  $RE -eq 0 ]];then
echo "remote service active "

else
echo "PRIMARY Host is down, please deal with as soon as possible"|mail -s 'dgexception monitoring' 282263179@qq.com
 
fi