Migrating On-Premises Oracle Database to Oracle Cloud service Methods

Description:-

  • In this article we are going to see Migrating On-Premises Oracle Database to Oracle Cloud service Methods.
  • We can migrate our on-premises Oracle Database to an Oracle Database Cloud database using different methods and tools

There are four possible scenarios covered officially by oracle documentation

  1. Migrating from Oracle Database 11g to Oracle Database 11g in the Cloud.
  2. Migrating from Oracle Database 11g to Oracle Database 12c in the Cloud.
  3. Migrating from Oracle Database 12c CDB to Oracle Database 12c in the Cloud.
  4. Migrating from Oracle Database 12c Non-CDB to Oracle Database 12c in the Cloud.

Options for Migrating Databases to Cloud

1.Logical Migration: allows reorganization and optimization
–Data Pump, GoldenGateReplication
2.Physical Migration: simplest, byte-to-byte copy
–RMAN backup, Transportable technologies, Data Guard
–Restore from backup on Oracle Public Cloud
3.Data Movement Options:
–Use public internet
–Private high bandwidth virtual

To determine which migration methods are applicable to your migration scenario, See the below some methods

Migrate Using Backup/Restore

Migrate Using Data Guard

Migrate Using Pluggable Databases Method-1: Unplug/Plug

Migrate Using Pluggable Databases Method-2: Remote Cloning

Migrate Using Pluggable Databases Method-3: Clone a Non-CDB

Upgrade/Migrate Using Data Pump

Upgrade/Migrate Using Full Transportable Export/Import

Upgrade/Migrate Using GoldenGate Cloud Service

 

Catch Me On:- Hariprasath Rajaram

LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter:  https://twitter.com/hariprasathdba