Thursday, February 18, 2016

GoldenGate Daily Patrol Scripts on Servers

You can run patrol Script on GoldenGate Installed Servers and this script  tell about status of GoldenGate process. I recommend you to  schedule patrol script  in crontab Twice a day to check status of GoldenGate process 

#!/bin/ksh
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export GG_HOME=/u01/app/goldengate
export PATH=$GG_HOME:$ORACLE_HOME/bin:$PATH
export LIBPATH=$ORACLE_HOME/lib:$GG_HOME
HOSTNAME=`hostname`
GG_NEW=/u01/app/goldengate
cat /dev/null > /tmp/gg_patrol.txt
echo "Patrol for GoldenGate Process on ${HOSTNAME}"
echo " Daily Patrol for GoldenGate Process on ${HOSTNAME}" >> /tmp/gg_patrol.txt
${GG_NEW}/ggsci <<EOF >> /tmp/gg_patrol.txt
info all
exit
EOF
echo ""
mailx -s "Daily Patrol for GoldenGate Process on $HOSTNAME" <your@mail < /tmp/gg_patrol.txt
exit

--Nikhil Tatineni
--GoldenGate

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...