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

Prepare an Oracle VirtualBox appliance with Oracle Linux 7 and 19c database, install swing bench, and set up the order entry schema in the database.

Prepare the practice environment by installing the swing bench tool, creating the bench schema, configuring the IP address and passwords, and running a benchmark to monitor transactions per minute.

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.

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.

Provision a VM DB system in OCI, configure networking and private/public keys, create a 19c database with a PDB inside the CDB, and verify connectivity.

Provision and configure a VM DB system in OCI, register services and listener, update PDP one name in its file, and create a conviction descriptor; consider shutdown to save costs.

Learn to migrate on-prem databases to OCI by comparing methods, tools, and downtime implications, while reviewing OCI database services, unicode considerations, and versions.

Explore Oracle’s migration options for on-premises databases to OCI, from data pump and transportable methods to RMAN backups and zero downtime migration, and compare downtime implications.

Discover Oracle zero downtime migration (ZDM), a high-availability solution for migrating Oracle databases to OCI with automated backups, standby creation, and synchronization using GoldenGate and Data Pump.

Explore Oracle zero downtime migration (ZDM) for offline migrations with minimal downtime, using backup storage and data dumps to restore a Linux x86_64 target, pausing and resuming, scheduling, encryption.

Explore Oracle zero downtime migration workflows, detailing physical and logical migrations and online and offline execution, to compare options and select the best workflow for a given migration scenario.

Explore the physical online migration workflow for Oracle zero downtime migration: configure the CDM host, connect source and target databases, create backups, and perform a switch over with optional fallback.

Explore offline migration workflows that back up the source and instantiate the target. Examine online migration with Golden Gate and data pump for real-time replication and switch over.

Explore zero downtime migration workflows for Oracle, comparing online and offline options, including logical offline migration, database links, and backup locations to minimize downtime.

Set up zero downtime migration software by downloading and installing the CDM installer, preparing the Linux host, selecting the optimal workflow, and preparing source and target databases.

Download and install the zero downtime migration software, import the Oracle Linux 7.8 appliance into VirtualBox, and configure static IP, hostname, and hosts to prepare the service host.

Set up zero downtime migration software by installing required packages, creating the zdm user and group, configuring environment variables, and starting the service on a vm.

Configure zdm connectivity between the service host and source and target databases. Deploy public keys to authorized_keys for passwordless source access, while the target requires a password.

Enable ping service in OCI subnets and adjust security lists or NSG to permit icmp, enabling source and target databases to resolve scan host names during zero downtime migration.

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.

Prepare source and target databases for physical migration by enforcing archive log mode and Oracle prerequisites. Ensure edge connectivity, time synchronization, disable automated jobs, and use matching database versions.

Prepare the target for physical migration by validating a placeholder database, ensuring matching source name with a unique db parameter, sufficient storage, disallowing backups, and opening ports 22 and 1521.

Learn to prepare the ZDM response file for physical migration, configuring parameters like DB unique name, platform type, migration method, and data transfer medium for online or offline workflows.

Learn how to start and manage ZDM migration jobs, including evaluating, executing, and monitoring on source and target systems, with online/offline and physical versus logical migration phases.

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.

Learn to start and manage ZDM migration jobs, monitor progress via query and status outputs, pause, resume, or abort jobs, and handle evaluation results and failures.

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.

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.

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.

Execute a physical online migration from a local 19c CDB to an OCI target using ZDM, including response file creation and a pre-migration snapshot.

Create a response file for zero downtime migration to OCI, enter the required parameters and the target database name, then set up object storage, tokens, and archive log mode.

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.

Learn how to perform an online physical migration to OCI with ZDM, pausing and resuming the job, and assess downtime factors like distance, target database specs, and batch settings.

learn how to migrate a non-CDB database to a PDB in Oracle Cloud Infrastructure, including prerequisites, background conversion to a PDB, and caution about the TGT_SKIP_DATA_BATCH parameter.

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.

Perform a zero downtime migration of a non-CDB database to an OCI PDB, adjusting the response file, running the migration job in evaluation mode, and verifying schema and data post-migration.

Migrate a RAC database to an OCI RAC DB system using Oracle zero downtime migration in practice 7, detailing setup steps and a password file copy bug with no workaround.

Learn how to perform offline physical migration with an existing level zero backup, skip the full backup, and generate incremental level one backups to minimize downtime.

Perform a physical offline Oracle zero downtime migration using an existing incremental backup, with object storage setup and level zero backup, then run and verify the migration.

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.

Prepare source and target databases for logical migration by aligning character sets, tuning streams pool memory, enabling Golden Gate, configuring certificates and wallets, and ensuring time zone file compatibility.

Prepare the response file for logical migration by detailing migration method, data transfer medium, and Golden Gate and OCI parameters for the source and target databases.

Configure data pump parameters to control data pump operations in Oracle zero downtime migration, including job mode, schemas, and include or exclude objects. Manage object storage and dump files.

Explore managing tablespaces in logical migrations for Oracle zero downtime migration, including configuring target-space creation and remapping parameters, and weighing automatic creation versus pre-creating spaces for performance.