Send Extract Showtrans Displays Wrong Thread Number of Redo in Integrated Capture Mode (Doc ID 1493770.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 and later
Information in this document applies to any platform.

Symptoms

GGSCI (host) 31> send etest showtrans count 10

Sending showtrans request to EXTRACT ETEST ...

------------------------------------------------------------
XID: 8898.17.12679
Items: 1
Extract: ETEST
Redo Thread: 0 <==== wrong thread #
Start Time: 2012-07-02:11:56:42
SCN: 2.722045391 (9311979983)
Redo Seq: 964
Redo RBA: 147984
Status: Running


SQL> select thread#, instance from v$thread where instance =
(select instance_name from v$instance);

THREAD#
----------

2

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms