Chapter 04 : Setting up database (Logging Levels)

 Configuring Database Logging Properties

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

Transaction logging can be enabled at 3 Logging Levels on the database that is required for Oracle GoldenGate Extract process.

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