My Oracle Support Banner

EM 13c MIGRATION WORKBENCH : How To Consolidate/Migrate Databases From On-Premises Databases To Oracle Cloud and On-Premise Databases To On-Premise Using Migration Workbench With Method "Datapump" (Doc ID 2782766.1)

Last updated on DECEMBER 20, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 13.5.1.0.0 and later
Information in this document applies to any platform.

Purpose

Migration workbench is used to Migrate a databases from on-premises databases to the Oracle Cloud and on-premises databases to on-premises databases using method data pump from Enterprise Manager. This can be done via Database Migration Workbench, EM CLI or REST API in Enterprise Manager.

Scope

Migrating Databases with the Database Migration Workbench is a simple intuitive process that will guide you through setting up and moving your on-premises databases to Oracle Autonomous Databases and on-premises to on-premises. Currently method used for migration is Data Pump.

This  method is suggested for customers who would like to migrate complete databases or  individual schemas from across databases. This is highly recommended method for migrating databases of Smaller size.

Steps outlined in this document are migrating databases from on-premises to on-premises using migration work bench.

1. Plan Your Migration
2. Migrate Databases
3. Analyze Migrated Database Performance
4. Perform Post-Migration Activities

Details

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
Purpose
Scope
Details
 Advantages  of Datapump based approach
 Prerequisites Required by the Source Database
 Prerequisites Required by the Destination Database
 High Level Steps
 Downtime calculation
 Migration Steps
 1. Prepare Phase
 2. Incremental Phase
 3. Final Phase

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