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...
-
syntax for skipping transaction # ggsci> start replicat skiptransaction GGSCI (red.gg.ora.com) 14> info all Program St...
-
scenario # trying to startup / shutdown database encountered with following error # ORA-24324: service handle not initialized ORA-243...
-
Today GoldenGate Extract abended on Servers During my initial investigation, goldengate error report says as follows 2016-02...