High Availability Architecture implementation Commands - Part 2

 High Availability Architecture implementation Commands

5. 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.

6. 
   

7. 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.

7. 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

8. 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

Reference: https://www.oracle.com/database/technologies/xag-agents-download.html