今天在给客户安装OGG的时候，PUMP进程无法启动。

GGSCI (ycods1) 21> start PUMPBAM

Sending START request to MANAGER ...
EXTRACT PUMPBAM starting
GGSCI (ycods1) 22> info all
Program     Status      Group       Lag           Time Since Chkpt
MANAGER     RUNNING
EXTRACT     RUNNING     EXTBAM      00:00:00      00:00:09
EXTRACT     ABENDED     PUMPBAM     00:00:00      03:03:14
REPLICAT    RUNNING     REPCIMXB    00:00:00      00:00:03
REPLICAT    RUNNING     TREPLVA     00:00:00      00:00:01

观察日志，发现OGG-01044错误。

2013-05-08 15:13:40  ERROR   OGG-01044  The trail './dirdat/SG_BAM_UPLOAD/XB' is not assigned to extract 'PUMPBAM'. Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL ./dirdat/SG_BAM_UPLOAD/XB, EXTRACT PUMPBAM.

2013-05-08 15:13:40  ERROR   OGG-01668  PROCESS ABENDING.

这个错误应该是最简单最好解决的错误，因为，OGG已经给出了解决方法。该问题是由于在PUMP进程的配置文件中指定目标端存放trail文件的目录是./dirdat/SG_BAM_UPLOAD，而在ADD RMTTRAIL的时候指定了错误的地址，解决方法很简单，报错信息下面已经给出提示，只要修改下就可以用了，所以这应该是最好解决的错误。

GGSCI (ycods1) 24> add RMTTRAIL ./dirdat/SG_BAM_UPLOAD/XB, EXTRACT PUMPBAM

RMTTRAIL added.

仔细观察其他配置没有问题后，启动PUMP进程。

GGSCI (ycods1) 25> start PUMPBAM

Sending START request to MANAGER ...
EXTRACT PUMPBAM starting
GGSCI (ycods1) 26> info all

Program     Status      Group       Lag           Time Since Chkpt
MANAGER     RUNNING
EXTRACT     RUNNING     EXTBAM      00:00:00      00:00:06
EXTRACT     RUNNING     PUMPBAM     00:00:00      03:04:25
REPLICAT    RUNNING     REPCIMXB    00:00:00      00:00:04
REPLICAT    RUNNING     TREPLVA     00:00:00      00:00:02

经过测试，PUMP进程可以正确传送trail日志信息。

Start of Statistics at 2013-05-08 15:26:54.

Output to ./dirdat/SG_BAM_UPLOAD/XB:
Extracting from SG_BAM.BAM_PROCESSINST to SG_BAM.BAM_PROCESSINST:

*** Total statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

*** Daily statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

*** Hourly statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

*** Latest statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

Extracting from SG_BAM.BAM_ACTIVITYINST to SG_BAM.BAM_ACTIVITYINST:

*** Total statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

*** Daily statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

*** Hourly statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

*** Latest statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

End of Statistics.

本文固定链接: https://www.dbdream.com.cn/2013/05/ogg%e5%90%af%e5%8a%a8pump%e8%bf%9b%e7%a8%8b%e9%81%87%e5%88%b0ogg-01044%e9%94%99%e8%af%af/ | 信春哥，系统稳，闭眼上线不回滚！