今天查看想要关闭一个OGG 进程报出：
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 GGEX, FORCESTOP command.
Oldest redo log file necessary to restart Extract is:
Redo Log Sequence Number 104, RBA 44632080.
查看ggserr.log
2014-07-10 19:36:20  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ggex.prm:  Long Running Transaction: XID 9.3.1688, Items 0, Extract GGEX, Redo Thread 1, SCN 0.2925613 (2925613), Redo Seq #104, Redo RBA 44632080.
2014-07-10 20:06:20  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ggex.prm:  Long Running Transaction: XID 9.3.1688, Items 0, Extract GGEX, Redo Thread 1, SCN 0.2925613 (2925613), Redo Seq #104, Redo RBA 44632080.
2014-07-10 20:07:11  INFO    OGG-01738  Oracle GoldenGate Capture for Oracle, ggex.prm:  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p52103_extr: start=SeqNo: 104, RBA: 49890320, SCN: 0.2925683 (2925683), Timestamp: 2014-07-06 22:05:18.000000, Thread: 1, end=SeqNo: 104, RBA: 50181632, SCN: 0.2925683 (2925683), Timestamp: 2014-07-06 22:05:18.000000, Thread: 1.
2014-07-10 20:36:21  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ggex.prm:  Long Running Transaction: XID 9.3.1688, Items 0, Extract GGEX, Redo Thread 1, SCN 0.2925613 (2925613), Redo Seq #104, Redo RBA 44632080.
2014-07-10 21:06:21  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ggex.prm:  Long Running Transaction: XID 9.3.1688, Items 0, Extract GGEX, Redo Thread 1, SCN 0.2925613 (2925613), Redo Seq #104, Redo RBA 44632080.
2014-07-10 21:36:22  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ggex.prm:  Long Running Transaction: XID 9.3.1688, Items 0, Extract GGEX, Redo Thread 1, SCN 0.2925613 (2925613), Redo Seq #104, Redo RBA 44632080.
2014-07-10 22:06:22  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ggex.prm:  Long Running Transaction: XID 9.3.1688, Items 0, Extract GGEX, Redo Thread 1, SCN 0.2925613 (2925613), Redo Seq #104, Redo RBA 44632080.
2014-07-10 22:36:22  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ggex.prm:  Long Running Transaction: XID 9.3.1688, Items 0, Extract GGEX, Redo Thread 1, SCN 0.2925613 (2925613), Redo Seq #104, Redo RBA 44632080.
2014-07-10 23:06:23  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ggex.prm:  Long Running Transaction: XID 9.3.1688, Items 0, Extract GGEX, Redo Thread 1, SCN 0.2925613 (2925613), Redo Seq #104, Redo RBA 44632080.
2014-07-10 23:36:24  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ggex.prm:  Long Running Transaction: XID 9.3.1688, Items 0, Extract GGEX, Redo Thread 1, SCN 0.2925613 (2925613), Redo Seq #104, Redo RBA 44632080.
-----------------------------------------------------------------------------------------------------------------------
怎么会有长事物呢?  我自己的实验平台一直没有业务跑，怎么还有长事物呢？
于是想到是不是 数据库flash_recover 区满了导致 数据库的事物提交不了，造成数据库错误 。
在源端查看select * from v$flash_recovery_area_usage;
SQL> select * from v$flash_recovery_area_usage;


FILE_TYPE     PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE      0 0 0
REDO LOG      0 0 0
ARCHIVED LOG     99.8 0 97
BACKUP PIECE      0 0 0
IMAGE COPY      0 0 0
FLASHBACK LOG      0 0 0
FOREIGN ARCHIVED LOG      0 0 0
果然是，进入RMAN 删除
delete archivelog all completed before 'sysdate-2';

然后去关闭 stop er *
报错消失。

-------------------------------------------------------------
如果你是生产系统 你最好 查处是那些事物在跑，用下面的语句查出来。