OGG-01172 exceeded max bytes (50000000)

检查发现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    

请使用浏览器的分享功能分享到微信等