Transportable Tablespace for On-Premise Database Migrations Now Certified with EBS 12.2 and Database 19c

August 20, 2020 | 2 minute read
John Abraham
Director
Text Size 100%:

Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for on-premise Oracle E-Business Suite Release 12.2 (12.2.3 or higher) with Oracle Database 19c.

To use this certified process the source database must be either Oracle Database 11gR2 (11.2.0.4), 12cR1 (12.1.0.2) or 19c and the target database is Oracle Database 19c. The target database will consist of a single pluggable database (PDB) in a container database (CDB).

This EBS 12.2 with Database 19c database migration process utilizes the full transportable export/import feature. The full transportable export/import feature significantly speeds up the migration process while also offering the optional use of incremental backup to minimize downtime.

Patch 31405457, delivered by the EBS Platform Engineering team, is required for this migration process. The patch is now generally available on MOS for use by EBS customers. The patch provides various SQL scripts to facilitate the export and import of an EBS database instance using TTS.

The "endian-ness" of platforms can be checked by querying the view V$TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba) with the following statement:

SQL> select platform_name, endian_format from v$transportable_platform;

The following table is a list of relevant platforms certified for the EBS 12.2 with Database 19c on the database tier:

Big Endian Little Endian
Oracle Solaris on SPARC Linux x86-64
HP-UX Itanium Windows x64
IBM AIX on Power Systems  
Linux on IBM Z  

 

Guidance for Using Transportable Tablespaces

The use of TTS may greatly speed up the migration of the data portion of the database. It does not however affect the speed of migrating the metadata which is done using export/import. Smaller databases (less than 1TB) may see little gain from the use of TTS and other techniques like export/import are simpler and possibly faster.

We recommend that when considering the use TTS, you first perform a test migration with export/import on your database using the 'metrics=y' parameter. This will provide information regarding the relative size of data vs metadata in your database and thereby give you a basis to compare any gains in timing. Generally speaking, the larger the relative size of data (as compared to metadata), the more likely it would be that TTS is suitable as a migration process to reduce downtime.

This particular certification is specific to on-premise platform migrations. Additional platform migration certifications that are in progress or planned include the following:

  • EBS 12.1.3 DB cross-platform migration using 19c Transportable Tablespaces for on-premise
  • EBS 12.2 and 12.1.3 DB cross-platform migration to Oracle Cloud using 19c Transportable Tablespaces

References

Related Articles

John Abraham

Director

John Abraham is a Director of Product Management in the Applications Technology Group for Oracle E-Business Suite. He heads product management for the E-Business Suite Platform Engineering group responsible for the release and certifications of the E-Business Suite and its technology on hardware platforms and systems. The team is also responsible for certifying migrations of the E-Business Suite between platforms, including cross platform migrations to the Oracle Cloud.

John joined Oracle in 2003 and has wide experiences in development (user interface, systems engineering), design, and product management. He enjoys hiking, most things culinary, watching (though no longer playing) soccer and occasionally hitting tennis balls with friends.


Previous Post

Subscribe to Updates from the Oracle E-Business Suite Technology Blog

Elke Phelps | 2 min read

Next Post


In Place Standby Upgrade to Database 19c Now Certified for EBS 12.2

Elke Phelps | 2 min read