11gR2 Transportable Tablespaces Certified for EBS 11i
By John Abraham-Oracle on Nov 01, 2011
Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for Oracle E-Business Suite Release 11i (18.104.22.168) with Oracle Database 11g Release 2.
Obtaining this patch
This migration process requires a "Controlled" patch delivered by the Oracle E-Business Suite Platform Engineering team, i.e. it requires a password obtainable from Oracle Support. We released the patch in this manner to gauge uptake, and help identify and monitor any customer issues due to the nature of this technology. In addition to the requirement for 22.214.171.124 as the Release 11i version, TTS migration requires both the source machine and target machine databases to be 11gR2.
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 SQL*Plus (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. Consequently. database migration will need to be performed via Transportable Tablespaces (for large databases) or export/import.
The use of Transportable Tablespaces can greatly speed up the migration of the data portion of the database. However, it does not affect metadata, which must still be migrated using export/import. We recommend that users initially perform a test migration on their database, using export/import with the 'metrics=y' parameter. This will help identify the relative amounts of data and metadata, and provide a basis for assessing likely gains in timing. In general, the larger the amount of data (compared to metadata), the greater the reduction in downtime that can be expected from using XTTS as a migration process.
Where can I find more information?
- Using Transportable Tablespaces to Migrate Oracle E-Business Suite Release 11i Using Oracle Database 11g Release 2 Enterprise Edition (My Oracle Support Knowledge Document 1366265.1)
- Oracle Database Administrator's Guide 11g Release 2 (11.2) (PDF, 16 MB)
- Migrating E-Business Suite Release 11i Databases Between Platforms
- Migrating E-Business Suite Release 12 Databases Between Platforms