Creating the Oracle GoldenGate Replicated Component

Language:

Assuming the root role, follow the instructions in this section to create the aplication resource group on both clusters.

On one node of both clusters, define the application rg with one logical host, app, at least.

Cluster nyc
    
pnycb # clresourcegroup create app-rg
pnycb # clreslogicalhostname create -g app-rg app
pnycb # clresourcegroup set -p Auto_start_on_new_cluster=false app-rg  
    
Cluster sfo
    
psfob # clresourcegroup create app-rg
psfob # clreslogicalhostname create -g app-rg app
psfob # clresourcegroup set -p Auto_start_on_new_cluster=false app-rg

Note - Leave the resource group app-rg unmanaged on both clusters.

Create the Disaster Recovery Framework configuration file.
1. On all nodes of both clusters, create a sbp directory to contain the /sbp/geo-config configuration file.
```
pnyca # mkdir /sbp
pnycb # mkdir /sbp
psfoa # mkdir /sbp
psfob # mkdir /sbp
```
2. On both nodes of the nyc cluster, create the /sbp/geo-config file with the listed content.
```
cluster nyc

pnyca # echo "gg-pg|any|pnyca,pnycb" >/sbp/geo-config
pnycb # echo "gg-pg|any|pnyca,pnycb" >/sbp/geo-config
```
3. On both nodes of the sfo cluster, user create the /sbp/geo-config file with the listed content.
```
Cluster sfo

psfoa # echo "gg-pg|any|psfoa,psfob" >/sbp/geo-config
psfob # echo "gg-pg|any|psfoa,psfob" >/sbp/geo-config
```

Create the registration configuration file on one node of the primary cluster.

pnycb # cp /opt/ORCLscGoldenGate/geocontrol/etc/goldengate_geo_config /var/tmp/geo
PS=gg-ps
PG=gg-pg 
REPCOMP=gg-comp
REPRS=rep-rs
REPRG=rep-rg
DESC="GoldenGate replication component"
CONFIGFILE=/sbp/geo-config
REALGGRG=mys-rg
REALGGRS=gg-rs
GGGROUPS=nyc:mysqlex1,nyc:mysqlre2,sfo:mysqlex2,sfo:mysqlre1
APPRG=app-rg
PINGTIME=

pnycb # ksh /opt/ORCLscGoldenGate/geocontrol/util/goldengate_geo_register \
-f /var/tmp/geo/goldengate_geo_config

Update the secondary cluster.
```
psfob # geopg get -s gg-ps gg-pg
```
Start the protection group.
```
psfob # geopg start -e global gg-pg
```
Perform a switchover of the protection group.
```
psfob # geopg switchover -m sfo  gg-pg
```
Stop the protection group.
```
psfob # geopg stop -e global gg-pg
```
Status check on one cluster.
```
psfob # geoadm status
```