FILTERDUPTRANSACTIONS Parameter Does Not Work (Doc ID 2202064.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle GoldenGate - Version 11.2.1.0.3 to 12.1.2.1.8 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

FILTERDUPTRANSACTIONS causes Replicat to ignore transactions that it has already processed.
Use when Extract was repositioned to a new start point (see the ATCSN or AFTERCSN option of "START EXTRACT") and you are confident that there are duplicate transactions in the trail that could cause Replicat to abend.

But with FILTERDUPTRANSACTIONS, Replicat does not ignore transactions that it has already processed.

Changes

FILTERDUPTRANSACTIONS Parameter is introduced on OGG 11.2.1.0.3.
And on OGG 11.2.1.0.x, "_csnfiltering on" is also required to use FILTERDUPTRANSACTIONS.
On OGG 12.1.2 or above, "_csnfiltering on" is default, and you do not have to "_csnfiltering on" for FILTERDUPTRANSACTIONS.

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