ogg 抽取进程停不下来的解决方法

问题描述：ogg停止抽取进程停止不下来

GGSCI (ex02db02.iris.cl.sh.cos) 6> stop extu6

Sending STOP request to EXTRACT EXTU6 ...

There are open, long-running transactions. Before you stop Extract, make the archives containing data for those transactions available for when Extract restarts. To force Extract to stop, use the SEND EXTRACT EXTU6, FORCESTOP command.
Oldest redo log files necessary to restart Extract are:

Redo Thread 1, Redo Log Sequence Number 2010, SCN 0.2340216775 (2340216775), RBA 2150464016
Redo Thread 2, Redo Log Sequence Number 3767, SCN 0.2578644069 (2578644069), RBA 3712786960.

GGSCI (ex02db02.iris.cl.sh.cos) 7> 

 分析抽取进程停不下来的原因：

GGSCI (ex02db02.iris.cl.sh.cos) 7> info extu6, showch      ---查看抽取进程extu6的具体信息

EXTRACT    EXTU6     Last Started 2016-03-30 12:22   Status RUNNING
Checkpoint Lag       00:00:01 (updated 00:00:06 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2016-04-09 07:13:53  Thread 1, Seqno 2164, RBA 1977981456        ------日志1，当前的节点
                     SCN 0.2578649132 (2578649132)
Log Read Checkpoint  Oracle Redo Logs
                     2016-04-09 07:13:52  Thread 2, Seqno 3767, RBA 3712910848        ------日志2，当前的节点
                     SCN 0.2578648996 (2578648996)


Current Checkpoint Detail:

Read Checkpoint #1

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 1
    Sequence #: 1438
    RBA: 210499600
    Timestamp: 2016-03-30 12:22:03.000000
    SCN: 0.1566106138 (1566106138)
    Redo File: Not Available

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 1
    Sequence #: 2010
    RBA: 2150464016
    Timestamp: 2016-04-07 10:40:45.000000
    SCN: 0.2340216775 (2340216775)
    Redo File: Not Available

  Current Checkpoint (position of last record read in the data source):      -----停止抽取进程的时候，发现Redo Thread 1, Redo Log Sequence Number 2010, SCN 0.2340216775 (2340216775), RBA 2150464016指向了一个比较老的日志点。而当前的日志点在2016-04-09 07:13:53  Thread 1, Seqno 2164, RBA 1977981456，SCN 0.2578649132 (2578649132)    ------日志1，当前的节点
    Thread #: 1
    Sequence #: 2164
    RBA: 1977981456
    Timestamp: 2016-04-09 07:13:53.000000
    SCN: 0.2578649132 (2578649132)
    Redo File: +RECO_EX01/oraods/onlinelog/group_3.260.906566199

  BR Previous Recovery Checkpoint:
    Thread #: 1
    Sequence #: 0
    RBA: 0
    Timestamp: 2016-03-30 12:22:40.228062
    SCN: Not available
    Redo File: 

  BR Begin Recovery Checkpoint:
    Thread #: 1
    Sequence #: 2158
    RBA: 601906176
    Timestamp: 2016-04-09 04:28:28.000000
    SCN: 0.2568814282 (2568814282)
    Redo File: 

  BR End Recovery Checkpoint:
    Thread #: 1
    Sequence #: 2158
    RBA: 601906176
    Timestamp: 2016-04-09 04:28:28.000000
    SCN: 0.2568814282 (2568814282)
    Redo File: 

Read Checkpoint #2

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 2
    Sequence #: 2538
    RBA: 2046847504
    Timestamp: 2016-03-30 12:21:23.000000
    SCN: 0.1566051805 (1566051805)
    Redo File: Not Available

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 2
    Sequence #: 3767
    RBA: 3712910352
    Timestamp: 2016-04-09 07:13:52.000000
    SCN: 0.2578648996 (2578648996)
    Redo File: +RECO_EX01/oraods/onlinelog/group_7.423.906566119

  Current Checkpoint (position of last record read in the data source):       ---可以看出日志组2，没有什么问题，是指向当前的日志组的。
    Thread #: 2
    Sequence #: 3767
    RBA: 3712910848
    Timestamp: 2016-04-09 07:13:52.000000
    SCN: 0.2578648996 (2578648996)
    Redo File: +RECO_EX01/oraods/onlinelog/group_7.423.906566119

  BR Previous Recovery Checkpoint:
    Thread #: 2
    Sequence #: 0
    RBA: 0
    Timestamp: 2016-03-30 12:22:40.228062
    SCN: Not available
    Redo File: 

  BR Begin Recovery Checkpoint:
    Thread #: 2
    Sequence #: 3753
    RBA: 3358690304
    Timestamp: 2016-04-09 04:28:27.000000
    SCN: 0.2568813956 (2568813956)
    Redo File: 

  BR End Recovery Checkpoint:
    Thread #: 2
    Sequence #: 3753
    RBA: 3358690304
    Timestamp: 2016-04-09 04:28:27.000000
    SCN: 0.2568813956 (2568813956)
    Redo File: 

Write Checkpoint #1

  GGS Log Trail

  Current Checkpoint (current write position):
    Sequence #: 212216
    RBA: 11597034
    Timestamp: 2016-04-09 07:13:54.176777
    Extract Trail: /home/gggate/goldengate/dirdat/e6
    Trail Type: EXTTRAIL

Header:
  Version = 2
  Record Source = A
  Type = 11
  # Input Checkpoints = 2
  # Output Checkpoints = 1

File Information:
  Block Size = 2048
  Max Blocks = 100
  Record Length = 4096
  Current Offset = 0

Configuration:
  Data Source = 3
  Transaction Integrity = 1
  Task Type = 0

Status:
  Start Time = 2016-03-30 12:22:40
  Last Update Time = 2016-04-09 07:13:54
  Stop Status = A
  Last Result = 0



GGSCI (ex02db02.iris.cl.sh.cos) 8> 

 处理方法：将抽取进程，修改到当前的日志组，然后再进行停止抽取进程。

通过ggsci>help alter extract -----查看帮助

ALTER EXTRACT extu6, IOEXTSEQNO 2164, IOEXTRBA 0,thread 1