TRẦN VĂN BÌNH MASTER: Script gửi email cảnh báo khi lag GoldenGate

Mục đích: Chia sẻ Script gửi email cảnh báo khi lag GoldenGate

-- Tạo crontab như sau:

--0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/oracle/gg_check/check_goldengate.sh >/dev/null 2>&1

#/home/oracle/gg_check/check_goldengate.sh

#!/usr/bin/ksh

#set -x

###################################

### Parameters

###################################

HOSTNAME=""

LOGSDIR="/home/oracle/gg_check/log"

SCRIPTNAME="check_goldengate.sh"

SKIP_GROUP="_MF"

#####################################################

### Oracle Instance on production server

#####################################################

export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"

export GGATE=/home/oracle/gg_check/

export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib/:/u01/app/oracle/goldengate

export ORACLE_SID=dbaviet1

export ORACLE_BASE=/u01/app/oracle/product/11.2.0.2

export PATH=/usr/bin:/u01/app/oracle/product/11.2.0.2/dbhome_1/bin:/u01/app/11.2.0.2/grid/bin:/opt/mc/bin:/usr/local/bin:/usr/openwin/bin:/usr/ccs/bin:/u01/a

pp/oracle/goldengate

export RDBMS_HOME=/u01/app/oracle/product/11.2.0.2/dbhome_1

export GRID_HOME=/u01/app/11.2.0.2/grid

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.2/dbhome_1

###################################

### Commands and files

###################################

SED="/usr/bin/sed"

AWK="/usr/bin/awk"

UMOUNT="/sbin/umount"

MOUNT="/sbin/mount"

PING="/usr/sbin/ping"

WC="/usr/bin/wc"

FSCK="/usr/sbin/fsck"

DF="/usr/sbin/df"

PS="/usr/bin/ps"

SU="/usr/bin/su"

CURDATE=`/bin/date +%d%b%y`

OUTF="$LOGSDIR/$SCRIPTNAME.$CURDATE"

EMAIL="$LOGSDIR/email.ora"

#/u01/app/oracle/goldengate/dump_scripts/testgg/testgg.sh

#------------------------------------------------------------------------------

# CHECK STATUS GOLDEN GATE

#------------------------------------------------------------------------------

check_status ()

{

echo ""

echo "------------------------------------------------------------------------"

echo "check time: `/bin/date +%d%b%y-%H:%M`"

echo "------------------------------------------------------------------------"

result=`/u01/app/oracle/goldengate/ggsci <<EOF

info all

EOF`

}

#-----------------------------------------------------------------------------

# CHECK ERROR

#-----------------------------------------------------------------------------

check_error ()

{

#original message

original_mess=$(echo "$result"|awk '{if (NR>1 && NR<44) {print $0} }')

echo "$original_mess" >> $OUTF 2>&1

echo "$original_mess"

#save heading for sms

heading=$(echo "$result"|/bin/grep "Program")

#echo "heading:\n$heading"

#cut heading "Program"

result_noheading=$(echo "$result"|/bin/sed '/Program/d')

#find process HANG or BANDED or STOP

err_mess=$(echo "$result_noheading"|awk '{if (NR>10 && NR<40) {print $0} }'|/bin/grep -E -e "STOP|ABENDED" |/bin/grep -v "REP" |/bin/grep -v "$SKIP_GROUP")

#echo "Process bi loi:\n$heading\n$err_mess\n"

#find delay process receive file

err_mess_2=$(echo "$result_noheading"|awk '{if (NR>10 && NR<40) {print $0} }'|awk '$5>"00:15:00" {print}' |/bin/grep -v "REP" |/bin/grep -v "$SKIP_GROUP")

#echo "Process nhan file cham >10phut:\n$heading\n$err_mess_2\n"

#find delay process Extract

err_mess_3=$(echo "$result_noheading"|awk '{if (NR>10 && NR<40) {print $0} }'|awk '$4>"00:15:00" {print}' |/bin/grep -v "REP" |/bin/grep -v "$SKIP_GROUP")

#echo "Process Extract bi cham >10phut:\n$heading\n$err_mess_3\n"

#final_msg="Process bi loi:\n$err_mess\n"

#final_msg="$final_msg\nProcess nhan file cham >10phut:\n$err_mess_2\n"

#final_msg="$final_msg\nProcess cham >10phut:\n$err_mess_3"

#echo "$final_msg"

#-----------------------------------------------------

# reset email content file

#-----------------------------------------------------

echo "" > $EMAIL 2>&1

#-----------------------------------------------------

# make sms & email content

#-----------------------------------------------------

if [ "$err_mess" != "" ];

then

final_msg="Process bi loi:\n$err_mess\n"