MANAGESECONDARYTRUNCATIONPOINT param for 2 databases which begin with the same 1st letter will only work for 1 database (Doc ID 2229373.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 to 12.2.0.1.0 [Release 11.2 to 12.2]
Microsoft Windows x64 (64-bit)

Symptoms

Using GG version 12.2.1.0 for SQL Server, running on a version 2012 R2 windows 64 bit platform

when using param TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT for 2 databases which begin with the same 1st letter
sp_repldone will only be run for 1 of the databases. The logs, which have been captured, for the other database will not be shrunk via Golden Gate.
The stored procedure sp_repldone must be manually executed to shrink the logs.

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