My Oracle Support Banner

MAA Practices for Cloud Migration Using ZDM (Doc ID 2562063.1)

Last updated on FEBRUARY 10, 2020

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Linux x86-64 on Oracle Public Cloud
Linux x86-64
Zero Downtime Migration is compliant with Oracle Maximum Availability Architecture (MAA) and supports Oracle Database 11g Release 2 (11.2.0.4) and later database releases.


Goal

Zero Downtime Migration (ZDM) is new cloud service that enables database migration from on-premise database to cloud database target with minimal downtime. MAA has been collaborating with ZDM development to create a set of practices that will complement the ZDM service.

The ZDM and MAA solution currently supports a low downtime physical migration of entire database using RMAN backup and restore and Data Guard. ZDM ensures that you have an cloud ready database at the end.

In the future, ZDM will support a zero downtime logical migration solution. This note will be updated with future practices.

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
 Customer Actionable Prerequisites
 Prerequisites
 Cloud Migration Use Cases
 High Level Steps
 ZDM Migration Steps
 Step 1 - Prerequisites
 Step 1.1 - Configuring Connectivity
 Step 1.2 – Evaluate the database migration process
 Step 2 - Backup to Cloud Backup Target
 Step 3 – Run ZDM 
 Step 3.1 - Instantiate the Cloud Database
 Step 3.2 - Convert the Standby Database to TDE (if required)
 Step 3.3 - Enable Active Data Guard (optional)
 Step 3.4 - Monitoring Data Guard Configuration Health
 Step 3.5 - Test the Cloud Database (optional)
 Step 4 – Switchover to the Cloud Database
 Step 5 - Zero Data Loss Fallback (if required)
 Step 6 - Manifest to Cloud and Housekeeping
 Post Migration Checks
 Remove the Data Guard Configuration from Primary Database (optional)
 Use the dbaascli Utility to check the Cloud database
 Run Datapatch on the Target Database
 Conclusion
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.