Data Replication in a Data Consolidation Topology Using Admin Client

Create a Consolidation Topology Based Data Replication Using Admin Client Commands

Copy and use the following OBEY script to set up Oracle GoldenGate data replication environment on an pre-installed database.

Note:

The given sample script uses names and values of database server, parameter values, Extract, Replicat, and other processes. You must change these values according to your environment for this script to work.

CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_23ai !
ALTER CREDENTIALSTORE ADD USER ggadmin@dbnorth ALIAS ggnorth DOMAIN OracleGoldenGate PASSWORD ggadmin
INFO  CREDENTIALSTORE

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_23ai !
ALTER CREDENTIALSTORE ADD USER ggadmin@dbsouth ALIAS ggsouth DOMAIN OracleGoldenGate PASSWORD ggadmin
INFO  CREDENTIALSTORE

CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggnorth DOMAIN OracleGoldenGate
ADD SCHEMATRANDATA hr
ADD CHECKPOINTTABLE ggadmin.ggs_checkpointtable
ADD HEARTBEATTABLE

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggsouth DOMAIN OracleGoldenGate
ADD SCHEMATRANDATA hr
ADD CHECKPOINTTABLE ggadmin.ggs_checkpointtable
ADD HEARTBEATTABLE

CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggnorth DOMAIN OracleGoldenGate

ADD EXTRACT extn INTEGRATED TRANLOG BEGIN NOW 
REGISTER EXTRACT extn database
ADD EXTTRAIL north/ea, EXTRACT extn
START EXTRACT extn

ADD DISTPATH dpns SOURCE trail://north:9002/services/v2/sources?trail=north/ea TARGET wss://south:9103/services/v2/targets?trail=north/da !
START DISTPATH dpns

ADD REPLICAT reps, PARALLEL, EXTTRAIL south/da, CHECKPOINTTABLE ggadmin.ggs_checkpointtable
START REPLICAT reps

INFO ALL
INFO DISTPATH ALL

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggsouth DOMAIN OracleGoldenGate

ADD EXTRACT exts INTEGRATED TRANLOG BEGIN NOW
REGISTER EXTRACT exts database
ADD EXTTRAIL south/ea, EXTRACT exts
START EXTS

ADD DISTPATH dpsn SOURCE trail://south:9102/services/v2/sources?trail=south/ea TARGET wss://north:9103/services/v2/targets?trail=south/da !
START DISTPATH dpsn

ADD   REPLICAT repn, PARALLEL, EXTTRAIL north/da, CHECKPOINTTABLE ggadmin.ggs_checkpointtable
START REPLICAT repn

INFO ALL
INFO DISTPATH ALL

DISCONNECT

After creating the OBEY file, create a shell script to run in Admin Client. This script runs triggers the bidirectional replication setup using the .oby file:

#!/bin/bash

# Clean up environment
/home/oracle/scripts/misc/cleanup.sh > /dev/null

# Copy parameter file (usually edited with EDIT PARAMs)
cp EXTN.prm  /u01/app/oracle/deployments/depl_north/etc/conf/ogg/
cp REPS.prm  /u01/app/oracle/deployments/depl_north/etc/conf/ogg/

cp EXTS.prm  /u01/app/oracle/deployments/depl_north/etc/conf/ogg/
cp REPN.prm  /u01/app/oracle/deployments/depl_south/etc/conf/ogg/

# Run the GoldenGate Obey script
echo "obey add_replication_ActiveActive.oby" | adminclient | tee  add_replication_ActiveActive.log 

Check Processes and Statistics in a Consolidation Topology Based Data Replication Using Admin Client Commands

Note:

The given sample script uses names and values of database server, parameter values, Extract, Replicat, and other processes. You must change these values according to your environment for this script to work.

After creating the OBEY file, create a shell script to run in Admin Client:

Remove the Consolidation Topology Based Data Replication Using Admin Client Commands

Note:

The given sample script uses names and values of database server, parameter values, Extract, Replicat, and other processes. You must change these values according to your environment for this script to work.

After creating the OBEY file, create a shell script to run in Admin Client: