首页 > 其他 > 详细

WARNING OGG-00952 Purging log history from OGG.GGS_DDL_HIST

时间:2014-09-16 10:45:30      阅读:592      评论:0      收藏:0      [点我收藏+]

经常在巡检OGG日志的时候发现如下警告:
2013-01-18 16:52:56  WARNING OGG-00952  Oracle GoldenGate Manager for Oracle, mgr.prm:  Purging log history from OGG.GGS_DDL_HIST older than 2013-01-13 15:52:56.084114: Could not delete rows from OGG.GGS_DDL_HIST, no database specified.
2013-01-18 16:52:56  WARNING OGG-00952  Oracle GoldenGate Manager for Oracle, mgr.prm:  Purging log history from OGG.GGS_DDL_HIST_ALT older than 2013-01-13 15:52:56.084261:Could not delete rows from OGG.GGS_DDL_HIST_ALT, no database specified.
2013-01-18 16:52:56  WARNING OGG-00952  Oracle GoldenGate Manager for Oracle, mgr.prm:  Purging log history from OGG.GGS_MARKER older than 2013-01-13 15:52:56.084448: Could not delete rows from OGG.GGS_MARKER, no database specified.

开始没有引起重视,后面发现OGG的表空间使用率渐渐升高。才觉得与这个有关系,于是上网查了资料。果然如此

引起这个警告的原因是,OGG做这个操作需要进入到数据库里面,所以我们需要在MANAGER里面加入如下参数:
USERID OGG,PASSWORD DFASDFASFASDADFAD,ENCRYPTKEY DEFAULT

MANAGER修改参数不需要重启进程,只用刷新进程即可:
refresh manager

重新监控OGG ggserr.log日志发现没有出现上述警告


WARNING OGG-00952 Purging log history from OGG.GGS_DDL_HIST

原文:http://blog.csdn.net/zbdba/article/details/39313379

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!