I am very pleased to share that Oracle has officially launched a new method for cross-platform migrations of Oracle Database.
You can also use the script for cross-endian migrations, so this is perfect for AIX, HP-UX or SPARC migrations to Exadata Database Machine or any other little endian platform.
Next-generation
Before we launched M5, you would use the XTTS v4 Perl script for such migrations.
We launched the latest version of the XTTS v4 Perl script many years ago. Over the last years, as databases grew bigger and bigger, we saw multiple issues with XTTS v4 Perl script, including:
- No multisection backups for bigfile tablespaces
- No encrypted tablespaces
- Inefficient parallelism
- Incomplete multitenant support
We wanted to solve all those issues with M5 – and we did! M5 uses newer RMAN functionality, and we made the procedure much simpler. It relies entirely on out-of-the-box RMAN functionality. On the source:
BACKUP ... TABLESPACE ... ;
On target we use:
RESTORE ALL FOREIGN DATAFILES ... ;
The latter command was introduced in Oracle Database 18c and enhanced in Oracle Database 19c. This means that the requirements for source and target database are:
- Oracle Database 19.18.0
- Data Pump Bundle Patch
Want to Know More?
We have a webinar later today about this new method. If you are interested, we still have open seats.
Cross Platform Migration – Transportable Tablespaces to the Extreme, February 22, 16:00 CET
Next week, we will add the recording to our YouTube channel. Be sure to subscribe so you don’t miss out on anything.
If you want a sneak peek at the slides, go ahead.
I have an elaborate blog post series about cross-platform migrations. I will soon update it with more information about the M5 migration method.
Happy Migrating!