OGG-00952---oracle goldengate無法purge歷史表和mark表處理一例

今天觀察oracle  goldengate的errlog發現一直會有如下的告警資訊：

 

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.

         檢視了相關程式的引數發現,這個操作是由goldengate的manager程式處理的，具體引數如下：

 

GGSCI (testdb) 3> edit params mgr
PORT 7809
dynamicportlist 7810-7820
PURGEOLDEXTRACTS /home/oracle/ggs/dirdat/k1*, USECHECKPOINTS, MINKEEPFILES 15
AUTORESTART ER *, RETRIES 3, WAITMINUTES 5
PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30

其中黑色斜體部分就是做相關處理的具體引數，查閱相關文件後發現，在做這個操作的時候需要goldengate的使用者程式登陸到資料庫進行操作，這就需要新增一個引數USERID來進行登陸，而PURGEOLDEXTRACTS這個引數在purge trail檔案的時候是不需要進行這一操作的，難怪這個引數生效了，而其他2個引數始終無法順利執行！！

 

      最後在manager程式中新增如下引數：

 

 

      然後重啟manager程式，觀察errlog發現：

2013-01-18 17:14:17  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 127.0.0.1 (STOP).
2013-01-18 17:14:17  WARNING OGG-00938  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager is stopping at user request.
2013-01-18 17:14:19  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
2013-01-18 17:14:26  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2013-01-18 17:15:08  INFO    OGG-00953  Oracle GoldenGate Manager for Oracle, mgr.prm:  Purging log history from OGG.GGS_DDL_HIST older than 2013-01-13 16:12:52.695485: 122158 rows deleted from OGG.GGS_DDL_HIST.
2013-01-18 17:15:51  INFO    OGG-00953  Oracle GoldenGate Manager for Oracle, mgr.prm:  Purging log history from OGG.GGS_DDL_HIST_ALT older than 2013-01-13 16:15:08.764283: 114587 rows deleted from OGG.GGS_DDL_HIST_ALT.
2013-01-18 17:15:51  INFO    OGG-00953  Oracle GoldenGate Manager for Oracle, mgr.prm:  Purging log history from OGG.GGS_MARKER older than 2013-01-13 16:15:51.966245: 125481 rows deleted from OGG.GGS_MARKER.