Migrating E-Business Suite Release 12 Databases Between Platforms
By Steven Chan (Oracle Development) on Sep 18, 2008
Boy, we're just smoking, now. You can always tell that OpenWorld is heating up when all of these new certifications come pouring out of our labs. Here's another certification that complements our previous announcement for Oracle E-Business Suite Release 11i: Our Applications Platforms Group has announced that database migration across platforms of the same "endian" format (byte ordering) using the Transportable Database process is now certified with Oracle E-Business Suite Release 12 using 10gR2.
Platform migration is the process of moving a database from one operating-system platform to a different operating-system platform. The supported way to do this prior to Oracle Database 10g Release 2 was to export the data from the database on the old platform, create a new database on the new platform, and import the data into the new database. This process could take a number of days for a large database. Starting with Oracle Database 10g Release 2, using Transportable Database and following the Maximum Availability Architecture (MAA) best practices in the whitepaper linked below, you can expect a 50% or greater reduction in the time it takes to complete a platform migration when compared to traditional unload/load methods.
The minimum 10gR2 Database version required is 10.2.0.3 on both the source and target platforms.
Suitable 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 appears in the output, Transportable Database can be used to migrate the database. Otherwise, an alternative such as export/import should be used instead.
Please note that an alternative database technology known as Cross-Platform Transportable Tablespaces (XTTS) to migrate data between platforms of different endian formats is NOT yet certified with Oracle E-Business Suite. We're running an Early Adopter Program (at full capacity) for that technology right now. I don't have any projected schedules for that certification yet, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.
- Using Transportable Database to migrate Oracle E-Business Suite Release 12 Using Oracle Database 10g Release 2 Enterprise Edition (MetaLink Note 734763.1)
- Platform Migration using Transportable Database: Oracle Database 11g and 10g Release 2