Skip to Main Content

Search

  • Database Size

Instructions and More Information

Select the characteristics of the source database, target service and requirements for the migration to identify available migration methods.

Key decision points include:

Migration Mode

  • Offline migration

    • Applications are offline during migration
    • Duplicates entire database in one operation
  • Online migration

    • Applications are online during migration
    • Captures incremental source database changes in real time and continuously applies them to the target database

Migration Type

  • Logical migration

    • Captures source data and metadata separately from physical data using Oracle Data Pump and OCI GoldenGate
    • Enables source and target databases to be different versions and platforms
  • Physical migration

    • Captures source data and metadata using Recovery Manager and (optionally) ongoing changes with Oracle Data Guard
    • Source and target databases must be the same version and platform types

Migration options are divided into Automated and Manual methods. Automated methods require configuration and are best suited for

  • migration projects involving more than ten databases

  • users who are not familiar with OCI operations such as wallet management and cloud registration since these are managed by the methods

Not sure which Oracle Database Management cloud service best suits your use case? Visit the Oracle DB Expert to explore Oracle's offerings and estimate pricing & TCO.

Find further information on Oracle's migration methods and services here

Note: For DB size over 100TB, Oracle recommends the use of Data Transfer Service (DTS) . Not applicable for C@C. See regional availability

(*) DB version Support Schedule (Doc ID 742060.1)

Manual Methods

Migration Method (ordered by Recommendation weight)Technology Used
Data Pump Conventional Export/ImportData Pump
Data Pump Full TransportableData Pump
Data Pump Transportable TablespaceData Pump
RMAN CONVERT Transportable Tablespace with Data PumpRMAN / Data Pump
RMAN Cross-Platform Transportable PDBRMAN
RMAN Cross-Platform Transportable Tablespace Backup SetsRMAN
RMAN DUPLICATE from an Active DatabaseRMAN
RMAN Transportable Tablespace with Data PumpRMAN / Data Pump
Remote Cloning Non-CDBDatabase Link
Remote Cloning a PDBDatabase Link
Replication-based migration - LogicalGoldenGate / Data Pump
Replication-based migration - PhysicalGoldenGate / RMAN
Unplugging/Plugging Non-CDBPlug/Unplug (XML/scp)
Unplugging/Plugging a PDBPlug/Unplug (XML/scp)
SQL Developer and SQL*Loader to Migrate Selected ObjectsSQL Developer using SQL*Loader