首页 > 代码库 > WARNING OGG-00952 Purging log history from OGG.GGS_DDL_HIST
WARNING OGG-00952 Purging log history from OGG.GGS_DDL_HIST
经常在巡检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