RMAN 11GR2 : DUPLICATE Without Target And Recovery Catalog Connection

(Doc ID 874352.1)

Last updated on JANUARY 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***


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:

                UNTIL TIME "TO_DATE('29-MAY-2010 14:16:42','DD-MON-YYYYHH24:MI:SS')"
                 set control_files='D:\dup11r2\c1.ctl'
                 set db_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2'
                 set log_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2'
               BACKUP LOCATION 'D:\dup11r2';

# 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
Oracle® Database Backup and Recovery User's Guide
11g Release 2 (11.2)
 What's New in Backup and Recovery?


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms