My Oracle Support Banner

GoldenGate LOGRETENTION (Doc ID 1465847.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 to 12.1.3.0.0 [Release 11.1.1 to 12.1]
Information in this document applies to any platform.

Purpose

This note introduces the LOGRETENTION option for the REGISTER/UNREGISTER EXTRACT and TRANLOGOPTIONS parameters.

Scope

The LOGRETENTION option was introduced in GoldenGate 11g Release 1 Patch Set 1 (version 11.1.1.1), and is only available for Oracle databases version 10.2 and above.

It only applies to a Classic EXTRACT.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Overview
 Prerequisites
 Oracle EE version 10.2
 Oracle EE version 11.1 and 11.2.0.1
 Oracle EE version 11.2.0.3 and later
 TRANLOGOPTIONS LOGRETENTION ENABLED
 Recommendations
 Known Issues
 EXTRACT seems to hang
 EXTRACT reports OGG-00665, ORA-21780 error
 Adding an EXTRACT gets WARNING OGG-01752
 Effects on the Oracle Database
 Multiple entries in DBA_CAPTURE or SYSTEM.LOGMNR_SESSION$
 Disabling LOGRETENTION
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.