Updated: EBS 12.1 + Transportable Tablespaces with Incremental Backup Option

February 2, 2017 | 2 minute read
Steven Chan
Senior Director
Text Size 100%:

Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process has been certified for Oracle E-Business Suite Release R12.1 for several years. 

This certification has recently been updated to cover the use of the incremental backup option with Database 11.2.0.4 as a source.

Transportable Tablespaces

 

Does it meet your requirements?

Note that for migration across platforms of the same "endian" format, users are advised to use the Transportable Database (TDB) migration process instead for large databases. The "endian-ness" target platforms can be verified by querying the view V$DB_TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba) on the source platform:

SQL> select platform_name from v$db_transportable_platform;
If the intended target platform does not appear in the output, it means that it is of a different endian format from the source and Transportable Tablespaces (for large databases) or export/import should be used for database migration. The use of Transportable Tablespaces can greatly speed up the migration of the data portion of the database - it does not affect metadata which must still be migrated using export/import. We recommend that users initially perform a test migration with export/import on their database with the 'metrics=y' parameter to find out the relative size of data vs metadata in their database and to have a basis to compare any gains in timing. Generally speaking, the larger the relative size of data (as compared to metadata), the more likely it would be that XTTS is suitable to reduce downtime.

Steven Chan

Senior Director

Steven Chan was a Senior Director in the Oracle Applications Technology Group.  He managed EBS technology stack certifications, ATG product management, ATG documentation and curriculum, and ATG Quality Assurance in the E-Business Suite Development division.

Steven joined Oracle in 1998.  Steven retired from Oracle in 2019. Prior to joining Oracle, he held positions with IBM, Deloitte & Touche Consulting, and other software companies. 

Steven is an Oracle ACE and a three-time recipient of the Oracle Applications User Group 'Ambassador of the Year' Award (2007, 2009, 2010). Steven received the Oracle Applications User Group Lifetime Service Award in 2011.


Previous Post

MD5 Signed JAR Files Treated as Unsigned in April 2017

Steven Chan | 2 min read

Next Post


Will EBS Work with Windows 10 Anniversary Update?

Steven Chan | 1 min read