WARNING OGG-00952 Purging log history from OGG.GGS_DDL_HIST,ogg-00952purging
經常在巡檢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日誌發現沒有出現上述警告