GoldenGate Node A to Node B to Node C
NODE A
NODE A EXTRACT
extract EXTA
SETENV (NLS_LANG = ENGLISH_UNITED KINGDOM.AL32UTF8)
SETENV (ORACLE_HOME = “/u01/app/oracle/product/12.1.0.2/dba”)
SETENV (ORACLE_SID = “dba”)
USERIDALIAS ggadmin
TRANLOGOPTIONS DBLOGREADER
DISCARDFILE disc/dba.dsc, append, megabytes 500
EXTTRAIL /backup/oracle/gg/dirdat/AP
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
DDL INCLUDE ALL
DDLOPTIONS ADDTRANDATA
TABLEEXCLUDE *.DBMS**
TABLE PHH.*;
SEQUENCE PHH.*;
NODE A PUMP
extract PMPA
SETENV (NLS_LANG = ENGLISH_UNITED KINGDOM.AL32UTF8)
SETENV (ORACLE_HOME = “/u01/app/oracle/product/12.1.0.2/dba”)
SETENV (ORACLE_SID = “dba”)
USERIDALIAS ggadmin
RmtHost nodeB, MgrPort 8880
RmtTrail /backup/oracle/gg/dirdat/AP
PASSTHRU
TABLE PHH.*;
SEQUENCE PHH.*;
NODE B REPLICAT
REPLICAT REPB
SETENV (NLS_LANG = ENGLISH_UNITED KINGDOM.AL32UTF8)
SETENV (ORACLE_HOME = “/u01/app/oracle/product/12.1.0.2/dbb”)
SETENV (ORACLE_SID = “dbb”)
ASSUMETARGETDEFS
USERIDALIAS ggadmin
DISCARDFILE /backup/oracle/gg/disc/dbb.dsc, append, megabytes 100
DDL INCLUDE ALL
DDLOPTIONS UPDATEMETADATA
MAPEXCLUDE PHH.TABN
MAP PHH.*, TARGET PHH.*;
NODE B EXTRACT
extract EXTB
SETENV (NLS_LANG = ENGLISH_UNITED KINGDOM.AL32UTF8)
SETENV (ORACLE_HOME = “/u01/app/oracle/product/12.1.0.2/DBB”)
SETENV (ORACLE_SID = “DBB”)
USERIDALIAS ggadmin
DISCARDFILE disc/DBB.dsc, append, megabytes 500
EXTTRAIL /backup/oracle/gg/dirdat/BP
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
DDL INCLUDE ALL
DDLOPTIONS GETREPLICATES, GETAPPLOPS, REMOVECOMMENTS BEFORE
TABLEEXCLUDE *.DBMS**
TABLE PHH.*;
SEQUENCE PHH.*;
NODE B PUMP
NODEC
NODE C REPLICAT
GGSCI
NODE A
ADD EXTRACT EXTA integrated tranlog, begin now
register extract EXTA database
ADD EXTTRAIL /backup/oracle/gg/dirdat/AP Â EXTRACT EXTA Â MEGABYTES 250
start extract EXTA
ADD EXTRACT PMPA Â EXTTRAILsource /backup/oracle/gg/dirdat/AP
ADD RMTTRAIL /backup/oracle/gg/dirdat/AP EXTRACT PMPA Â MEGABYTES 250
start extract PMPA
NODE B
add replicat REPB integrated exttrail /backup/oracle/gg/dirdat/AP
start replicat REPB
Discussion ¬