Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Supplemental Log Level of the Source Database Meets Requirements
Updated on 2022-09-21 GMT+08:00

Checking Whether the Supplemental Log Level of the Source Database Meets Requirements

Oracle Synchronization

Table 1 Checking whether the supplemental log level of the source database meets requirements

Check Item

Whether the supplemental log level of the source database meets requirements

Description

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

Failure Cause and Handling Suggestion

Failure cause: The supplemental logging level of the source Oracle database does not meet requirements.

Handling suggestion: Perform any of the following operations in the source database:

  • Enable all-level (database-level) supplemental logging: alter database add supplemental log data (all) columns
  • Enable minimal-level supplemental logging: alter database add supplemental log data. Then run the following command to enable all-level (table-level) supplemental logging for each to-be-synchronized table: alter table TABLE_NAME add supplemental log data(all) columns