Oracle Golden Gate探究（3）

Oracle GoldenGate for active-active high availability

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7721556/viewspace-707685/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7721556/viewspace-707685/