My Oracle Support Banner

Migrate database to Exadata with DBMS_FILE_TRANSFER (Doc ID 1902618.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 12.1]
Oracle Solaris on SPARC (64-bit)
Linux x86-64


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, from any platform, to and later on Exadata. We have successfully performed the migration from Solaris SPARC (database versions, and, IBM AIX (database version and Linux (database version to and on Exadata.


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
 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

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