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

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

extract PMPB
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
RmtHost NODEC, MgrPort 8880
RmtTrail /backup/oracle/gg/dirdat/CP
PASSTHRU
TABLE PHH.*;
SEQUENCE PHH.*;

NODEC

NODE C REPLICAT

REPLICAT REPC
SETENV (NLS_LANG = ENGLISH_UNITED KINGDOM.AL32UTF8)
SETENV (ORACLE_HOME = “/u01/app/oracle/product/12.1.0.2/dbc”)
SETENV (ORACLE_SID = “dbc”)
ASSUMETARGETDEFS
USERIDALIAS ggadmin
DISCARDFILE /backup/oracle/gg/disc/dbc.dsc, append, megabytes 100
DDL INCLUDE ALL
MAPEXCLUDE PHH.TESTZ
MAP PHH.*, TARGET PHH.*;

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

ADD EXTRACT EXTB integrated tranlog, begin now
REGISTER EXTRACT EXTB database
ADD EXTTRAIL /backup/oracle/gg/dirdat/BP  EXTRACT EXTB MEGABYTES 250
ADD EXTRACT PMPB  EXTTRAILsource /backup/oracle/gg/dirdat/dbp/BP
ADD RMTTRAIL /backup/oracle/gg/dirdat/CP EXTRACT PMPB  MEGABYTES 250
START EXTRACT EXTB
START EXTRACT PMPB

NODE C

add replicat REPC integrated exttrail /backup/oracle/GG/dirdat/CP
start replicat REPC