Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Whether the Supplemental Log Level in the Source Database Is Correct
Updated on 2024-11-30 GMT+08:00

Whether the Supplemental Log Level in the Source Database Is Correct

During a data synchronization with Oracle serving as the source database, if all data is required for the synchronization object, all-level supplemental logging must be enabled.

Failure Cause

All data is required for the synchronization object, but all-level supplemental logging is not enabled.

Handling Suggestion

Enable all-level supplemental logging.

Commands for enabling all-level supplemental logging:

Database level: alter database add supplemental log data (all) columns

Table level: alter table Schema_name.Table_name add supplemental log data(all) columns