Oracle Database Migration/Upgrade to Cloud or Non-Cloud environment with reduced downtime leveraging Oracle Data Guard

(Doc ID 2326901.1)

Last updated on APRIL 11, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Linux x86-64
The steps pertain to Oracle Database 11gr2 11.2.0.4 and later.

Goal

The steps provided in this document will assist with migration from an existing environment consisting of non-CDB databases to an Exadata cloud based environment with optional conversion to Oracle multitenant architecture in a manner providing limited downtime and easy fallback should issues arise during the plug in operation. Included in the steps is the ability to optionally incorporate Oracle Transparent Data Encryption prior to plug in to the destination container database (CDB). The defined process is supported for 11.2.0.4 and later databases.

This MOS document is in its first design phase (“Concept”) and we expect to continue to modify it during next phases (“Testing” and “Refinement”). Readers are encouraged to validate the code and samples in a Test environment first before applying them in production however this level of verification is being targeted before full release to customers.  This process has been internally tested directly on Oracle Cloud provisioned hardware and software.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms