WARNING OGG-00952 Purging log history from OGG.GGS_DDL_HIST,ogg-00952purging

來源:互聯網
上載者:User

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日誌發現沒有出現上述警告





相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.