Learn About Migrating Data to an Autonomous Database in the Cloud Using MV2ADB

You want to move your data from on-premises to an autonomous database to maximum your database uptime, performance, and security, but you're concerned about how to safely and efficiently transfer the data.

The quickest method of data loading is to use Oracle Data Pump to upload the source files from on-premises to a cloud-based object store before loading the data into your autonomous database. One option is to use the Move to Autonomous Database (MV2ADB) tool to perform the entire data load process with a single click.

Before You Begin

Learn more about migrating a database.

• Migrate an on-premises Oracle Database deployment to an autonomous database
• Learn about reducing downtime during a database migration

You must be able to log into My Oracle Support to download the latest mv2adb package.

Architecture

This architecture shows how the Move to Autonomous Database (MV2ADB) tool can help you move your data from a database in an on-premises data center to an autonomous database in Oracle Cloud.

Description of the illustration migrate-mv2adb.png

With the help of a configuration file and an MV2ADB command, you can migrate from on-premises to an Oracle Autonomous Database. MV2ADB leverages Oracle Data Pump, REST API and Oracle Cloud Infrastructure command-line interface (oci-cli) to export data from your on-premises database to your Oracle Autonomous Database in the cloud.

The following is the workflow:

1. Export the data from the database to on-premises storage. Staging storage on the source database server must be about the same size as the source database plus the space needed for object storage.
2. Export the data from on-premises storage to Data Pump files Oracle Cloud Infrastructure Object Storage in the Oracle Cloud region.
3. Import the data into an Oracle Autonomous Database.
4. Verify the data transfer with SQL*Net.

While Oracle provides support for using netlink to load files that are located locally in your data center, it is not recommended due to significantly lower transmission speeds. For the fastest data loading experience, Oracle recommends uploading the source files to Oracle Cloud Infrastructure Object Storage before loading the data into your Autonomous Database.

About the MV2ADB Tool

The Move to Oracle Autonomous Database (MV2ADB) tool is designed to enable you to quickly upload source files to the cloud and supports Oracle Cloud Infrastructure APIs and command-line interface (oci-cli).

The tool includes the following operations to manage the load and migration data life-cycle from on-premises to the cloud:

• Auto operation:
  • auto: Automates the migration and performs the entire load data process into the autonomous database in the cloud, including exporting the data from the source database (expdp), uploading the data to Oracle Cloud Infrastructure Object Storage (putdump), and importing the data to the target database (impdp)

• Oracle Data Pump Operations:
  • expdp: Exports data to Oracle Data Pump files
  • impdp: Imports data from Oracle Data Pump files
• Oracle Cloud Infrastructure Object Storage Bucket Operations:
  • createbucket: Creates a bucket
  • delbucket: Deletes a bucket
  • listbucket: Displays a list of buckets
• Oracle Cloud Infrastructure Object Storage Object Operations:
  • deldump: Deletes files from a bucket in Oracle Cloud Infrastructure Object Storage
  • getdump: Retrieves files from a bucket in Oracle Cloud Infrastructure Object Storage
  • listdump: Displays a list of files in a bucket in Oracle Cloud Infrastructure Object Storage
  • putdump: Load files into a bucket on Oracle Cloud Infrastructure Object Storage

• Database Schema Operations
  • advisor: Analyzes your source database schemas for suitability to migrate to Oracle Autonomous Database
  • report: Displays a schema object report to compare the result of the export (expdp) and import (impdp) results
  • recomp: Recompiles schema objects

• Encrypt password Operations:
  • encpass: Generates an encrypted password for the MV2ADB configuration file

Use the --help option to get help with commands.

Use the --version option to display the program's version number and exit.

About Required Services, Products, and Roles

This solution requires the following services, products, and roles:

• mv2adb rpm package.

• SQL*Net connectivity from the on-premises server to the autonomous database to move expdp dump.

  Verify that you can use Sql*Plus to connect from your source database to your target Autonomous Database before using MV2ADB.

• Autonomous Database (ADB) wallet zip.

• Oracle Instant Client version 18.3.0.0.0 or above for your version of Oracle Database and your operating system platform to support new impdp cloud command option. If there is an existing Oracle Database 18.3 or higher installed, you can use the Oracle Instant Client version that's installed with the database.
  • Basic Package: All files required to run Oracle Cloud Infrastructure, Oracle C++ Call Interface (OCCI), and Java Database Connectivity (JDBC) Oracle Call Interface (OCI) applications
  • SQL*Plus Package: The SQL*Plus command line tool for SQL and PL/SQL queries
  • Tools Package: Includes Data Pump, SQL*Loader and Workload Replay Client

• java executable in the path.

  If you have an existing installation of Oracle Database version 18.3 or higher, the executable should be available in the path

• Perl release 5.10 or above.
• Perl Data-Dumper module
• Oracle Cloud Infrastructure command-line interface, installed and configured. The CLI is a small-footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands. Some of these, such as the ability to run scripts, extend Console functionality.

The MV2ADB command-line utility requires root system privileges for most actions. You may want to use SUDO as part of your system auditing and security policy. For most tasks, you need to log in as root to use the MV2ADB command-line interface when the --nosudo command option is not provided.

These are the roles needed for each service.

Service Name: Role	Required to...
Oracle Database: root	Transfer data from the on-premises database to the Oracle Cloud Infrastructure Object Storage
Oracle Autonomous Database: root	Transfer data from Oracle Cloud Infrastructure Object Storage to the autonomous database
Autonomous Data Warehouse: Service administrator	Download the Oracle client credentials (wallet)
Oracle Cloud Infrastructure: Admin	Manage the transfer of data in Oracle Cloud Infrastructure Object Storage in the cloud.
Oracle Database Backup Cloud Service: Admin	Backup and restore the data.

See Learn how to get Oracle Cloud services for Oracle Solutions to get the cloud services you need.