关于GoldenGate配置

gundamff 2011-06-30 11:39:35
单实例2用户

源端配置
extract ext1
userid ggate@orcl, password ggate
rmthost test1, mgrport 7809
gettruncates
rmttrail /u01/app/oracle/ggate/dirdat/lt
ddl include mapped objname exam.*,include mapped objname exam2.*
table exam.*
table exam2.*;

目标

replicat rep1
SETENV (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")
GETENV (NLS_LANG)
ASSUMETARGETDEFS
userid ggate@orcl, password ggate
gettruncates
discardfile /u01/app/oracle/ggate/dirdat/rep1_discard.txt, append, megabytes 10
DDL
DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3 RETRYDELAY 5
DDLOPTIONS REPORT
map exam.*, target exam.*
map exam2.*,target exam2.*;

这么配置的话,2个用户 exam和exam2的 DLL语句可以同步,但是insert语句会报错,如下:


2011-06-30 11:30:35 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ext1.prm: Socket buffer size set to 27985 (flush size 27985).
2011-06-30 11:30:35 GGS INFO 112 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery initialization completed for target file /u01/app/oracle/ggate/dirdat/lt000003, at RBA 2294.
2011-06-30 11:30:35 GGS INFO Z0-05M Oracle GoldenGate Capture for Oracle, ext1.prm: Output file /u01/app/oracle/ggate/dirdat/lt is using format RELEASE 10.4.
2011-06-30 11:30:35 GGS INFO 224 Oracle GoldenGate Capture for Oracle, ext1.prm: Rolling over remote file /u01/app/oracle/ggate/dirdat/lt000004.
2011-06-30 11:30:35 GGS INFO 112 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for target file /u01/app/oracle/ggate/dirdat/lt000004, at RBA 924.
2011-06-30 11:30:35 GGS INFO 112 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for all targets.
2011-06-30 11:30:36 GGS ERROR 101 Oracle GoldenGate Capture for Oracle, ext1.prm: Invalid option for MAP: table.
2011-06-30 11:30:36 GGS ERROR 190 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
...全文
497 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
horse_jlg 2011-07-01
  • 打赏
  • 举报
回复
注意语法和格式。特别是空格
c297186864 2011-06-30
  • 打赏
  • 举报
回复
二师兄 我路过

3,492

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