Showing posts with label Oracle Golden Gate. Show all posts
Showing posts with label Oracle Golden Gate. Show all posts

Sunday, October 3, 2010

How to take replicat pointer forward?

ALTER REPLICAT <name> EXTRBA <above RBA>
start replicat <name>

How to handle ora-00001 or ora-1403 in golden gate replicat process?

Edit parameters file like below :-


replicat Rep1
userid <username> password <password>
ASSUMETARGETDEFS
Reperror 1403, discard
Reperror 1, discard
MAXTRANSOPS 1
GROUPTRANSOPS 1

Sunday, September 12, 2010

How to setup an alert for GoldenGate LAG / Stopped / Abended process?

#!/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