GOLDENGATE源端监控脚本

最新推荐文章于 2024-03-25 23:57:14 发布

congku8444

最新推荐文章于 2024-03-25 23:57:14 发布

阅读量171

点赞数

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export NLS_LANG=AMERICAN_AMERICA.zhs16gbk
export ORACLE_SID=mprac1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:$CRS_HOME/lib:$ORACLE_HOME/lib32:$CRS_HOME/lib32

export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/golden/goldengate:/etc:/usr/sbin:/usr/ucb:/golden/bin:/usr/bin/X11:/sbin:.:/oracle/app/oracle/product/11.2.0

export LANG=Zh_CN
export LOCPATH=/usr/lib/nls/loc
export SHELL=/usr/bin/ksh
export ODMDIR=/etc/objrepos
export TZ=BEIST-8
export NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
cd /golden/goldengate/
DATE=`date +%Y%m%d%H%M%S`

P_STS=`echo "info all" |/golden/goldengate/ggsci | grep -E 'MANAGER|REPLICA|EXTRACT' |awk 'BEGIN {a=0}{if ($2=="RUNNING") a=a+1 fi}END{ print a }'|awk '
{ if ($1==5 【总进程数】)
print "0"
else
print "1"
}'`

echo $P_STS

H_STS1=`echo "info all" |ggsci | grep EXT01 | awk '{print $4}' | awk -F":" '{print $1*3600+$2*60+$3*1}'`
H_STS2=`echo "info all" |ggsci | grep EXT01 | awk '{print $5}' | awk -F":" '{print $1*3600+$2*60+$3*1}'`

if [ $H_STS1 -gt $H_STS2 ]; then
H_STS=$H_STS1
else
H_STS=$H_STS2
fi

if [ $P_STS = "1" 【进程状态有一个不是RUNNING告警】]||[ $H_STS -gt 300 【大于300秒告警】];
then
OGG_STS="1"
echo "OGG_STAT|"$OGG_STS"|OGG_HANG"$H_STS""
else
OGG_STS="0"
echo "OGG_STAT|"$OGG_STS"|OGG_OK"$H_STS""
fi

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

转载于:http://blog.itpub.net/308563/viewspace-2136324/