关于GoldenGate配置
单实例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.