Tag: send extract EXtDB

How to Skip Long Running Transaction in Oracle Goldengate using SKIPTRANS

We always see the similar WARNING in ggserr.log:

2024-07-14T20:33:15.697+1000  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, EXTDB.prm:  Long Running Transaction: XID 3708191792.181.17.473582, Items 0, Extract EXTDB, Redo Thread 2, SCN 1447.4108855138 (6218926532450), Redo Seq #38608, Redo RBA 88457232.

Check the transaction in GGSCI:

GGSCI  > send extract EXTDB, showtrans

OR show transactions lasting for more than 1200 minutes already.

GGSCI >  send extract EXTDB, showtrans duration 1200 MIN TABULAR

Check the transaction in database:

SQL> select INST_ID,ADDR,XIDUSN,XIDSLOT,XIDSQN,STATUS,START_TIME,START_DATE from  gv$transaction where XIDUSN=181 and XIDSLOT=17 and XIDSQN=473582;

   INST_ID ADDR                 XIDUSN    XIDSLOT     XIDSQN STATUS           START_TIME           START_DATE
---------- ---------------- ---------- ---------- ---------- ---------------- -------------------- --------------------
         2 000000021236DA28        181         17     473582 ACTIVE           07/05/24 18:37:56    07-May-2024 18:37:59

Skip the transaction:

GGSCI > send extract EXTDB,skiptrans 3708191792.181.17.473582

Sending SKIPTRANS request to EXTRACT EXTDB ...
Are you sure you sure you want to skip transaction XID 3708191792.181.17.473582, Redo Thread 2, Start Time 2024-05-07:18:37:56, SCN 1447.4108855138 (6218926532450)? (y/n)y

Sending SKIPTRANS request to EXTRACT EXTDB ...
Skiptrans operation successfully processed. Transaction XID 3708191792.181.17.473582, Redo Thread 2, Start Time 2024-05-07:18:37:56, SCN 1447.4108855138 (6218926532450) skipped