Using Transportable Database 11gR1 with E-Business Suite

maapaper.png
Platform migration is the process of moving a database from one operating-system platform to a different operating-system platform.  There are two supported methods for doing this: 
  1. 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.
  2. Use the Transportable Database feature
You can expect a 50% or greater reduction in the time it takes to complete a platform migration using Transportable Database when compared to traditional export/import methods.

Transportable Database 10gR2 was certified for the E-Business Suite last year.  I'm pleased to announce that our Applications Platforms Group has certified this for the next database release -- Transportable Database 11gR1 -- with the E-Business Suite.

Prerequisites

Database migration across platforms of the same "endian" format (byte ordering) using the Transportable Database (TDB) process is now certified with Oracle Database 11gR1 (11.1.0.7) for Oracle E-Business Suite Releases 11i (11.5.10.2) and 12 (12.0.4 and higher).

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 then be used to migrate the database to this target. Otherwise, an alternative such as export/import should be used instead.

Not the same as Cross-Platform Transportable Tablespaces (XTTS)

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.

References
Related Articles
Comments:

Hi,
Are these doc published, as I am not able to see them. As this is one off my favourate topic.

Rgds
Sundeep

Posted by Sundeep on October 18, 2009 at 02:24 AM PDT #

Thanks I was able to view it now, seems some issue with metalink on my Laptop.

Regards
Sundeep

Posted by Sundeep on October 18, 2009 at 08:59 PM PDT #

Thanks Steven for the good overview and insight once more. Very useful! For me, unfortunately, it boils down to your last few lines "Not the same as Cross-Platform Transportable Tablespaces (XTTS)", as I was researching the options for migration of an EBS database from AIX (Big Endian) to Linux (Little Endian). Datapump it is going to be, then !

Posted by Jos Nijhoff on March 10, 2010 at 11:06 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
      
Today