My Oracle Support Banner

How to Restore Crossplatform Database from OMF to OMF Format Using Rman SET NEWNAME Command (Doc ID 1940303.1)

Last updated on MAY 31, 2024

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database 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:

Backup Location: D:\
Destination db_name: prod
Destination db_file_create_dest: /home/oracle
Destination control_files: /home/oracle/control_01.ctl
Destination backup location: /tmp
spool logfile name: /u01/app/setnewnamedf.lst
Redolog path on source server: D:\APP\ORADATA\V1124W
Redlog path, destination server: /home/app/oradata/V1124W



Documenting Procedures for moving a Windows 11gR2 (source) to Linux 11gR2 (target) database.


Source is in OMF format and the requirement is to restore to the destination Server in OMF format .

Crossplatform database restore is Involved.

For Crossplatform database restore db_file_create_dest alone does not ensure file gets restored in OMF format.

This Document is applicable only for platforms supported in below document

RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support  (Doc Id 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

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