Oracle Golden Gate探究（2）

Creating a reporting configuration with a data pump on the source system Source system

Source system：

 

 1>. configure and startup the manager process

  GGSCI>edit params mgr

  ----configure manager process port number

  PORT  7809

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

  ----startup manager process              

  GGSCI>start mgr                                                                                      

 

 2>. configure the primary Extract group

  GGSCI>dblogin userid test，password test sysdba

  GGSCI>ADD EXTRACT ext1,TRANGLOG,BEGIN NOW

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

            

  GGSCI>edit params ext1

             

  USERID test,PASSWORD test/

  EXTTRAIL  /u01/app/oracle/ggs/dirdat/rl

  GETTRUNCATES

  TABLE test.*;

 

 3>. configure the data pump Extract group

 

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

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

 

 GGSCI>edit params pump1

 

 EXTRACT pump1

 USERID test,PASSWORD test

 RMTHOST 10.0.0.4,MGRPORT 7809

 RMTRAIL /u01/app/oracle/ggs/dirdat/rl

 PASSTHRU

 GETTRUNCATES

 TABLE test.*;

 

Target system:

        

 1>. configure and startup the manager process

 GGSCI>edit params mgr

 ----configure manager process port number

 PORT  7809

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

 ----startup manager process

 GGSCI>start manager mgr

                                                                                               

 2>. create checkpoint table

 

 ----参数生效需要重新登录GGSCI

 GGSCI>edit params ./GLOBALS

 checkpointtable test.chpt                                                                       

 

 GGSCI>dblogin userid test,password test

 GGSCI>ADD CHECKPOINTTABLE

              

 3>. configure the Replicat group

 

 -----create replicat group

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

 ------configure replicat group            

 GGSCI>edit params rep1

 

 REPLICAT rep1

 USERID test,PASSWORD test

 ASSUMETARGETDEFS

 GETTRUNCATES

 MAP test.*,TARGET test.*;

 

2.JPG

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

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