Cross-Platform Database Migration (across same endian) using RMAN backupset in 12c
(Doc ID 2013540.1)
Last updated on JULY 01, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.1 to 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
Goal of this article is to help perform cross platform database migration between two operating system platforms belonging to the same endian format using 12c Cross-Platform Database Transport with rman backup sets.
For certain cross platform migration, direct restore and recovery from Rman backupset is possible. For these platforms, you can directly perform RMAN duplication (active or backup-based) or RMAN restore/recover without any conversion. Please refer the below document for information about the same:
<Note 1079563.1> RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support
The goal of this document is to explain cross platform database migration between Solaris Operating System (x86-64) and Microsoft Windows x86 64-bit which is not covered under mixed platform support document 1079563.1.
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
|Step 1: Connect to Source database and open it read only|
|Step2: Take backup of the Source database :|
|Step 3: On the destination server (Windows) create the pfile and the oracle service|
|Step 4: Restore the database from the backup|
|Step 5: Get the controlfile recreation script from the source database Solaris taken in step 2|
|Step 6: Alter the database open resetlogs|