Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Configuration Items/ Checking Whether Supplemental Logging Is Correctly Enabled on the Source Database
Updated on 2022-11-10 GMT+08:00
View PDF
Share

Checking Whether Supplemental Logging Is Correctly Enabled on the Source Database

Oracle Serving as the Source in Synchronization

Table 1 Checking whether supplemental logging is correctly enabled on the source database

Check Item

Checking whether supplemental logging is correctly enabled on the source database

Description

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

Failure Cause and Handling Suggestion

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;