My Oracle Support Banner

RMAN DUPLICATE / RESTORE including Standby in ASM with OMF / non-OMF / Mixed Name for Datafile / Online Log / Controlfile (Doc ID 1910175.1)

Last updated on SEPTEMBER 19, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
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 Backup Service - Version N/A and later
Information in this document applies to any platform.

Goal

The objective of this Document is to illustrate RMAN DUPLICATE / RESTORE / Manual Clone when source and destination (auxiliary) use ASM diskgroup for database files including OMF and/or non-OMF names.

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:

Database Names: PROD, UAT
Disk Groups: +DATA,+DATA01,+DATA02,+FRA
Disk Groups: +UATDATA,+UATDATA01,+UATDATA02,+UATFRA

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
 General Recommendations
 Background Concepts
 OMF in ASM
 Uniqueness of an ASM file
 File Name Conversion during Cloning
 Valid Format for DB_FILE_NAME_CONVERT / LOG_FILE_NAME_CONVERT
 Use Cases
 1) Handling of Control Files in ASM OMF format
 2) Handling of Control Files in ASM non-OMF format
 3) Handling of Control Files in Mixed Names format (OMF and non-OMF)
 4) All Datafiles in ASM OMF
 5) Datafiles in mixed format, some files in ASM OMF and some in non-OMF format
 6) All Redo Log members in ASM OMF format
 7) Redo Log members in mixed format, i.e. some in ASM OMF format and some in non-OMF format
 8) All Redo Log members in ASM non-OMF format
References

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