ALTER REPLICAT <name> EXTRBA <above RBA>
start replicat <name>
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 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
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
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
Subscribe to:
Posts (Atom)