(Datagurad)监控脚本

最新推荐文章于 2021-04-09 21:01:47 发布

转载最新推荐文章于 2021-04-09 21:01:47 发布 · 169 阅读

此脚本实现邮箱告警功能，监控Primary服务器状态、数据库关闭情况及DataGuard服务器同步状态，确保系统稳定运行。

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29065182/viewspace-1750383/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29065182/viewspace-1750383/