适用范围

oracle 11.2及以后

问题概述

1、停止ogg抽取进程失败，发现有几个长事务未提交导致

GGSCI (xxxxx) 2> stop extract demo

Sending STOP request to EXTRACT demo ...

STOP request pending. 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 demo, FORCESTOP command.
Oldest redo log file necessary to restart Extract is:

Redo Log Sequence Number 616, RBA 135673360.

2018-04-12 15:55:41 WARNING OGG-01742 Command sent to EXTRACT demo returned with an invalid response.