Checking Whether Supplemental Logging Is Correctly Enabled on the Source Database

Checking whether supplemental logging is correctly enabled on the source database

The supplemental logging level of the source Oracle database does not meet requirements. The synchronization fails.

Failure cause: A supplemental logging alarm for the source database is generated. Enabling primary key or unique key logging at the database level for the source database may lead to the loss of column data when data is updated.

Handling suggestion: Enable all supplemental logging at the database or table level.

• Statement for enabling all supplemental logging:

  alter database add supplemental log data (all) columns;

• Statement for viewing all supplemental logging:

  select supplemental_log_data_all as allLog from v$database;