Continue from previous posting.
Step-by-Step Migrate Database and Applications
1. Migrate Database of Oracle EBS
After upgrade the database of Oracle EBS to 10g Release 2, migration process will be more easier than if the database version still in 9i. The supported way to accomplish 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. Oracle Database 10g provides two additional methods of migration a database to a new platform. Oracle Database 10g Release 2 introduced Transportable Database (TDB), which is used to reduce the amount of time and effort required to migrate a database between platforms that share the same endian format (byte ordering). Oracle Database 10g Release 1 introduced cross platform transportable tablespaces (XTTS), which allows data files to be moved between platforms of different endian format. XTTS is an enhancement to the transportable tablespace (TTS) feature introduced in Oracle8i. TTS was originally released as a method to move a subset of one database into another, such as plugging parts of an OLTP database into a data warehouse on the same platform. With the cross-platform enhancement, XTTS can plug data files into a database on a different platform, including those that are using a different endian format. XTTS may reduce platform migration time by moving all user tablespaces from a source database to an empty target database running on a platform that uses a different endian format. With the XTTS feature, Tablespaces plugged into the empty target database by copying the data files to the target database, converting them to the target system endian format, then importing the object metadata into the target database. Continue reading »