New Source Database Added for EBS 12 + 11gR2 Transportable Tablespaces
- by John Abraham
The Transportable Tablespaces (TTS) process was originally certified for the migration of E-Business Suite R12 databases going from a source database of 11gR1 or 11gR2 to a target of 11gR2.
This requirement has now been expanded to include a source database of 10gR2 (10.2.0.5) - this will potentially save time for existing 10gR2 customers as they can remove on a crucial upgrade step prior to performing the platform migration.
The migration process requires an updated 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. This patch has been updated to now include supporting 10gR2 as a source database.
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 TTS as a migration process.
For smaller databases or for those that have relatively small data compared to metadata, TTS will not be as beneficial for cross endian migration and the use of export/import (datapump) for the whole database is recommended.
Where can I find more information?
Using Transportable
Tablespaces to Migrate Oracle E-Business Suite Release 12 Using Oracle
Database
11g Release 2 Enterprise Edition (My Oracle Support
Document 1311487.1)
Oracle
Database Administrator's Guide 11g Release 2 (11.2)
Related Articles
Database Migration using 11gR2 Transportable Tablespaces Now Certified for EBS 12
New Source Databases Added for Transportable Tablespaces + EBS 11i
10gR2 Transportable Tablespaces Certified for EBS 11i
Migrating
E-Business Suite Release 11i Databases Between Platforms
Migrating
E-Business Suite Release 12 Databases Between Platforms
