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

Checking Whether Supplemental Logging of the Source Oracle Database Meets Requirements

Oracle -> MySQL/Oracle -> PostgreSQL/Oracle -> GaussDB(for MySQL)/Oracle -> GaussDB Migration and Synchronization

Table 1 Checking whether supplemental logging of the source oracle database meets requirements

Check Item

Whether supplemental logging of the source Oracle database meets requirements

Description

The supplemental logging of the source Oracle database must meet requirements. Otherwise, the migration or 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 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