FILTERDUPTRANSACTIONS Parameter Does Not Work
Last updated on NOVEMBER 17, 2016
Applies to:Oracle GoldenGate - Version 220.127.116.11.3 to 18.104.22.168.8 [Release 11.2 to 12.1]
Information in this document applies to any platform.
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.
FILTERDUPTRANSACTIONS Parameter is introduced on OGG 22.214.171.124.3.
And on OGG 126.96.36.199.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.
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