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在定时purge ddl产生的mark和history表的时候，找不到数据库，无法进行操作，最终的后果就是这几张表的数据会越来越大，如果不做处理的话最终会撑爆磁盘，导致goldengate挂起,后果很严重！！！

         查看了相关进程的参数发现,这个操作是由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进程中添加如下参数：

USERID ogg,PASSWORD AACAAAAAAAAAAADAQBLWDCIIOIRFMEPB,ENCRYPTKEY default

 

PS：由于我们对goldengate用户登录进行了加密操作，这里的USERID参数和抽取进程extract里设置的是一样的！

 

      然后重启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.

 

                记录一下~~

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25618347/viewspace-752894/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25618347/viewspace-752894/