My Oracle Support Banner

Effects of ADD TRANDATA and ADD SCHEMATRANDATA on an Oracle databases' Supplemental Logging (Doc ID 2070331.1)

Last updated on JUNE 13, 2023

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 to 12.1.3.0.0 [Release 11.1.1 to 12.1]
Oracle Database - Enterprise Edition - Version 8.1.7.0 to 12.1.0.2 [Release 8.1.7 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

The purpose of this document is to demonstrate the effects of the GoldenGate GGSCI commands;

on the levels of Supplemental Logging on a table in an Oracle database, as stored in the Oracle database views;

Troubleshooting Steps

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
Troubleshooting Steps
 PREAMBLE
 DataGuard Logical Standby Supplemental Logging
 SUMMARY OF RESULTS
 Supplemental Logging (Minimum) at the Oracle database level
 ADD TRANDATA
 ADD TRANDATA ... ALLCOLS
 ADD SCHEMATRANDATA
 TEST CASE DETAILS
 SCOTT.EMP create table statement
 SCOTT.EMP Rows
 Preparing the Oracle database
 Preparing the GoldenGate EXTRACT
 Oracle database LogMiner Utility commands
 GoldenGate LogDump Utility commands
 Test #1: Oracle database Minimal Supplemental Logging
 Test #2: ADD TRANDATA
 Test #3: ADD TRANDATA ... ALLCOLS
 Test #4: ADD SCHEMATRANDATA
 Restore SCOTT.EMP
References

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