Sometimes GoldenGate EXTRACT capture long transactions from database and could be some B.O.F.H making DUMMY, if it’s the case, it’s a ‘UNWANTED’ transaction, and can skip it on ggsci:
(GUARANTEED DATA LOSS – db transaction skipped)
GGSCI (cloud-db) 60> send ext2 showtrans Sending SHOWTRANS request to EXTRACT EXT2 ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 20322, SCN 1661.3085726936 (7137026405592), RBA 597023248 ------------------------------------------------------------ XID: 2049.13.3951869 Items: 1 Extract: EXT2 Redo Thread: 1 Start Time: 2016-11-07:15:22:07 SCN: 1661.3085726936 (7137026405592) Redo Seq: 20322 Redo RBA: 597023248 Status: Running ------------------------------------------------------------
GGSCI (cloud-db) 62> send ext2 SKIPTRANS 2049.13.3951869 THREAD 1 Sending SKIPTRANS request to EXTRACT EXT2 ... Are you sure you sure you want to skip transaction [XID 2049.13.3951869, Redo Thread 1, Start Time 2016-11-07:15:22:07, SCN 1661.3085726936 (7137026405592)]? (y/n)y Sending SKIPTRANS request to EXTRACT EXT2 ... Transaction [XID 2049.13.3951869, Redo Thread 1, Start Time 2016-11-07:15:22:07, SCN 1661.3085726936 (7137026405592)] skipped.
Check your applications and kill it in the database 🙂
Maiquel.