My Oracle Support Banner

11G - Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 1389592.1)

Last updated on JUNE 13, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Linux x86-64

Purpose

This note describes an older version of this procedure, V3.  It should NOT be used unless absolutely necessary.

To use XTTs, use: 
V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1)  

The rest of the details in this article are relating to XTTs V3 only.  

 When using Cross Platform Transportable Tablespaces (XTTS) to migrate data between systems that have different endian formats, the amount of downtime required can be substantial because it is directly proportional to the size of the data set being moved.  However, combining XTTS with Cross Platform Incremental Backup can significantly reduce the amount of downtime required to move data between platforms.

Traditional Cross Platform Transportable Tablespaces

The high-level steps in a typical XTTS scenario are the following:

  1. Make tablespaces in source database READ ONLY
  2. Transfer datafiles to destination system
  3. Convert datafiles to destination system endian format
  4. Export metadata of objects in the tablespaces from source database using Data Pump
  5. Import metadata of objects in the tablespaces into destination database using Data Pump
  6. Make tablespaces in destination database READ WRITE

Because the data transported must be made read only at the very start of the procedure, the application that owns the data is effectively unavailable to users for the entire duration of the procedure.  Due to the serial nature of the steps, the downtime required for this procedure is proportional to the amount of data.  If data size is large, datafile transfer and convert times can be long, thus downtime can be long.

Reduce Downtime using Cross Platform Incremental Backup

To reduce the amount of downtime required for XTTS, Oracle has enhanced RMAN's ability to roll forward datafile copies using incremental backups, to work in a cross-platform scenario.  By using a series of incremental backups, each smaller than the last, the data at the destination system can be brought almost current with the source system, before any downtime is required.  The downtime required for datafile transfer and convert when combining XTTS with Cross Platform Incremental Backup is now proportional to the rate of data block changes in the source system.

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) will see limited benefit from Cross Platform Incremental Backup since migration time is typically dominated by metadata operations, not datafile transfer and conversion.

 

Only those database objects that are physically located in the tablespaces that are being transported will be copied to the destination system. If you need for other objects to be transported, that are located in different tablespaces (such as, for example, pl/sql objects, sequences, etc., that are located in the SYSTEM tablespace), you can use data pump to copy those objects to the destination system.

 

The high-level steps using the cross platform incremental backup capability are the following:

1.  Prepare phase (source data remains online)

    1. Transfer datafiles to destination system
    2. Convert datafiles, if necessary, to destination system endian format

2.  Roll Forward phase (source data remains online - Repeat this phase as many times as necessary to catch destination datafile copies up to source database)

    1. Create incremental backup on source system
    2. Transfer incremental backup to destination system
    3. Convert incremental backup to destination system endian format and apply the backup to the destination datafile copies 
NOTE: In Version 3, if a datafile is added to the tablespace OR a new tablespace name is added to the xtt.properties file, a warning and additional instructions will be required. 

3.  Transport phase (source data is READ ONLY)

    1. Make tablespaces in source database READ ONLY
    2. Repeat the Roll Forward phase one final time
      • This step makes destination datafile copies consistent with source database.
      • Time for this step is significantly shorter than traditional XTTS method when dealing with large data because the incremental backup size is smaller.
    3. Export metadata of objects in the tablespaces from source database using Data Pump
    4. Import metadata of objects in the tablespaces into destination database using Data Pump
    5. Make tablespaces in destination database READ WRITE

The purpose of this document is to provide an example of how to use this enhanced RMAN cross platform incremental backup capability to reduce downtime when transporting tablespaces across platforms.

Scope

This note describes an older version of this procedure, V3.  It should NOT be used unless absolutely necessary.

To use XTTs, use: 

V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1)  

The rest of the details in this article are relating to V3 XTTs only.  

The source system may be any platform provided the prerequisites referenced and listed below for both platform and database are met. 

If you are migrating from a little endian platform to Oracle Linux, then the migration method that should receive first consideration is Data Guard.  See <Note 413484.1> for details about heterogeneous platform support for Data Guard between your current little endian platform and Oracle Linux. 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Traditional Cross Platform Transportable Tablespaces
 Reduce Downtime using Cross Platform Incremental Backup
Scope
Details
 Overview
 Cross Platform Incremental Backup Supporting Scripts
 Requirements and Recommendations
 Prerequisites
 Destination Database 11.2.0.3 or Earlier Requires a Separate Incremental Convert Home and Instance
 Troubleshooting
 Known Issues
 Transport Tablespaces with Reduced Downtime using Cross Platform Incremental Backup
 Conventions Used in This Document
 Phase 1 - Initial Setup
 Step 1.1 - Install the Destination Database Software and Create the Destination Database
 Step 1.2 - If necessary, Configure the Incremental Convert Home and Instance
 Step 1.3 - Identify Tablespaces to be Transported
 Step 1.4 - If Using dbms_file_transfer Prepare Phase Method, then Configure Directory Objects and Database Links
 Step 1.5 - Create Staging Areas
 Step 1.6 - Install xttconvert Scripts on the Source System
 Step 1.7 - Configure xtt.properties on the Source System
 Step 1.8 - Copy xttconvert Scripts and xtt.properties to the Destination System
 Step 1.9 - Set TMPDIR
 Phase 2 - Prepare Phase
 Phase 2A - Prepare Phase for dbms_file_transfer Method
 Step 2A.1 - Run the Prepare Step on the Source System
 Step 2A.2 - Transfer the Datafiles to the Destination System
 Phase 2B - Prepare Phase for RMAN Backup Method
 Step 2B.1 - Run the Prepare Step on the Source System
 Step 2B.2 - Transfer Datafile Copies to the Destination System
 Step 2B.3 - Convert the Datafile Copies on the Destination System
 Phase 3 - Roll Forward Phase
 Step 3.1 - Create an Incremental Backup of the Tablespaces being Transported on the Source System
 Step 3.2 - Transfer Incremental Backup to the Destination System
 Step 3.3 - Convert the Incremental Backup and Apply to the Datafile Copies on the Destination System
 Step 3.4 - Determine the FROM_SCN for the Next Incremental Backup
 Step 3.5 - Repeat the Roll Forward Phase (Phase 3) or Move to the Transport Phase (Phase 4)
 Phase 4 - Transport Phase
 Step 4.1 - Make Source Tablespaces READ ONLY in the Source Database
 Step 4.2 - Create the Final Incremental Backup, Transfer, Convert, and Apply It to the Destination Datafiles
 Step 4.3 - Import Object Metadata into Destination Database
 Step 4.4 - Make the Tablespace(s) READ WRITE in the Destination Database
 Step 4.5 - Validate the Transported Data
 Phase 5 - Cleanup
 Appendix
 Description of Perl Script xttdriver.pl Options
 Description of Parameters in Configuration File xtt.properties
  

Known Issue

Known Issues for Cross Platform Transportable Tablespaces XTTS <Document 2311677.1>
 Change History
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.