Oracle Golden Gate 探究（1）

Creating a standard reporting configuration

 

Source system:

1>. configure and startup the manager process

GGSCI> edit params mgr

----configure manager process port number

PORT 7809                                                                         

----startup manager process

GGSCI>start  mgr                                                                        

2>. configure the extract group

----- 必须以sysdba权限登录，否则无法创建extract GROUP   

GGSCI>dblogin userid test,password test sysdba

----create extract group

GGSCI>ADD EXTRACT ext1, TRANLOG, BEGIN NOW

----specify a remote trail

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

---edit extract parameter file

GGSCI>edit params ext1

EXTRACT  ext1

USERID  test,PASSWROD  test

RMTHOST 10.0.0.4,MGRPORT 7809

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

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  mgr                                                                      

2>. create checkpoint table

GGSCI>edit params ./GLOBALS

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

checkpointtable test.chpt                                                          

GGSCI>dblogin userid test,password test

GGSCI>ADD CHECKPOINTTABLE

3>. configure the Replicat group

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

GGSCI>edit params rep1 

REPLICAT rep1

USERID test, PASSWORD test

ASSUMETARGETDEFS

MAP test.*, TARGET test.*;

GGSCI>start rep1


至此，一个标准简单的golden gate配置完成。
平台是：Redhat AS4 + Oracle 10G +Golden Gate 11g

1.JPG

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

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