1.查看OGG运行状态
GGSCI (crm_slave) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REPL 2252:03:37 22:37:05
GGSCI (crm_slave) 4> view report repl
2017-04-19 09:25:28 ERROR OGG-01172 Discard file (/oradata/gglog/repl.dsc) exceeded max bytes (500000000).
2017-04-19 09:25:28 ERROR OGG-01668 PROCESS ABENDING.
解决方法:
GGSCI (crm_slave) 4> edit params repl
discardfile /oradata/gglog/repl.dsc,append,megabytes 50000 --加大这个值
加大日志文件大小后结果:
GGSCI (crm_slave) 5> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPL 2273:08:34 00:00:00
GGSCI (crm_slave) 6>
本文转自 z597011036 51CTO博客,原文链接:http://blog.51cto.com/tongcheng/1917266,如需转载请自行联系原作者