My Oracle Support Banner

Oracle GoldenGate for SQL Server - Classic Extract Supplemental Logging and Truncation Point Management (Doc ID 1315856.1)

Last updated on FEBRUARY 13, 2020

Applies to:

Microsoft SQLServer
Oracle GoldenGate - Version to [Release 11.2 to 12.3]
Generic Windows
Microsoft SQL Server 2008/2008 R2
Microsoft SQL Server 2012
Microsoft SQL Server 2014


This knowledge document describes using Oracle GoldenGate to enable and disable supplemental logging (ADD/DELETE TRANDATA) and TRANLOGOPTIONS with MANAGESECONDARYTRUNCATIONPOINT, ACTIVESECONDARYTRUNCATIONPOINT, or NOMANAGESECONDARYTRUNCATIONPOINT for an Extract capturing from SQL Server 2008/2008R2, SQL Server 2012, or SQL Server 2014.

An overview of the architecture is followed by a description of the installation and configuration procedure.

This document touches briefly on many important and complex concepts and does not provide a detailed explanation of any one topic since the intent is to present the material in the most expedient manner. The goal is simply to help the reader become familiar enough with the product to successfully design and implement an Oracle GoldenGate environment. To that end, it is important to note that the activities of design, unit testing and integration testing which are crucial to a successful implementation have been intentionally left out of the guide. All the sample scripts are provided as is. Oracle consulting service is highly recommended for any customized implementation.




To view full details, 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 a vibrant support community of peers and Oracle experts.