Migrating Oracle workloads from on-premises environments to Oracle Autonomous Database on Azure (ADB@Azure) can be achieved with near-zero downtime using Oracle Zero Downtime Migration (ZDM) and Oracle GoldenGate (OGG).

This guide provides a streamlined step-by-step approach covering source preparation, GoldenGate setup, ZDM configuration, and migration execution.

1. Architecture Overview

The migration setup consists of:

• Source Database (On-Prem Oracle DB)

• GoldenGate Hub VM

• ZDM Server

• ADB@Azure Target Database

• NFS Storage for Data Pump transfer

Migration Flow

1. Prepare source database

2. Configure GoldenGate replication

3. Prepare ADB@Azure target

4. Configure GoldenGate VM

5. Configure ZDM server

6. Run ZDM evaluation

7. Execute online logical migration

8. Monitor GoldenGate lag

9. Perform cutover

2. Source Database Preparation

ZDM Requirements

Create SSH Connectivity

• Add Oracle user to required OS group

• Generate SSH key pair for Oracle user

• Copy private key to ZDM server