Learn About Migrating with Oracle GoldenGate

You can use Oracle GoldenGate to move a database from one platform to another with minimal downtime.

Oracle GoldenGate logical replication enables all databases in an Oracle GoldenGate configuration, both the source database and the target database, to be open read-write. Oracle GoldenGate is a key component of Oracle’s Massive Availability Architecture for addressing a broad range of high availability challenges for zero downtime maintenance, cross platform migration, and continuous data availability.

Oracle GoldenGate provides:

  • Zero or near-zero downtime migrations when an Oracle Data Guard solution is not applicable.

  • Platform or database migrations can be carried out using Oracle GoldenGate as the data synchronization method between the old and new systems.

  • After the database is instantiated on another host, Oracle GoldenGate is configured to replicate changes from the production database.

  • A guaranteed restore point can be created on the migrated database, so that after user testing the database can be flashed back. Oracle GoldenGate can apply any outstanding data changes from the production database before moving the application users to the new database, similar to a snapshot standby database.

  • Bi-directional replication can be configured from the migrated database back to the production database for use as a fallback solution.

Consider the following information when you decide whether Oracle GoldenGate is an appropriate method for performing a platform migration:
  • Oracle GoldenGate data type and database option support varies by database version. For a complete list of what is supported, see the Oracle GoldenGate documentation.

  • Extra administrative effort may be required to set up and maintain the Oracle GoldenGate environment.

  • Downtime that is required for a platform migration when using Oracle GoldenGate is determined by the time that is needed to apply the remaining transactions in the queue and to reconnect clients to the new database.