OGG Classic Extract Incorrectly Misses Data When Using TRANLOGOPTIONS EXCLUDETAG And Redo Has NULL Tag

(Doc ID 2317831.1)

Last updated on OCTOBER 20, 2017

Applies to:

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

Symptoms

Version 12.2.0.1.160517 OGGCORE_12.2.0.1.160517_PLATFORMS_RELEASE_FBO
Solaris, sparc, 64bit (optimized), Oracle 11g on Aug 25 2016 21:22:43

Here is a test case to explain the issue


Say Extract has TRANLOGOPTIONS EXCLUDETAG aaaa


On source database:
set transaction read write;
exec dbms_xstream_gg_adm.set_tag('aaaa');
-- Run some DMLs and this will be excluded correctly
exec dbms_xstream_gg_adm.set_tag(null);
-- Run some DMLs and this should be captured however Extract would exclude it

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