Choose a Migration Solution

Use the information you gathered about the source database to choose an appropriate migration method.

This decision tree can help you choose the appropriate migration solution for your database.

Description of db_migration_flowchart.png follows
Description of the illustration db_migration_flowchart.png

The following table can help you decide on a migration strategy based on the source database characteristics.

Oracle Solution Requirements

Oracle GoldenGate

Downtime must be kept to an absolute minimum.

Source database and target database must be running on Oracle GoldenGate compatible platforms.

Oracle Data Guard

Source database can be Oracle Database 18c, Oracle Database 12c, or Oracle Database 11g Release,

Source database and target database must be running on Oracle Data Guard compatible platforms.

Oracle Recovery Manager (RMAN)

The database is a non- container database (CDB), which does not use the Oracle multitenant architecture.

The database host platform uses little-endian byte ordering. Query V$TRANSPORTABLE_PLATFORM to view the byte ordering for different platforms.

Oracle Database Backup Cloud Service

Oracle Database 18c, Oracle Database 12c Release,, or Oracle Database 11g Release with the latest PSU (patch set update) applied.

If the database is at version or later, it must be multitenant (CDB).

Source database uses File System or Oracle Automatic Storage Management (Oracle ASM) as its storage method for data files.