|
 Oracle Database 12c Upgrade/Migration using Full Transportable Export/Import |
This article describes how to perform a Database upgrade/migration to Oracle Database 12c with less downtime by using the new Oracle Database 12c feature Full Transportable Export/Import.
The traditional methods such as export/import, Datapump export/import and Transportable tablespaces, can still be used to upgrade/migrate a database to Oracle Database 12c. However, Oracle Database 12c now provides another method with the new feature called Full Transportable Export/Import making the migration/upgrade easier, faster and more efficient.
Let's look at a brief comparison of the various methods:
| Upgrade using Database upgrade assistant (DBUA) |
- requires more downtime
- migration across platform is not possible
|
| Conventional export/import |
- relatively slow
- not preferred method for large database size systems
- reliable migration technique, but only recommended for Oracle 9i and earlier databases
|
| Datapump export/import (introduced with Oracle Database 10g) |
- designed to handle large volume of data
- replaces original export/import as the most common way to move data between Oracle databases
- overtaken by Transportable tablespace method in terms of performance
|
| Transportable tablespaces |
- achieves upgrade/migrate faster by copying database files to target system
- requires additional steps to move user and system metadata to destination database
- user objects associated with non user tablespaces (system and sysaux tablespaces) needs to be taken care manually
- database file conversion will be required in case, source and target have different Endian format
|
| Full Transportable Export/Import |
- uses both Transportable tablespaces mechanism and Datapump features
- Transportable tablespace mechanism is used to move database files to target system resulting in faster migration even for large volume of data
- Datapump is used to move metadata to target database
- Complete migration with single import command
- Capable of moving all required user data and metadata to migrate a database
|
|
|
Readme more here ( You need access to MOS )
