goldengate一直报长事务告警，但是对应的2阶段事务在数据库...
下面是对应的日志，一直在报，重启了goldengate进程还是不行2014-03-26 13:29:52GGS WARNING 190Oracle GoldenGate Capture for Oracle, extjs.prm:Long Running Transaction: XID 221.15.490447, Items 0, Extract EXTJS, Redo Thread 2, SCN 3194.4291719562 (13722417262986), Redo Seq #48916, Redo RBA 139516944.
2014-03-26 13:32:12GGS INFO 226Oracle GoldenGate Manager for Oracle, mgr.prm:Purged old extract file /gdfs01/goldengate/dirdat/js089721, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 89824 > 89721.
2014-03-26 13:32:54GGS WARNING 190Oracle GoldenGate Capture for Oracle, extjs.prm:Long Running Transaction: XID 221.15.490447, Items 0, Extract EXTJS, Redo Thread 2, SCN 3194.4291719562 (13722417262986), Redo Seq #48916, Redo RBA 139516944
SQL> select * from x$ktuxe t wheret.ktuxeusn=221 and ktuxeslt=15;
ADDR INDX INST_ID KTUXEUSN KTUXESLT KTUXESQNKTUXERDBFKTUXERDBBKTUXESCNBKTUXESCNW KTUXESTA KTUXECFL KTUXEUELKTUXEDDBFKTUXEDDBBKTUXEPUSNKTUXEPSLTKTUXEPSQN KTUXESIZ
---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- ------------------------ ---------- ---------- ---------- ---------- ---------- ---------- ----------
9FFFFFFF7FB0AD80 15 1 221 15 490447 0 0 1409127420 3195 INACTIVE
这个事务之前被手动强制回滚掉了 这里设计到goldengate的Extract进程的恢复原理,你可以看 BR 这个参数的里的解释，既然这个事务你已rollback，可以用SKIPTRANS来跳过事务
页:
[1]