My Oracle Support Banner

Migrate database to Exadata with DBMS_FILE_TRANSFER (Doc ID 1902618.1)

Last updated on SEPTEMBER 29, 2021

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Solaris on SPARC (64-bit)
Linux x86-64

Goal

Database migration to Exadata can be accomplished in a number of ways, as discussed in
Oracle® Database High Availability Best Practices 11g Release 2 (11.2)
Chapter 14 Reducing Downtime for Planned Maintenance
Section 14.2.7 Database Platform or Location Migration.

One way to perform this task is the Transportable Tablespaces for Platform Migration. The method described in this document can be used to migrate any database (version 10.2 to 11.2.0.4), from any platform, to 11.2.0.4 and later on Exadata. We have successfully performed the migration from Solaris SPARC (database versions 10.2.0.1, 10.2.0.4 and 11.2.0.3), IBM AIX (database version 11.1.0.7) and Linux (database version 11.2.0.3) to 11.2.0.4 and 12.1.0.1.0 on Exadata.

Solution

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
Goal
Solution
 Introduction
 1. Initial setup (phase 1)
 1.1. Source database
 1.2. Destination database
 2. Transport datafiles (phase 2)
 2.1. Create the transport scripts on the source system
 2.2. Transfer the datafiles to the destination
 3. Incrementally updated backups (phase 3)
 3.1. Create incremental backups of the source datafiles
 3.2. Transfer incremental backups to destination
 3.3. Apply incremental backups on destination
 3.4. Determine the FROM SCN for next incremental backup
 4. Plug in transported tablespaces (phase 4)
 4.1. Make source tablespaces READ ONLY
 4.2. Final incremental backup
 4.3. Final incremental backup merge
 4.4. Import the transported tablespaces metadata
 4.5. Validate plugged in tablespaces at destination
 Conclusion
References


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