Oracle Goldengate Tutorial - Beginner (Level 4)

Configuring Database Logging Properties

• Oracle Goldengate relies on the redo logs to capture the data it needs to replicate source transactions.
• The Oracle redo log on the source system must be configured properly before you start Oracle GoldenGate Processing.

There are 3 Database Logging Levels that applies to GoldenGate.

1. Enabling Minimum Database-level Supplemental Logging

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL> ALTER DATABASE FORCE LOGGING;

SELECT supplemental_log_data_min, force_logging FROM v$database;

2. Enabling Schema-Level Supplemental Logging

GGSCI> DBLOGIN USERIDALIAS alias

GGSCI> ADD SCHEMATRANDATA hr

3. Enabling Table-Level supplemental Logging

GGSCI> DBLOGIN USERIDALIAS alias

GGSCI> ADD TRANDATA [container.]schema.table