My Oracle Support Banner

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 12.1.0.1 to 12.2.0.1 [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.


Goal

Disclaimer:

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:
source  Database:source

 

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.

Solution

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
Goal
Solution
 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
References

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