My Oracle Support Banner

Cross-Platform Database Migration (across same endian) using RMAN backupset in 12c (Doc ID 2013540.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

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.