Prerequisites on both systems

1>.configure the manager process

 GGSCI>edit params mgr

 PORT 7809

 PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl* , USECHECKPOINTS,MINKEEPHOURS 2

2>. configure the checkpoint table

GGSCI>edit params  ./GLOBALS

checkpointtable test.chpt

GGSCI>ADD CHECKPOINTTABLE

Configuration from primary system to secondary system

1>.configure the Extract group for primary system

GGSCI>ADD EXTRACT ext1, TRANLOG, BEGIN NOW

GGSCI>ADD EXTRAIL /u01/app/oracle/ggs/dirdat/rl, EXTRACT ext1

GGSCI>edit params ext1

EXTRACT ext1

USERID test, PASSWORD test

EXTRAIL /u01/app/oracle/ggs/dirdat/rl

TRANLOGOPTIONS  EXCLUDEUSER test

GETUPDATEBEFORES

TABLE db.*;

2>.configure the data pump for primary system

GGSCI>ADD EXTRACT pump1, EXTTRAILSOURCE /u01/app/oracle/ggs/dirdat/rl ,BEGIN NOW

GGSCI>ADD RMTTRAIL  /u01/app/oracle/ggs/dirdat/rl, EXTRACT pump1

GGSCI>edit params pump1

EXTRACT  pump1

USERID  test,PASSWORD test

RMTHOST 10.0.0.4,MGRPROT 7809

RMTTRAIL /u01/app/oracle/ggs/dirdat/rl

PASSTHRU

TABLE db.*;

3>.configure the Replicat group for secondary system

GGSCI>ADD REPLICAT rep1, EXTRAIL /u01/app/oracle/ggs/rl,BEGIN NOW

GGSCI>edit params rep1

REPLICAT rep1

USERID test,PASSWORD test

MAP db.*,TARGET db.*;

Configuration from secondary system to primary system

1>.configure the Extract group

GGSCI>ADD EXTRACT ext2,TRANLOG NOW

GGSCI>ADD EXTTRAIL /u01/app/oracle/ggs/dirdat/el ,EXTRACT ext2

GGSCI>edit params ext2

EXTRACT ext2

ASSUMETARGETDEFS

USERID test,PASSWORD test

EXTTRAIL  /u01/app/oracle/ggs/dirdat/el

TRANLOGOPTIONS  EXCLUDEUSER test

TABLE db.*;

2>.configure the data pump

GGSCI>ADD EXTRACT pump2, EXTRAILSOURCE /u01/app/oracle/ggs/dirdat/el,BEGIN NOW

GGSCI>ADD RMTTAIL /u01/app/oracle/ggs/dirdat/el, EXTRACT pump2

GGSCI>edit params pump2

EXTRACT pump2

USERID test,PASSWORD test

RMTHOST 10.0.0.3,MGRPORT 7809

RMTTRAIL /u01/app/oracle/ggs/dirdat/el

PASSTHRU

TABLE db.*;

3>.configure the Replicat group

GGSCI>ADD REPLICAT rep2,EXTRAIL /u01/app/oracle/ggs/dirdat/el,BEGIN NOW

GGSCI>edit params  rep2

REPLICAT rep2

USERID test,PASSWORD test

MAP db.*,TARGET db.*;

3.JPG