先说问题,后面附上配置:
在源端ggsci中启动start w1extdp 的时候,报错信息如下:
在目标端也有类似错误:
这些文件的确不存在,但在/opt/gg/trails/下有类似的文件,但文件名比上面的文件名要长(多了3个零)
ogg抽取生成的日志文件名称长度,比ogg replicat需要的日志文件名长度要长,所以肯定会报错,
问题是,为什么会产生这种不一致的情况呢?如何解决?
--源端配置:
GGSCI (rhel7ogg2.localdomain) 33> view params mgr
PORT 7809
USERID goldengate@orcl, PASSWORD goldengate
PURGEOLDEXTRACTS /opt/gg/trails/w1*, USECHECKPOINTS, MINKEEPFILES 10
AUTORESTART ER *, RETRIES 3, WAITMINUTES 5
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
ACCESSRULE, PROG SERVER, ALLOW
GGSCI (rhel7ogg2.localdomain) 34> view params w1ext
EXTRACT w1ext
USERID goldengate@orcl, PASSWORD goldengate
EXTTRAIL /opt/gg/trails/w1
DISCARDFILE w1extdsc,APPEND,MEGABYTES 5
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
FETCHOPTIONS, USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
WARNLONGTRANS 1H, CHECKINTERVAL 5M
TABLE goldengate.*;
GGSCI (rhel7ogg2.localdomain) 35> view params w1extdp
EXTRACT w1extdp
USERID goldengate@orcl, PASSWORD goldengate
RMTHOST 192.168.56.101, MGRPORT 7809
RMTTRAIL /opt/gg/trails/w1
DISCARDFILE w1extdpdsc,APPEND,MEGABYTES 5
TABLE goldengate.*;
GGSCI (rhel7ogg2.localdomain) 36> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING W1EXT 00:00:00 00:00:02
EXTRACT ABENDED W1EXTDP 18:26:33 00:55:05
-------------------------------------------------------------------------------------
--目标端配置:
GGSCI (rhel7ogg1.localdomain as goldengate@orcl) 83> view params mgr
PORT 7809
USERID goldengate@orcl, PASSWORD goldengate
PURGEOLDEXTRACTS /opt/gg/trails/w1*, USECHECKPOINTS, MINKEEPFILES 10
AUTORESTART ER *, RETRIES 3, WAITMINUTES 5
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
ACCESSRULE, PROG SERVER, ALLOW
GGSCI (rhel7ogg1.localdomain as goldengate@orcl) 84> view params w1rep
REPLICAT w1rep
ASSUMETARGETDEFS
USERID goldengate@orcl, PASSWORD goldengate
DISCARDFILE w1repdsc,APPEND,MEGABYTES 5
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
BATCHSQL
DBOPTIONS DEFERREFCONST
DBOPTIONS LOBWRITESIZE 102400
HANDLECOLLISIONS
DDLERROR DEFAULT DISCARD RETRYOP MAXRETRIES 5 RETRYDELAY 20
MAP goldengate.* , TARGET goldengate.* ;