ogg方面不熟，基本都是出了什么问题，才去查相应的资料。

这次是因为一部分归档日志没有了，又因为所涉及的表都是会全量刷新的物化视图，所以准备使用重新抓取的方式，继续使用，以下是步骤

查看抓取进程

GGSCI (IRMS_DB1) 27> info extnj detail

EXTRACT EXTNJ Last Started 2014-06-18 10:10 Status STOPPED
Checkpoint Lag 00:00:00 (updated 119:59:57 ago)
Log Read Checkpoint Oracle Redo Logs
2014-06-18 10:13:31 Thread 1, Seqno 9709, RBA 271958144
SCN 2726.3337028282 (11711417877178)
Log Read Checkpoint Oracle Redo Logs
2014-06-18 10:13:29 Thread 2, Seqno 6980, RBA 213361184                 标红的为错误停止时抓取的归档日志号
SCN 2726.3337027125 (11711417876021)

GGSCI (IRMS_DB1) 3> alter dppnj extseqno 10430,extrba 0 thread 1;      查看相应节点上的归档序号后，使用该命令进行重置，extrba指rba，从该文件头开始读
EXTRACT altered.

GGSCI (IRMS_DB1) 6> alter extnj extseqno 8057,extrba 0 thread 2;
EXTRACT altered.

GGSCI (IRMS_DB1) 10> info extnj                                                          新的进程情况

EXTRACT EXTNJ Last Started 2014-06-23 10:54 Status STOPPED
Checkpoint Lag 00:00:07 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Redo Logs
2014-06-23 10:54:19 Thread 1, Seqno 10432, RBA 425472
SCN 2727.1005238963 (11713381055155)
Log Read Checkpoint Oracle Redo Logs
2014-06-23 10:54:14 Thread 2, Seqno 8059, RBA 992475372
SCN 2727.1005237295 (11713381053487)

重新设置投递进程
GGSCI (IRMS_DB1) 11> info dppnj

EXTRACT DPPNJ Last Started 2014-06-23 10:54 Status ABENDED
Checkpoint Lag 00:00:00 (updated 00:00:21 ago)
Log Read Checkpoint File /archive/rmshare2/goldengate/dirdat/EXTNJ/gd008057
First Record RBA 0

GGSCI (IRMS_DB1) 12> alter dppnj extseqno 688,extrba 0                                       这里需要设置的是当前文件号
EXTRACT altered.

GGSCI (IRMS_DB1) 13> info dppnj

EXTRACT DPPNJ Initialized 2014-06-23 10:55 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint File /archive/rmshare2/goldengate/dirdat/EXTNJ/gd000688
First Record RBA 0

GGSCI (IRMS_DB1) 14> info extnj

EXTRACT EXTNJ Last Started 2014-06-23 10:54 Status STOPPED
Checkpoint Lag 00:00:07 (updated 00:01:06 ago)
Log Read Checkpoint Oracle Redo Logs
2014-06-23 10:54:19 Thread 1, Seqno 10432, RBA 425472
SCN 2727.1005238963 (11713381055155)
Log Read Checkpoint Oracle Redo Logs
2014-06-23 10:54:14 Thread 2, Seqno 8059, RBA 992475372
SCN 2727.1005237295 (11713381053487)

GGSCI (IRMS_DB1) 15> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT STOPPED DPPNJ 00:00:00 00:00:34
EXTRACT STOPPED EXTNJ 00:00:07 00:01:14

GGSCI (IRMS_DB1) 16>

GGSCI (IRMS_DB1) 16> start extnj

Sending START request to MANAGER ...
EXTRACT EXTNJ starting

GGSCI (IRMS_DB1) 17> start dppnj

Sending START request to MANAGER ...
EXTRACT DPPNJ starting

GGSCI (IRMS_DB1) 18> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING DPPNJ 00:00:00 00:00:52
EXTRACT RUNNING EXTNJ 00:01:35 00:00:03