Oracle Cloud Infrastructure Documentation

Migration type

Select the type of migration, offline or online.

Note

Note:

For online migrations

  • To prevent Foreign Key constraint violation, all foreign keys are automatically disabled and then re-enabled before the switchover.

  • Any DDL performed on these constraints during this period are not supported and will lead to failures in GoldenGate replication. This DDL limitation only applies during Data Pump Export.

  • If DDLs on the disabled constraints are expected to happen during Data Pump Export then an Online migration with Snapshot Standby database is recommended.

  • Performing the initial load from a Snapshot Standby (static environment) ensures a consistent dataset on the target, and all DDL changes will be captured by GoldenGate and applied to the target.

  • Offline migration
    When using the offline migration method, you must stop updates to the source database before you start a migration.

  • Online migration
    An online migration enables you to perform database migration without any downtime of your source database.