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
- 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
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:
- 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.
- Export the data from on-premises storage to Data Pump files Oracle Cloud Infrastructure Object Storage in the Oracle Cloud region.
- Import the data into an Oracle Autonomous Database.
- 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 (
- 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 (
recomp: Recompiles schema objects
- Encrypt password Operations:
encpass: Generates an encrypted password for the MV2ADB configuration file
--help option to get help with commands.
--version option to display the program's version number and
About Required Services, Products, and Roles
This solution requires the following services, products, and roles:
SQL*Net connectivity from the on-premises server to the autonomous database to move
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 184.108.40.206.0 or above for your
version of Oracle Database and your operating system platform to
impdpcloud 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.