Oracle^® Solaris Cluster Data Replication Guide for Oracle GoldenGate

Configuring the Reverse Replication Direction

1. Configure extract 2 on cluster sfo.

   GGSCI (psfob) 9> edit param mysqlex2
   EXTRACT mysqlex2
   DBOptions Host sfo-gg
   SourceDB golden UserID gg Password gg
   TranLogOptions AltLogDest /mys/data/logs/bin-log.index  
   TranLogOptions filtertable mysql.checkpoint
   DISCARDFILE /gg/mysqlex2.dsc, PURGE
   RMTHOST nyc-gg, MGRPORT 7809
   RMTTRAIL /gg/dirdat/YY
   TABLE golden.*;

2. Add extract 2 on cluster sfo.

   GGSCI (psfob) > Add Extract MySQLEX2 TranLog Begin now

3. Add remote trail 2 on cluster sfo.

   GGSCI (psfob) > Add RmtTrail /gg/dirdat/YY extract MySQLEX2

4. Configure replicat 2 on cluster nyc.

   GGSCI (pnycb) 11> edit param mysqlre2
   REPLICAT mysqlrep2
   DBOptions Host nyc-gg
   TargetDB golden USERID gg PASSWORD gg
   DISCARDFILE /gg/mysqlre2.dsc, PURGE
   REPERROR DEFAULT, ABEND
   AssumeTargetDefs
   Map golden.*, Target golden.*;

5. Add replicat 2 on cluster nyc.

   GGSCI (psfob) 11> Add Replicat MySQLRE2 exttrail /gg/dirdat/YY checkpointtable mysql.checkpoint

6. Start the manager on both clusters.

   Cluster nyc
   
   GGSCI (pnycb) > start mgr
   
   Cluster sfo
   
   GGSCI (psfob) > start mgr

7. Start the extract and replicat processes on both clusters.

   Cluster nyc
       
   GGSCI (pnycb) > start er *
       
   Cluster sfo
       
   GGSCI (psfob) > start er *

8. Check if everything is running on both clusters.

   Cluster nyc
       
   GGSCI (pnycb) > info all
       
   Cluster sfo
       
   GGSCI (psfob) > info all

9. Stop the extract and replicat processes on both clusters.

   Cluster nyc
       
   GGSCI (pnycb) > stop er *
       
   Cluster sfo
       
   GGSCI (psfob) > stop er *

10. Stop the manager process on both clusters.

    Cluster nyc
        
    GGSCI (pnycb) > stop mgr !
    GGSCI (pnycb) > exit
        
    Cluster sfo
        
    GGSCI (psfob) > stop mgr !
    GGSCI (psfob) > exit

11. Assuming the root role, kill the server process on both clusters.

    Cluster nyc
        
    pnycb # pkill -f server
        
    Cluster sfo
        
    psfob # pkill -f server

12. Assuming the root role, create the Oracle GoldenGate resources.

    Cluster nyc
        
    pnycb # clrs create -d -g mys-rg \
    -t GoldenGate \
    -p user=gg \
    -p Basepath=/gg \
    -p port=7809 \
    -p parameter_file=/gg/dirprm/mgr.prm \
    -p database_resource=mys-rs \
    -p resource_dependencies=mys-rs,nyc-gg \
    -p resource_dependencies_offline_restart=mys-hsp-rs,gg-hsp-rs \
    gg-rs
        
    Cluster sfo
        
    psfob # clrs create -d -g mys-rg \
    -t GoldenGate \
    -p user=gg \
    -p Basepath=/gg \
    -p port=7909 \
    -p parameter_file=/gg/dirprm/mgr.prm \
    -p database_resource=mys-rs \
    -p resource_dependencies=mys-rs,sfo-gg \
    -p resource_dependencies_offline_restart=mys-hsp-rs,gg-hsp-rs \
    gg-rs

13. On both clusters, enable the Oracle GoldenGate resource.

    pnycb # clresource enable gg-rs
    psfob # clresource enable gg-rs