王涛，从事IT行业8年，曾担任高校，食品，银行以及电力能源行业信息系统建设项目经理，技术骨干。专注于系统架构优化，信息系统研发质量管控，软硬件容量测算研究。
“Oracle golden gate各场景配置”被itpub社区推举为“推荐文章”。
地址：http://blog.itpub.net/7721556/viewspace-707655
1. Creating a standard reporting configuration
Source system:
1>. configure and startup the managerprocess
----configure manager process port number
edit params mgr
port 7809
----startup manager process
start mgr
2>. configure the extract group
dbloginuserid test,password testsysdba
----create extract group
ADD EXTRACT ext1, TRANLOG,BEGIN NOW
----specify a remote trail
ADD RMTTRAIL/u01/app/oracle/ggs/dirdat/rl ,EXTRACT ext1
---edit extract parameter file
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 managerprocess
edit params mgr
----configuremanager process port number
PORT 7809
PURGEOLDEXTRACTS u01/app/oracle/ggs/dirdat/rl* USECHECKPOINTS,MINKEEPHOURS2
----startup manager process
start mgr
2>. createcheckpoint table
edit params ./GLOBALS
checkpointtable test.chpt ----参数生效需要重新登录GGSCI
dblogin userid test,passwordtest
ADD CHECKPOINTTABLE
3>. configurethe Replicat group
ADD REPLICAT rep1, EXTTRAIL u01/app/oracle/ggs/dirdat/rl,BEGIN NOW
edit params rep1
REPLICAT rep1
USERID test, PASSWORD test
ASSUMETARGETDEFS
MAP test.*, TARGET test.*;
2. Creatinga reporting configuration with a data pump on the source systemSource system:
Source system：
1>. configure and startup the manager process
GGSCI>editparams mgr
----configure manager process port number
PORT 7809
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl* USECHECKPOINTS,MINKEEPHOURS 2
----startup manager process
GGSCI>startmgr
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/rlEXTRACT ext1
GGSCI>edit params ext1
USERID test, PASSWORD test
EXTTRAIL u01/app/oracle/ggs/dirdat/rl
GETTRUNCATES
TABLEtest.*;
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/ggs/dirdat/r1, EXTRACTpump1
GGSCI>edit params pump1
EXTRACT pump1
USERIDtest,PASSWORD test
RMTHOST10.0.0.4,MGRPORT 7809
RMTRAIL/u01/app/oracle/ggs/dirdat/rl
PASSTHRU
GETTRUNCATES
TABLEtest.*;
Target system:
1>.configure and startup the manager process
GGSCI>edit params mgr
----configuremanager process port number
PORT 7809
PURGEOLDEXTRACTS u01/app/oracle/ggs/dirdat/rl* USECHECKPOINTS,MINKEEPHOURS 2
----startupmanager process
GGSCI>start manager mgr
2>.create checkpoint table
----参数生效需要重新登录GGSCI
GGSCI>edit params ./GLOBALS
checkpointtabletest.chpt
GGSCI>dbloginuserid test,passwordtest
GGSCI>ADD CHECKPOINTTABLE
3>.configure the Replicat group
-----create replicat group
GGSCI>ADD REPLICAT rep1, EXTTRAIL/u01/app/oracle/ggs/dirdat/rl ,BEGIN NOW
------configurereplicat group
GGSCI>edit params rep1
REPLICATrep1
USERIDtest,PASSWORD test
ASSUMETARGETDEFS
GETTRUNCATES
MAPtest.*,TARGET test.*;
3. Creating a reporting configuration with adata pump on an intermediary system
Source system:
1>. configureand startup the manager process
edit params mgr
PORT7809 ----configuremanager process port number
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl* USECHECKPOINTS,MINKEEPHOURS2
start manager mgr ----startup manager process
2>.configure the primary Extract group
ADDEXTRACT ext1,TRANGLOG,BEGIN NOW
ADDEXTRACTRAIL u01/app/oracle/ggs/dirdat/rl, EXTRACT ext1
edit params ext1
USERIDggs,PASSWORD ggs
EXTTRAIL /u01/app/oracle/ggs/dirdat/rl
TABLE ggs.ggs;
3>. configure the data pump Extract group
ADD EXTRACT pump1,EXTRAILSOURCE/u01/app/oracle/ggs/dirdat/rl,BEGIN NOW
ADD RMTTRAIL u01/app/oracle/ggs/dirdat/rl, EXTRACT pump1
edit params pump1
EXTRACT pump1
USERID ggs,PASSWORD ggs
RMTHOST 10.0.0.4, MGRPORT 7809
RMTRAIL u01/app/oracle/ggs/dirdat/rl
TABLE ggs.ggs;
Intermediary system:
1>. configureand startup the manager process
edit params mgr
port 7809 ----configure manager process port number
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl*USECHECKPOINTS,MINKEEPHOURS 2
start managermgr ----startup manager process
2>. configure the data pump
ADD EXTRACT pump2, EXTTRAILSOURCE/u01/app/oracle/ggs/dirdat/rl,BEGIN NOW
ADD EXTTRAIL/u01/app/oracle/ggs/dirdat/rl, EXTRACT pump2
edit params pump2
EXTRACT pump2
RMTHOST 10.0.0.2,MGRPORT 7809
RMTRAIL/u01/app/oracle/ggs/dirdat/rl
TABLE ggs.ggs;
Target system:
1>. configure and startup the managerprocess
edit params mgr
port7809 ----configuremanager process port number
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl* USECHECKPOINTS,MINKEEPHOURS2
start manager mgr ----startupmanager process
2>.create checkpoint table
dbloginuserid ggs,password ggs
ADD CHECKPOINTTABLE ggs.ggs
3>.configure the Replicat group
ADDREPLICAT rep1, EXTRACTRAIL ext1,BEGIN NOW
editparams rep1
REPLICATrep1
USSERIDggs,PASSWORD ggs
MAPggs.ggs,TARGET ggs.ggs;
4. Creating a cascading reportingconfiguration
Source system:
1>. configure and startup the managerprocess
editparams mgr
port 7809 ----configure manager process port number
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl*USECHECKPOINTS,MINKEEPHOURS 2
start manager mgr ----startup manager process
2>. configure the primary Extract group
ADD EXTRACT ext1,TRANGLOG,BEGIN NOW
ADD EXTRACTRAIL /u01/app/oracle/ggs/dirdat/rl, EXTRACText1
edit params ext1
USERID ggs,PASSWORD ggs
EXTTRAIL /u01/app/oracle/ggs/dirdat/rl
TABLE ggs.ggs;
3>. configure the data pump Extract group
ADD EXTRACT pump1,EXTRAILSOURCE/u01/app/oracle/ggs/dirdat/rl,BEGIN NOW
ADD RMTTRAIL /u01/app/oracle/ggs/dirdat/rl, EXTRACT pump1
edit params pump1
EXTRACT pump1
USERID ggs,PASSWORD ggs
RMTHOST 10.0.0.4,MGRPORT 7801
RMTRAIL /u01/app/oracle/ggs/dirdat/rl
TABLE ggs.ggs;
Secondsystem in the cascade:
1>. configure and startup the manager process
edit params mgr
port 7809 ----configuremanager process port number
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl* USECHECKPOINTS,MINKEEPHOURS2
start managermgr ----startup manager process
2>. create checkpoint table
dblogin userid ggs,password ggs
ADD CHECKPOINTTABLE ggs.ggs
3>. configure the Replicat group
ADD REPLICAT rep1, EXTRACTRAIL ext1,BEGIN NOW
edit params rep1
REPLICAT rep1
USSERID ggs,PASSWORD ggs
MAP ggs.ggs,TARGET ggs.ggs;
4>. configure the extract group
ADD EXTRACT ext2,TRANLOG,BEGIN NOW
ADD EXTTRAIL /u01/app/oracle/ggs/dirdat/rl, EXTRACT ext2
edit params ext2
EXTRACT ext2
EXTTRAIL /u01/app/oracle/ggs/dirdat/rl
IGNOREAPPLOPS,GETREPLICATES
TABLE ggs.ggs
5>. configure the data dump
ADDEXTRACT pump2,EXTTRAILSOURCE /u01/app/oracle/ggs/dirdat/rl,BEGIN NOW
ADDRMTTRAIL /u01/app/oracle/ggs/dirdat/rl,EXTRACT pump2
edit params pump2
EXTRACTpump2
RMTHOST10.0.0.2,MGRPORT 7809
RMTRAIL /u01/app/oracle/ggs/dirdat/rl
TABLEggs.ggs;
Thirdsystem in the cascade:
1>. configure and startup the manager process
editparams mgr
port 7809 ----configuremanager process port number
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl* USECHECKPOINTS,MINKEEPHOURS 2
start manager mgr ----startup manager process
2>. create checkpoint table
dbloginuserid ggs,password ggs
ADDCHECKPOINTTABLE ggs.ggs
3>. configure the Replicat group
ADDREPLICAT rep2, EXTRACTRAIL ext2,BEGIN NOW
edit params rep2
REPLICATrep2
USSERIDggs,PASSWORD ggs
MAPggs.ggs,TARGET ggs.ggs;
联系我们
子衿技术公众号，邀请IT界技术大牛激扬文字，发表真知灼见，篇篇干货。
我们依托南瑞集成实验室，开展线下交流，动手实践，欢迎您的加入！
地址：南京市江宁区诚信大道19号南京南瑞集团公司信息系统集成分公司
电话：025-81095705
欢迎扫码关注子衿技术
2）投稿数量较多的作者可获赠礼品。
3）从关注的用户中定期抽取3名幸运关注用户，这3名幸运用户可获赠礼品。
技术干货文章随时欢迎向“子衿技术团队”订阅号投稿。
投稿邮箱：xx.miaojingwen@163.com
