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)