Migrate Data into Autonomous AI Database on Dedicated Exadata Infrastructure
Data migration is moving data with or without its schema from one system, location, or application to another. One classic example of data migration is when you decide to adopt Autonomous AI Database for your organization and move the existing historical data from the current database to Autonomous AI Database.
Data migration is different from loading sample data or a small volume of data into your database. It usually involves large volumes of data and can be a one-time activity or periodic activity depending on the requirement. See Data Loading Options to explore the different options available for loading sample data into Autonomous AI Database.
Data Migration Overview
Oracle provides several options to migrate your data to an Autonomous AI Database on Dedicated Exadata Infrastructure. Autonomous AI Database on Dedicated Exadata Infrastructure on dedicated infrastructure lets you perform manual data export and import from:
-
On-premise database, system, or data source
-
SaaS applications
-
Third-party data source
-
Data lakes (Hadoop)
-
Other Oracle Database Cloud Services
Description of the illustration data_migration.png
When migrating to Autonomous AI Database, you can:
-
Use traditional tools such as Oracle SQL*Loader and Oracle Data Pump to migrate your source databases into Autonomous AI Database.
-
Use Data Migration Service (DMS) for simple data migration of large databases that require low migration downtime.
-
Use Zero Downtime Migration (ZDM) tool for secure migration to Autonomous AI Database on Public Cloud and Exadata Cloud@Customer.
-
Use Oracle Object Storage to manage, load, and upload large volumes of data.
-
Provide the source data in various formats such as SQL Loader text files, export-import dump files, CSV, JSON, Parquet files.
-
Load data into Autonomous AI Database by attaching external Network File System (NFS) devices provided by the customer or Oracle Cloud Infrastructure File System Service (OCI FSS) using
DBMS_CLOUD_ADMIN.
Note:
If you notice any object compilation errors after migrating data into an Autonomous AI Database, you can recompile the database objects using, as shown below. UTLRP.SQL cannot be used to perform a global recompile on an Autonomous AI Database.
exec sys.UTL_RECOMP.RECOMP_PARALLEL(4);Migration Prerequisites
As a prerequisite, it is recommended that you run the Cloud Premigration Advisor Tool (CPAT) to help you evaluate the compatibility of the source database with the Autonomous AI Database. CPAT identifies potential actions you may need to take before or during the migration, prioritizing their importance and suggesting resolutions. Some migration tools and services automatically run this advisor. Refer to Cloud Premigration Advisor Tool in Oracle Database 19c Utilities or Oracle Database 26ai Utilities for more information.
Migration Options
There are multiple options available to move your data into an Autonomous AI Database on Dedicated Infrastructure in the public cloud as well as Cloud@Customer.
These options are listed below along with a table to pick the right option based on customer use case.
-
Oracle Database Migration Service: A fully managed cloud service that simplifies moving established databases from on-premise, third-party, or on Oracle Cloud to Autonomous AI Database.
-
Oracle GoldenGate: Oracle's data replication tool for one time data migration as well as data replication with change data capture.
-
Zero Downtime Migration (ZDM): A service with a command line interface that you install and run on a host that you provision. The server where the Zero Downtime Migration software is installed is called the Zero Downtime Migration service host. You can run one or more database migration jobs from the Zero Downtime Migration service host.
-
Network File Storage (NFS): Use your local Network File System (NFS) storage to move data in and out of Exadata Cloud@Customer deployments by attaching your Network File Storage (NFS) share to your Autonomous AI Database.
-
Oracle Data Pump: Database utility supporting high-speed bulk data and metadata movement between Oracle databases and Autonomous AI Database.
-
Oracle SQL*Loader: Database utility to load data from external files into Oracle Database.
Migration Use Cases
Depending on your source database, one or more of the above migration options can be used for migrating data to Autonomous AI Database on Public Cloud or Exadata Cloud@Customer deployments. Listed below are some of the most common migration use cases to help you pick the right option.
| Migration Use Case | Migration Option(s) | Further Reference |
|---|---|---|
Non-Oracle Database → ADB-D on Public Cloud or Exadata Cloud@Customer.  |
|
|
Oracle Database version 11.2.0.4 and above → ADB-D on Public Cloud  |
|
|
Oracle Database version 11.2.0.4 and above → ADB-D on Exadata Cloud@Customer  |
|
|
Oracle Database version below 11.2.0.4 → ADB-D on Public Cloud or Exadata Cloud@Customer  |
|
|
OCI Database (VMDB, BMDB, ExaCS) → ADB-D on Public Cloud  |
|
|
OCI Database (VMDB, BMDB, ExaCS) → ADB-D on Exadata Cloud@Customer  |
|
|
Autonomous AI Database Serverless → ADB-D on Public Cloud or Exadata Cloud@Customer  |
|
|
3rd Party Cloud Vendors (AWS, Azure) → ADB-D on Public Cloud or Exadata Cloud@Customer  |
|
|
Autonomous AI Database on Dedicated Exadata Infrastructure → Autonomous AI Database on Dedicated Exadata Infrastructure  |
|
Note: Deciding the migration tool or utility to use depends on multiple factors such as your source database, source data format, data volume and complexity. To help you identify the most optimal solution for migrating your data to Autonomous AI Database, Oracle provides an advisory utility called Oracle Cloud Migration Advisor. See www.oracle.com/goto/move for more information about this utility.