今天查看想要关闭一个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.p
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.p