My Oracle Support Banner

RMAN 11GR2 : DUPLICATE Without Target And Recovery Catalog Connection (Doc ID 874352.1)

Last updated on JULY 31, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata 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.
***Checked for relevance on 10-Dec-2015***

Goal

Rman 11g release 2 provides us the flexibility of creating the rman duplicate without connecting to the target database and recovery catalog.

All rman needs here is the location of the backup pieces which is accessible and rman reads the backup pieces and restores the spfile,controlfile,datafiles and archivelog files to perform the duplicate operation.

An example for this kind of duplicate operation is:

RMAN> DUPLICATE DATABASE TO <auxiliary DB name>
                UNTIL TIME "TO_DATE('29-MAY-2010 14:16:42','DD-MON-YYYYHH24:MI:SS')"
                SPFILE
                 set control_files='D:\<aux path>\c1.ctl'
                 set db_file_name_convert='D:<target path>','D:<aux path>'
                 set log_file_name_convert='D:<target path>','D:<aux path>'
               BACKUP LOCATION 'D:\<location of backup on disk>';


# Here use of the BACKUP LOCATION clause identifies the type of duplication as having no target connection, no recovery catalog and being backup-based.

 

This is  a New Feature in 11gR2
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/wnbradv.htm#BRADV021
Oracle® Database Backup and Recovery User's Guide
11g Release 2 (11.2)
.
 What's New in Backup and Recovery?

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
 Process involved in this type of duplicate database
 The steps involved in creating the duplicate database are as follows

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