检查发现ogg 目标端的rep1进程状态不正常
GGSCI (release-mysql) 49> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP1 00:00:00 00:01:19
错误日志如下:
2014-10-23 18:04:21 ERROR OGG-01172 Oracle GoldenGate Delivery for MySQL, rep1.prm: Discard file (/tol/ogg/dirrpt/rep4.dsc) exceeded max bytes (50000000).
这个错误时由于discardfile配置的megabytes 过小导致
解决方法:可以加大megabytes的配置,也可以删除/tol/ogg/dirrpt/rep4.dsc 文件,重启rep1进程
GGSCI (release-mysql) 50> view params rep1
replicat rep1
sourcedefs /tol/ogg/dirdef/goolen.prm
SOURCEDB ofdqs,userid root,password root
reperror default,discard
discardfile /tol/ogg/dirrpt/rep4.dsc,append,megabytes 50
。。。。
GGSCI (release-mysql) 51> edit params rep1
replicat rep1
sourcedefs /tol/ogg/dirdef/goolen.prm
SOURCEDB ofdqs,userid root,password root
reperror default,discard
discardfile /tol/ogg/dirrpt/rep4.dsc,append,megabytes 1000
。。。。。
GGSCI (release-mysql) 52> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (release-mysql) 53> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:05:05