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
Create the Geographic Edition configuration file.
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
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
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=
Register on one node of the primary cluster.
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