Oracle Zero Downtime Migration (ZDM) – Hands-On Guide

Name: Oracle Zero Downtime Migration (ZDM) – Hands-On Guide
Rating: 4.5 (56 reviews)

Learn to migrate Oracle databases to OCI with minimal downtime using ZDM

Created byAhmed Baraka

Last updated 2/2026

English

What you'll learn

Understand the Zero Downtime Migration Workflows
Manage Zero Downtime Migration for migration jobs
Implement Zero Downtime Migration Physical migration
Implement Zero Downtime Logical migration
Troubleshoot Zero Downtime Migration

Course content

12 sections • 57 lectures • 7h 1m total length

Introduction5:34

Practice 1 Preparing Practice Environment ( part 1 of 2 )9:05
Practice 1 Preparing Practice Environment ( part 2 of 2 )4:21
Practice 2 Provisioning a VM DB System ( part 1 of 4 )6:34
Practice provisioning a VM database system for zero downtime migration to the 0C IDB system, including VCN setup, a public subnet, internet gateway, and port 1521 security rules.
Practice 2 Provisioning a VM DB System ( part 2 of 4 )2:05
Create and save a public-private key pair, generate a private key without a passphrase, and save it as a PPK file for use in subsequent connections.
Practice 2 Provisioning a VM DB System ( part 3 of 4 )6:08
Practice 2 Provisioning a VM DB System ( part 4 of 4 )2:36

Setting Up Zero Downtime Migration Software9:42
Practice 3 - Setting Up Zero Downtime Migration Software ( part 1 of 2 )8:34
Practice 3 - Setting Up Zero Downtime Migration Software ( part 2 of 2 )3:02
Configuring ZDM Connectivity ( part 1 of 2 )7:30
Configuring ZDM Connectivity ( part 2 of 2 )8:10
Practice 4 - Configuring ZDM Connectivity8:52
Configure zdm connectivity by enabling ping service, setting up passwordless ssh keys, and updating hosts for reliable host name resolution between the emissary, source, and target databases.

Starting and Managing ZDM Migration Jobs ( part 1 of 4 )6:24
Starting and Managing ZDM Migration Jobs ( part 2 of 4 )8:22
Learn how to start, monitor, and safely evaluate Oracle zero downtime migration jobs using the migrate command, including evaluation mode, essential parameters, and best practices to catch issues before production.
Starting and Managing ZDM Migration Jobs ( part 3 of 4 )12:52
Starting and Managing ZDM Migration Jobs ( part 4 of 4 )4:27
Use the cloud migration advisor tool to verify source feature support, generate remedial scripts, and manage zdm migration jobs, while updating seabed and backing up the source database before cutover.
Troubleshooting ZDM Migration Jobs ( part 1 of 2 )8:06
Troubleshoot ZDM migration jobs by inspecting job logs, ZDM look files on source and target, and data pump logs, then use Oracle Support or service requests as needed.
Troubleshooting ZDM Migration Jobs ( part 2 of 2 )6:26
Providing Passwords Non-Interactively Using Wallets6:22
Learn to run Oracle zero downtime migration non-interactively by creating and using wallet files to store passwords and tokens, then pass these wallets to the migrate command for automation.

Practice 5 - Using ZDM for Physical Online Migrating to OCI ( part 1 of 4 )4:57
Practice 5 - Using ZDM for Physical Online Migrating to OCI ( part 2 of 4 )4:36
Practice 5 - Using ZDM for Physical Online Migrating to OCI ( part 3 of 4 )9:30
Practice 5 shows how to perform a physical online migration to OCI with ZDM, running and monitoring the migration job, and evaluating phases from pre-check to success.
Practice 5 - Using ZDM for Physical Online Migrating to OCI ( part 4 of 4 )6:18
Migrating non-CDB Database to OCI PDB5:33
Practice 6 - Migrating non-CDB Database to OCI PDB ( part 1 of 2 )9:14
Practice demonstrates migrating a non-CDB on-premises database to an OCI PDB using physical online migration, provisioning a VMDB system, configuring passwordless access, and loading data with swing bench.
Practice 6 - Migrating non-CDB Database to OCI PDB ( part 2 of 2 )8:26
Practice 7 - Migrating RAC Database to RAC DB System3:42
Using Existing Incremental Backup7:29
Practice 8 - Using Existing Incremental Backup10:21

Preparing Source and Target Databases for Logical Migration ( part 1 of 2 )5:15
Review the logical migration workflow and prepare source and target databases using Golden Gate hub configurations for online and offline migrations, including backup locations and IDB links.
Preparing Source and Target Databases for Logical Migration ( part 2 of 2 )11:00
Preparing ZDM Response File for Logical Migration5:25
Setting Data Pump Parameters13:44
Managing Tablespaces in Logical Migrations7:27

Requirements

Oracle Database Administration - basics
Linux - basics
A PC with 16 GB RAM and 100 GB free disk space
An active account in the Oracle Cloud Infrastructure (OCI)

Description

Migrating Oracle databases to the cloud with minimal downtime is one of the most challenging tasks for DBAs. Traditional approaches using Oracle Data Guard or Oracle GoldenGate require deep expertise, complex configurations, and significant manual effort, making large-scale migration projects time-consuming and error-prone.

To address these challenges, Oracle introduced Zero Downtime Migration (ZDM)—a powerful tool designed to automate and simplify Oracle database migration projects.

This course teaches you how to use Oracle Zero Downtime Migration to migrate on-premises Oracle databases to Oracle Cloud Infrastructure (OCI), Exadata Cloud at Customer, and Exadata Cloud Service, with minimal downtime. ZDM leverages proven technologies such as Oracle Active Data Guard and Oracle GoldenGate, while hiding their complexity behind automated workflows.

ZDM supports a wide range of source database architectures, including single-instance and RAC, CDB and non-CDB, and both Standard and Enterprise Editions.

By the end of this course, you will be able to:

Install and configure Oracle Zero Downtime Migration
Understand ZDM workflows and migration phases
Configure ZDM migration jobs
Implement physical online migrations
Implement logical online migrations
Monitor, manage, and troubleshoot migration jobs

Each concept is followed by hands-on practical exercises, supported by video demonstrations and downloadable practice materials. You will build a practice environment that closely resembles real-world migration scenarios and apply ZDM end to end.

This course is designed for Oracle DBAs and migration engineers who want to implement cloud migration projects confidently and efficiently.

If you are planning Oracle database migrations and want to reduce downtime, risk, and manual effort, this course will give you the practical skills you need.

Who this course is for:

This course is designed for Oracle DBAs who are interested in using Zero Downtime Migration tool for migrating on-premises databases to the Oracle Cloud.

Oracle Zero Downtime Migration (ZDM) – Hands-On Guide

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 6min

Preparing Course Practice Environment6 lectures • 31min

Introducing Oracle Zero Downtime Migration4 lectures • 32min

Introducing ZDM Workflows4 lectures • 33min

Quiz0

Setting Up Zero Downtime Migration6 lectures • 46min

Preparing for Zero Downtime Migration jobs3 lectures • 20min

Managing Zero Downtime Migration jobs7 lectures • 53min

Implementing Zero Downtime Migration Physical migration10 lectures • 1hr 10min

Preparing the Databases for Logical Migration5 lectures • 43min

Requirements

Description

Who this course is for: