OGG 自动重启脚本

最新推荐文章于 2024-08-07 21:52:22 发布

weixin_30815427

最新推荐文章于 2024-08-07 21:52:22 发布

阅读量930

点赞数

文章标签：数据库 shell awk

原文链接：http://www.cnblogs.com/plluoye/p/11180968.html

版权

从朋友那里得来的OGG 重启脚本，感觉很好用，分享给大家。

定时任务

00 6-20 * * * /oggdata/log/oggautorestart.sh >/oggdata/log/crontab_oggautorestart.log 2>&1

[ 说明] 因为晚上可以有维护操作，我们不希望在维护期间OGG 自动跑起来

脚本

oggautorestart.sh

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

#OGG 目录
OGGHOME=/oggdata
#创建日志目录
if [ ! -d $OGGHOME/log ]; then
 mkdir $OGGHOME/log;
fi

cd $OGGHOME/log
echo "Start checking ......begin time: `date +'%Y%m%d %H:%M:%S'`" >> $OGGHOME/log/all.log
echo "info all"|$OGGHOME/ggsci|grep -E "MANAGER" >> $OGGHOME/log/status.all
echo "info all"|$OGGHOME/ggsci |grep -E "REPLICAT|EXTRACT" >> $OGGHOME/log/status.all

cat status.all | while read line
do
hhh=`echo $line | awk '{print $1}'`
sss=`echo $line | awk '{print $2}'`
nnn=`echo $line | awk '{print $3}'`

if [ "$hhh" = "MANAGER" ]
then
        if [ "$sss" != "RUNNING" ]
        then
                echo "$hhh is not running......start begin time: `date +'%Y%m%d %H:%M:%S'`" >> $OGGHOME/log/all.log
                echo "start $hhh" |/ogg/ggsci
        else
                echo "MANAGER is running" >> /ogg/log/ok.all
        fi

else
        if [ "$sss" != "RUNNING" ]
        then
                echo "$nnn is not running......start begin time: `date +'%Y%m%d %H:%M:%S'`" >> $OGGHOME/log/all.log
                echo "start $nnn" |$OGGHOME/ggsci
        else
                echo "$nnn is running" >> $OGGHOME/log/ok.all
        fi
fi

done

> $OGGHOME/log/status.all
> $OGGHOME/log/ok.all
echo "Ending check......end time: `date +'%Y%m%d %H:%M:%S'`" >> $OGGHOME/log/all.log
echo "##################" >> $OGGHOME/log/all.log