GoldenGate监控脚本

  说明：脚本包含同步冲突检查及最大lag延时检查，此脚本配合

飞信机器人使用可以提供短信报警功能。

 

#! /bin/bash

####################################################################
#Read configuration file

source $HOME/.bash_profile;
v_shell_path=$HOME/some_shell/gg_check;
v_now_time=$(date "+%F__%H_%M_%S");
gg_home='/home/ora10g/goldengate';
v_now=$(date "+%Y%m%d%H%M");
v_log_dir=${gg_home}/LagLog;

if [ -d ${v_shell_path} ]
then

if [ -f /etc/sysconfig/network-scripts/ifcfg-bond0 ]
then
v_ipaddr=$(cat /etc/sysconfig/network-scripts/ifcfg-bond0 | \
grep -i 'ipaddr' | cut -d'=' -f2);
elif [ -f /etc/sysconfig/network-scripts/ifcfg-eth0 ]
then
v_ipaddr=$(cat /etc/sysconfig/network-scripts/ifcfg-eth0 | grep -i 'ipaddr' |\
cut -d'=' -f2);
else
v_ipaddr='';
fi;

if [ -z ${v_ipaddr} ]
then
v_ipaddr='Unknow';
fi

cd ${v_shell_path};

####################################################################
#discards & collisions DML check

v_gg_colfile=/tmp/ggcolfile.$$;

$GG_HOME/ggsci > ${v_gg_colfile} <
stats * hourly
EOF

v_diserr_cnt=$(cat ${v_gg_colfile} |\
egrep -i '(discards|collisions)' |\
sed 's/[^0-9.]//g' |\
grep -v '0.00' |\
wc -l);

rm -f ${v_gg_colfile};

####################################################################
#Gather OGG info

cd ${v_shell_path};

$GG_HOME/ggsci > ogg_info${v_now_time}.log <
info all
EOF

####################################################################
#Find error info (not running)

egrep -i '(^REPLICAT|EXTRACT)' ogg_info${v_now_time}.log | \
grep -iv 'RUNNING' > ogg_error_info${v_now_time}.log;

v_err_cnt=$(wc -l ogg_error_info${v_now_time}.log | cut -d' ' -f1);

touch tmp_zhy.log;

####################################
#GG lag check

mkdir -p ${v_log_dir};

if [ ! -d ${gg_home} ]
then
:;
else
${gg_home}/ggsci > ${v_log_dir}/ggstats.${v_now} <
lag *
EOF

v_mx_lag=$(
cat ${v_log_dir}/ggstats.${v_now} |\
egrep 'Last record.+seconds' |\
cut -d' ' -f4 |\
sort -n |\
tail -1);

fi;

if [ ${v_err_cnt} -ne 0 -o ${v_diserr_cnt} -ne 0 -o ${v_mx_lag} -gt 100 ]
then
awk '{print $1,$2,$3}' ogg_error_info${v_now_time}.log > tmp_zhy.log;
echo ${v_ipaddr} > ogg_error_info${v_now_time}.log;
echo 'Max lag is: '${v_mx_lag} >> ogg_error_info${v_now_time}.log;
#cat tmp_zhy.log >> ogg_error_info${v_now_time}.log;
scp ogg_error_info${v_now_time}.log \
root@192.168.1.1:/home/ora10g/monitor/gg_check/${v_ipaddr}__${v_now_time}.log;
fi

touch ogg_error_info${v_now_time}.log;rm ogg_info${v_now_time}.log \
ogg_error_info${v_now_time}.log \
tmp_zhy.log;

else

echo "No ${v_shell_path} directory!";

fi