.

SITE aSITE b

.

san.localdomainsan.localdomain

.

.

GG_HOMEGG_HOME

.

/u01/app/ggs01/u01/app/ggs02

.

.

GLOBALSGLOBALS

.

GGSCHEMA ggsGGSCHEMA ggs

.

CHECKPOINTTABLE GGR.CHECKPOINTCHECKPOINTTABLE GGR.CHECKPOINT

.

.

Diffrent port used since both nodes are on the same server to avoid port conflict; otherwise, same portDiffrent port used since both nodes are on the same server to avoid port conflict; otherwise, same port

.

mgr.prmmgr.prm

.

PORT 7901PORT 7902

.

DYNAMICPORTLIST 15010-15019DYNAMICPORTLIST 15020-15029

.

USERID ggs@pdb01, PASSWORD ggsUSERID ggs@pdb02, PASSWORD ggs

.

.

PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS, MINKEEPHOURS 3PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS, MINKEEPHOURS 3

.

PURGEMARKERHISTORY MINKEEPDAYS 5, MAXKEEPDAYS 7, FREQUENCYHOURS 24PURGEMARKERHISTORY MINKEEPDAYS 5, MAXKEEPDAYS 7, FREQUENCYHOURS 24

.

PURGEDDLHISTORY MINKEEPDAYS 5, MAXKEEPDAYS 7, FREQUENCYHOURS 24PURGEDDLHISTORY MINKEEPDAYS 5, MAXKEEPDAYS 7, FREQUENCYHOURS 24

.

.

AUTOSTART ER *AUTOSTART ER *

.

AUTORESTART ER *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 60AUTORESTART ER *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 60

.

.

LAGINFOMINUTES 0LAGINFOMINUTES 0

.

LAGREPORTMINUTES 60LAGREPORTMINUTES 60

.

LAGCRITICALMINUTES 15LAGCRITICALMINUTES 15

.

LAGREPORTMINUTES 60LAGREPORTMINUTES 60

.

.

ebidiaa.prmebidibb.prm

.

EXTRACT ebidiaaEXTRACT ebidibb

.

EXTTRAIL /u01/app/ggs01/dirdat/aaEXTTRAIL /u01/app/ggs02/dirdat/bb

.

USERID gge@pdb01, PASSWORD ggeUSERID gge@pdb02, PASSWORD gge

.

.

TRANLOGOPTIONS EXCLUDEUSER ggsTRANLOGOPTIONS EXCLUDEUSER ggs

.

TRANLOGOPTIONS EXCLUDEUSER ggrTRANLOGOPTIONS EXCLUDEUSER ggr

.

TRANLOGOPTIONS BUFSIZE 2048000TRANLOGOPTIONS BUFSIZE 2048000

.

TRANLOGOPTIONS DBLOGREADER, DBLOGREADERBUFSIZE 2048000TRANLOGOPTIONS DBLOGREADER, DBLOGREADERBUFSIZE 2048000

.

.

-- TRUNCATE permitted from Site a only-- TRUNCATE permitted from Site a only

.

GETTRUNCATESIGNORETRUNCATES

.

GETUPDATEBEFORESGETUPDATEBEFORES

.

.

WARNLONGTRANS 30m, CHECKINTERVAL 5mWARNLONGTRANS 30m, CHECKINTERVAL 5m

.

DDL INCLUDE ALL, EXCLUDE OBJTYPE 'SEQUENCE'DDL INCLUDE ALL, EXCLUDE OBJTYPE 'SEQUENCE'

.

DDLOPTIONS GETREPLICATES, GETAPPLOPS, ADDTRANDATA, REPORTDDLOPTIONS GETREPLICATES, GETAPPLOPS, ADDTRANDATA, REPORT

.

.

TABLE hr.*;TABLE hr.*;

.

TABLE sh.*;TABLE sh.*;

.

.

pbidiab.prmpbidiba.prm

.

EXTRACT pbidiabEXTRACT pbidiba

.

PASSTHRUPASSTHRU

.

RMTHOST san.localdomain MGRPORT 7902, COMPRESS, TIMEOUT 30, STREAMINGRMTHOST san.localdomain MGRPORT 7902, COMPRESS, TIMEOUT 30, STREAMINGSTREAMING (async)11.2.1.0.7

.

RMTTRAIL /u01/app/ggs02/dirdat/abRMTTRAIL /u01/app/ggs01/dirdat/ba

.

TABLE hr.*;TABLE hr.*;

.

TABLE sh.*;TABLE sh.*;

.

.

rbidiba.prmrbidiab.prm

.

REPLICAT rbidibaREPLICAT rbidiab

.

USERID ggr@pdb01, PASSWORD ggrUSERID ggr@pdb02, PASSWORD ggr

.

.

ASSUMETARGETDEFSASSUMETARGETDEFS

.

DISCARDFILE ./dirrpt/rbidiba.dsc, APPEND, MEGABYTES 500DISCARDFILE ./dirrpt/rbidiab.dsc, APPEND, MEGABYTES 500

.

.

