#!/usr/bin/ksh
GG_HOME=/oracleGG
if [ -d $GG_HOME ]
then
rm -Rf showtrans_detail.txt
cd $GG_HOME
$GG_HOME/ggsci << *eof* > showtrans_detail.txt
info all
*eof*
sqlplus "/ as sysdba" << *eof* >> showtrans_detail.txt
alter session set NLS_DATE_FORMAT='DD.MM.YYYY HH24:MI:SS';
select GROUP_NAME,GROUP_KEY,LAST_UPDATE_TS from GG_STDB3.CHKPTAB order by 3 ;
*eof*
LAG=`cat showtrans_detail.txt | grep -i replicat | awk '{print $4}' | cut -c 1,2,4,5,7,8 | sort -rn | head -1`
ABNDST=`cat showtrans_detail.txt | grep -E 'STOPPED|ABENDED' | wc -l`
if [ $ABNDST -gt 0 ]
then
echo "GoldenGate ABENDED or STOPPED"
echo "please send an email..."
fi
if [ $LAG -gt 3000 ]
then
echo "Lag $LAG in Golden Gate..."
echo "please send an email..."
fi
fi
No comments:
Post a Comment