News, tips and technical guidance to help you run Oracle E-Business Suite on Oracle Cloud.

Incremental Backup for EBS R12 Cross Platform Migration to Oracle Cloud Now Certified

John Abraham

As a follow up to our previous announcement on the certification of cross platform migration to Oracle Cloud, we are pleased to announce that the use of cross platform incremental backup is now certified for Oracle E-Business Suite Releases 12.1 (12.1.3) and 12.2 (12.2.3 or higher) with Oracle Database 12c Release 1 (12.1.0).

Incremental backup is a feature that further reduces downtime when performing a cross platform database migration using Transportable Tablespaces. This is achieved by use of rman to perform endian conversion of data, whilst using export/import (datapump) for metadata only.

Using the incremental backup option, an initial backup of tablespaces is converted and migrated. Subsequent incremental backups in a roll forward phase are then performed, followed by a final transport phase to the target platform to complete the database migration. Downtime is required only for this final phase, and for any metadata that needs to be migrated by export/import.

The migration MOS notes in the References section below list the patches you will need for this migration, which can all be downloaded from My Oracle Support.


Related Articles

Join the discussion

Comments ( 4 )
  • Prashant Pahune Monday, March 11, 2019
    Doc ID 2471245.1, has below note. Using it will still benefit to EBS customers or TTS approach will be better?

    The Cross Platform Incremental Backup feature does not affect the amount of time it takes to perform other actions for XTTS, such as metadata export and import. Hence, databases that have very large amounts of metadata (DDL), such as Oracle E-Business Suite and other packaged applications, will see limited benefit from Cross Platform Incremental Backup because migration in these environments is typically dominated by metadata operations, not datafile transfer and conversion.
  • John Abraham Wednesday, March 13, 2019
    hi Prashant -
    I'm working with the author of that document to clarify that statement - it's not true that every E-Business Suite database has large metadata size relative to data. While it may be true of smaller EBS databases, it is important that this be clarified. Note that regardless of the use of incremental backup, metadata must be exported/imported with datapump and can be the bottleneck of any migration.
  • Chris Slattery Wednesday, July 24, 2019
    Hi John any updates on the clarification ? For example on a Vision Database as a standard input to this process from Solaris to OCI is there any standard timing comparison of the incremental approach to the full XTTS approach ?
  • John Abraham Tuesday, August 6, 2019
    Hello Chris -
    Yes, the document mentioned above was corrected in March 2019 to remove the reference to EBS.
    Regarding your question about standard timing comparisons, if what you mean by this is the downtime savings, the incremental backup approach definitely does reduce the downtime as the bulk of the backups and data transfers are done just prior to bringing down the DB. It's certainly more work to do this as one has to perform those backups and move data files to the target in the meantime.
    In terms of downtime savings, this could vary from a few to dozens of hours depending on the size of the DB.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.