Data replication
During the Oracle Cloud Infrastructure Database Migration service migration job work flow replication phase, all data and metadata operations in transactions committed after the initial load are replicated until you resume the migration job after the Monitor Replication Lag phase.
During the migration job it is recommended that your database avoid Data Definition Language (DDL) operations to provide the most optimal environment for fast database replication. When DDL is replicated, Oracle GoldenGate Replicat serializes data to ensure that there are no locking issues between DML and DDL on the same objects.
By default, the Oracle Cloud Infrastructure Database Migration service configures GoldenGate to replicate all DDL operations on the source database to the target database.
Note
DDL is applicable only for Oracle migrations.
DDL is applicable only for Oracle migrations.
The following objects are not supported:
- Changes to external tables
- Oracle GoldenGate Unsupported Types (see Understanding What’s Supported)
Parent topic: Plan