Checking Whether Supplemental Logging of the Source Oracle Database Meets Requirements

Whether supplemental logging of the source Oracle database meets requirements

The supplemental logging of the source Oracle database must meet requirements. Otherwise, the migration or synchronization fails.

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 supplemental logging at the database level: alter database add supplemental log data (all) columns
• Enable primary key and unique key supplemental logging: alter database add supplemental log data (primary key,unique) columns
• Enable minimal supplemental logging: alter database add supplemental log data; then run the following command to enable all, primary key, or unique key supplemental logging at the table level for each to-be-synchronized table: alter table TABLE_NAME add supplemental log data(all) columns