Full Transportable Export/Import – one of the coolest features in Oracle Database 12c
We blogged about Full Transportable Export/Import a while back. It is – no doubt – one of the coolest features in Oracle Database 12c. And it is part of our Hands-On Lab exercise (Hands On Lab – Upgrade, Migrate, Consolidate to Oracle Database 12c) as well.
It utilizes the technique of Transportable Tablesspaces – cross-platform, cross- Endianness, cross-version – but lets Oracle Data Pump do all the “dirty” work of rebuilding everything kept in your SYSTEM and SYSAUX tablespace including views, synonyms, public objects, grants, sequences etc etc etc.
You can even combine it with RMAN Incremental Backups – of course cross-platform and cross-Endianness as well – in order to decrease the downtime for large databases.
Please find our presentation about the combination of these feature here in the Slides Download Center:
In addition: You can use this Oracle Database 12c feature with your source database Oracle 126.96.36.199 or 188.8.131.52. Just the destination database you are upgrading or migrating to must be at least an Oracle 184.108.40.206 database (or newer of course).
And please find more information about the PERL scripts for xTTS/FTEX with RMAN Incremental Backups here:
See the feature in action
Roy recorded a 20 minute video demonstrating how to:
- Migrate an Oracle Database 220.127.116.11 database into an Multitenant’s pluggable database using
- Full Transportable Export/Import
- into the Oracle DBaaS Cloud
And of course the feature works also without migrating into a Container database environment – and without migrating to the Oracle DBaaS Cloud.
If you need to migrate a database from Oracle 18.104.22.168 or newer to Oracle Database 12c Full Transportable Export/Import can become your best friend.