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 2024-09-25 GMT+08:00
View PDF
Share

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

During an incremental synchronization with Oracle serving as the source database, DRS checks whether the source database has the supplemental logging level permission. The supplemental logging level of the source Oracle database does not meet requirements. The synchronization fails.

Failure Cause

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

Handling Suggestion

In the source database, perform either of the following operations:

  • Enable all-level (database-level) supplemental logging: alter database add supplemental log data (all) columns
  • Enable minimal-level supplemental logging in the source Oracle database: 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
Parent topic: Database Parameters