High Availability Architecture implementation Commands
Add Application VIP service in Source cluster
Run below commands from the root user.
# $GRID_HOME/bin/appvipcfg create -network=1 -ip="10.10.10.74" \
-vipname gg-sourcedb-vip -user=root -group=oinstall -failback=0
# $GRID_HOME/bin/crsctl modify res 'gg-sourcedb-vip' \
-attr "HOSTING_MEMBERS=sourcedb01"
# $GRID_HOME/bin/crsctl modify res 'gg-sourcedb-vip' \
-attr "USR_ORA_VIP=10.10.10.74"
# $GRID_HOME/bin/crsctl start resource gg-sourcedb-vip -n sourcedb01
# $GRID_HOME/bin/crsctl stat resource gg-sourcedb-vip -p → This command displays the resource properties.
Add Application VIP service in Target cluster
Run below commands from the root user.
# $GRID_HOME/bin/appvipcfg create -network=1 -ip="10.10.10.75" \
-vipname gg-targetdb-vip -user=root -group=oinstall -failback=0
# $GRID_HOME/bin/crsctl modify res 'gg-targetdb-vip' \
-attr "HOSTING_MEMBERS=targetdb01"
# $GRID_HOME/bin/crsctl modify res 'gg-targetdb-vip' \
-attr "USR_ORA_VIP=10.10.10.75"
# $GRID_HOME/bin/crsctl start resource gg-targetdb-vip -n targetdb01
# $GRID_HOME/bin/crsctl stat resource gg-targetdb-vip -p → This command displays the resource properties.
Add Goldengate service in Source database.
Note: Run below command from oracle user
Command to add the goldengate service
$ agctl add goldengate GG_SOURCEDB \
--gg_home /u01/app/oracle/product/gghome \
--use_local_services \
--instance_type source \
--dataguard_autostart no \
--oracle_home /u01/app/oracle/product/db_1/19c \
--critical_extracts EXT,PMP \
--db_services ora.sourcedb.sourcedb_ogg.svc \
--nodes sourcedb01,sourcedb02 \
--vip_name gg-sourcedb-vip \
--filesytems dbfs_mount \
--user oracle \
--group oinstall
Command to check the Goldengate service Configuration:
$ agctl config goldengate GG_SOURCEDB
Command to start the Goldengate service on node-1:
$ agctl start goldengate GG_SOURCEDB --node sourcedb01
Command to relocate the Goldengate service on node-2:
$ agctl relocate goldengate GG_SOURCEDB --node sourcedb02
Command to start the Goldengate service:
$ agctl stop goldengate GG_SOURCEDB
Command to disable the Goldengate service:
$ agctl disable goldengate GG_SOURCEDB
Command to enable the Goldengate service:
$ agctl enable goldengate GG_SOURCEDB
Add Goldengate service in Target database.
Note: Run below command from oracle user
$ agctl add goldengate GG_TARGETDB \
--gg_home /u01/app/oracle/product/gghome \
--use_local_services \
--instance_type target \
--dataguard_autostart no \
--oracle_home /u01/app/oracle/product/db_1/19c \
--critical_extracts REP \
--db_services ora.targetdb.targetdb_ogg.svc \
--nodes targetdb01,targetdb02 \
--vip_name gg-targetdb-vip \
--filesytems dbfs_mount \
--user oracle \
--group oinstall
Command to check the Goldengate service Configuration:
$ agctl config goldengate GG_TARGETDB
Command to start the Goldengate service on node-1:
$ agctl start goldengate GG_TARGETDB --node targetdb01
Command to relocate the Goldengate service on node-2:
$ agctl relocate goldengate GG_TARGETDB --node targetdb02
Command to start the Goldengate service:
$ agctl stop goldengate GG_TARGETDB
Command to disable the Goldengate service:
$ agctl disable goldengate GG_TARGETDB
Command to enable the Goldengate service:
$ agctl enable goldengate GG_TARGETDB
