Are you bored with GoldenGate objects with no supplemental log on Oracle Database?
This script will check ALL tables in GG PRM, after check on database supplemental log information.
PRM, dblogin should be changed.
Try this script on crontab:
vi gg_trandata_checkup.sh
cd $GGATE
echo > gg.out
echo "dblogin USERID @ PASSWORD > template_check.tmp
echo "" >> template_check.tmp
cat dirprm/ext_1.prm|grep -i TABLE|awk {' print $1" "$2 '}|awk -F"," {' print $1 '}|sed 's/TABLE/INFO TRANDATA/g' >> template_check.tmp
./ggsci -s gg.out
obey template_check.tmp
EOF
cat gg.out|sed '/^$/d'|grep -v ": ALL."|grep -v -i "info trandata"|grep -v "data is enabled for table"|grep -v "ERROR OGG-01784"
Mail this to GGAdmins.
Maiquel.