Skip to main content

Oracle to OceanBase Oracle Migration in Stages | NineData

An Oracle to OceanBase Oracle migration must account for schema differences, business continuity, data consistency, and cutover risk. NineData organizes schema replication, full replication, incremental replication, and data comparison in one replication workflow to prepare the target and continue catching up with the source.

When to use this workflow​

  • Replace an Oracle core business system with OceanBase Oracle as part of a database localization project.
  • Prepare an OceanBase Oracle environment during application changes, testing, or migration rehearsals.
  • Validate the target with task status and data comparison before cutover.

Migration workflow​

  1. Schema replication: Select the databases, tables, and columns to migrate, and copy their structure to OceanBase Oracle.
  2. Full replication: Initialize existing Oracle data on the target. Evaluate read and write resources on both sides and schedule the operation during off-peak hours when possible.
  3. Incremental replication: After full replication finishes, continue synchronizing inserts, updates, and deletes to create time for application validation and cutover preparation.
  4. Data comparison: After the target catches up, compare critical objects and locate remaining inconsistent objects or records.

Before you begin​

  • The Oracle source is 23ai, 21c, 19c, 18c, 12c, or 11g.
  • Add the Oracle source and OceanBase Oracle target to NineData, and confirm network connectivity.
  • Grant the permissions required for the selected replication type. See Oracle to OceanBase Oracle.
  • For incremental replication, set the Oracle source to ARCHIVELOG mode and enable supplemental logging.
  • Make sure replicated tables have a primary key or unique constraint and unique column names. Use the precheck to confirm target object, data, and type compatibility.
  • Prepare business validation, backup, rollback, and cleanup plans for the cutover.

Create the replication task​

  1. Add the Oracle and OceanBase Oracle data sources to NineData.
  2. Create a Data Replication task, select the source and target, and choose schema, full, and incremental replication for the migration stages.
  3. Select the migration scope and configure object and field mappings.
  4. Save the task and run the precheck. Resolve connection, permission, log, and object compatibility issues.
  5. Start the task and monitor its status. After the target catches up, run data comparison and complete business validation before cutover.
caution

Task completion does not mean that the business has switched to the target. In an authorized environment, complete data comparison, application validation, backup, and rollback checks, then perform the final cutover during an appropriate business window.