-- Oracle GoldenGate Oracle Installation and Setup Guide (11.2) p110-- Oracle GoldenGate Oracle Installation and Setup Guide (11.2) p110

.

-- Propagating DDL in an active-active (bi-directional) configurations-- Propagating DDL in an active-active (bi-directional) configurations

.

DBOPTIONS SUPPRESSTRIGGERSDBOPTIONS SUPPRESSTRIGGERS

.

DDLOPTIONS UPDATEMETADATA, REPORTDDLOPTIONS UPDATEMETADATA, REPORT

.

DDL INCLUDE ALL, EXCLUDE OBJTYPE 'SEQUENCE'DDL INCLUDE ALL, EXCLUDE OBJTYPE 'SEQUENCE'

.

.

DDLERROR 942 IGNORE INCLUDE OPTYPE DROPDDLERROR 942 IGNORE INCLUDE OPTYPE DROP

.

DDLERROR DEFAULT, DISCARDDDLERROR DEFAULT, DISCARD

.

REPERROR (DEFAULT, DISCARD)REPERROR (DEFAULT, DISCARD)

.

REPERROR (DEFAULT2, DISCARD)REPERROR (DEFAULT2, DISCARD)

.

REPERROR (-1, DISCARD)REPERROR (-1, DISCARD)

.

.

-- TRUNCATE permitted from Site a only-- TRUNCATE permitted from Site a only

.

GETTRUNCATESIGNORETRUNCATES

.

ALLOWNOOPUPDATESALLOWNOOPUPDATES

.

MAP hr.*, TARGET hr.*;MAP hr.*, TARGET hr.*;

.

MAP sh.*, TARGET sh.*;MAP sh.*, TARGET sh.*;

.

.

-- Primary Extract to local trail aa-- Primary Extract to local trail bb

.

ADD EXTRACT ebidiaa, TRANLOG, BEGIN NOWADD EXTRACT ebidibb, TRANLOG, BEGIN NOW

.

ADD EXTTRAIL /u01/app/ggs01/dirdat/aa, EXTRACT ebidiaa, MEGABYTES 500ADD EXTTRAIL /u01/app/ggs02/dirdat/bb, EXTRACT ebidibb, MEGABYTES 500

.

.

-- DataPump Extract reads from local trail aa; pump to remote trail ab-- DataPump Extract reads from local trail bb; pump to remote trail ba

.

ADD EXTRACT pbidiab, EXTTRAILSOURCE /u01/app/ggs01/dirdat/aaADD EXTRACT pbidiba, EXTTRAILSOURCE /u01/app/ggs02/dirdat/bb

.

ADD RMTTRAIL /u01/app/ggs02/dirdat/ab, EXTRACT pbidiab, MEGABYTES 500ADD RMTTRAIL /u01/app/ggs01/dirdat/ba, EXTRACT pbidiba, MEGABYTES 500

.

.

-- Replicat from pump pbidiba-- Replicat from pump pbidiab

.

ADD REPLICAT rbidiba, EXTTRAIL /u01/app/ggs01/dirdat/baADD REPLICAT rbidiab, EXTTRAIL /u01/app/ggs02/dirdat/ab

.

.

.

GGSCI (arrow.localdomain) 1> info all

.

.

Program Status Group Lag at Chkpt Time Since Chkpt

.

.

MANAGER STOPPED

.

EXTRACT STOPPED EBIDIAA 00:00:00 00:07:52

.

EXTRACT STOPPED PBIDIAB 00:00:00 00:08:53

.

REPLICAT STOPPED RBIDIBA 00:00:00 00:08:42

.

.

Primary Extract writes to exttrail aa and Pump Extract reads from extrail aa writes remote rmttrail ab

.

GGSCI (arrow.localdomain) 2> info EXTTRAIL *

.

.

Extract Trail: /u01/app/ggs01/dirdat/aa

.

Extract: EBIDIAA

.

Seqno: 0

.

RBA: 0

.

File Size: 500M

.

.

Extract Trail: /u01/app/ggs02/dirdat/ab

.

Extract: PBIDIAB

.

Seqno: 0

.

RBA: 0

.

File Size: 500M

.

.

.

.

GGSCI (arrow.localdomain) 3> info RMTTRAIL *

.

.

Extract Trail: /u01/app/ggs01/dirdat/aa

.

Extract: EBIDIAA

.

Seqno: 0

.

RBA: 0

.

File Size: 500M

.

.

Extract Trail: /u01/app/ggs02/dirdat/ab

.

Extract: PBIDIAB

.

Seqno: 0

.

RBA: 0

.

File Size: 500M

.

.

.

Replicat read from ab

.

GGSCI (arrow.localdomain) 4> info RBIDIBA

.

.

REPLICAT RBIDIBA Initialized 2013-12-14 17:33 Status STOPPED

.

Checkpoint Lag 00:00:00 (updated 00:09:09 ago)

.

Log Read Checkpoint File /u01/app/ggs01/dirdat/ba000000

.

First Record RBA 0

.

.

.

GGSCI (arrow.localdomain) 5>