Friday, March 8, 2024

Transportable Tablespaces to the Extreme

Oracle has engineered a new method to execute a Transportable Tablespaces to the Extreme. See the recording on Oracle's YouTube channel. You can read the Q&A and the slides .

The New Procedure called M5

For cross-platform and cross-endian migrations, we have a new procedure called M5.
It replaces the former XTTS v4 Perl script that has been used for many migrations.
We could see the need for changes as Oracle Databases world-wide grows in size and complexity. M5 implements the latest RMAN and Data Pump technology to deliver the fastest possible migrations. You can download the M5 scripts and read the procedure on My Oracle Support (Doc ID 2999157.1).

M5 Migration Script


# source database
RUN
{
  ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '...';
  ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '...';
  BACKUP FILESPERSET 1 SECTION SIZE 64G
  TAG UP19_L0_240206101548
  TABLESPACE <list-of-tablespace> ; 
}

# target database
RUN
{
  ALLOCATE CHANNEL DISK1 DEVICE TYPE DISK FORMAT '...';
  ALLOCATE CHANNEL DISK2 DEVICE TYPE DISK FORMAT '...';
  RESTORE ALL FOREIGN DATAFILES TO NEW FROM BACKUPSET
   '<backup-set-1>', 
   '<backup-set-2>',
   ...
   '<backup-set-n>'
};

Requirements

  • Source and Taerget MUST
    • Be 19.18.0 or higher
    • Use Data Pump Bundle Patch
  • Target must use  Oracle Managed Files (OMF)
    • Parameter DB_CREATE_FILE_DEST

No comments:

Post a Comment