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).
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