Would you to clone some GoldenGate home, but you have too many extract / pump / replicats?
It will take an eternal day?
Try to use this script:
./ggsci << EOF > gg_config.out
info all
EOF
#CHECK EXTRACT CONFIG
cat gg_config.out|egrep "EXTRACT"|awk {' print $3 '}|while read line;
do
echo "--EXTRACT "$line;
./ggsci << EOF > $line.out
info $line detail
EOF
TRAILFILE_TEMP=`cat $line.out|grep "Log Read Checkpoint"|awk {' print $5 '}`
STRING_FIND="dirdat"
cutpos=`awk -v a="$TRAILFILE_TEMP" -v b="$STRING_FIND" 'BEGIN{print index(a,b)}'`
TRAILFILE=`echo $TRAILFILE_TEMP|cut -c $cutpos-11`
echo "add extract $line, exttrailsource ./$TRAILFILE, begin now"
cat $line.out|grep RMTTRAIL|awk {' print $1 '}|while read rmttrail; do
echo "add rmttrail $rmttrail, extract $line"
done
rm $line.out
done
#CHECK REPLICAT CONFIG
cat gg_config.out|egrep "REPLICAT"|awk {' print $3 '}|while read line;
do
echo "--REPLICAT "$line;
./ggsci << EOF > $line.out
info $line detail
EOF
CHECKPOINT=`cat $line.out|grep "Checkpoint table"|awk {' print $3 '}`
TRAILFILE=`cat $line.out|grep "Log Read Checkpoint"|awk {' print $5 '}`
echo "--REPLICAT"
echo "add replicat "$line", exttrail "$TRAILFILE", checkpoint table "$CHECKPOINT
rm $line.out
done
It will return GoldenGate commnads to add all process in another GoldenGate home.
Work fine with pump / replicat.
so, obey in a output file.
--EXTRACT P_CUST1 add extract P_CUST1, exttrailsource ./dirdat/j0, begin now add rmttrail ./dirdat/j0, extract P_CUST1 --EXTRACT P_CUST2 add extract P_CUST2, exttrailsource ./dirdat/j0, begin now add rmttrail ./dirdat/j1, extract P_CUST2 --EXTRACT P_CUST3 add extract P_CUST3, exttrailsource ./dirdat/j0, begin now add rmttrail ./dirdat/xx, extract P_CUST3 --REPLICAT R_REP1 add replicat R_REP1, exttrail ./dirdat/m6, checkpoint table GGATE.OGGCKPT --REPLICAT R_REP2 add extract R_REP2, exttrailsource ./dirdat/cv, begin now --REPLICAT R_REP3 add replicat R_REP3, exttrail ./dirdat/cv, checkpoint table GGATE.OGGCKPT