Standby Creation using RMAN DUPLICATE Without Target And Recovery Catalog Connection (Doc ID 2011015.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Goal

Starting with RMAN11g Release 2 (11.2) RMAN is able to execute the duplicate command without connecting to the target database.  For disk backups, a recovery catalog is also not necessary.  However, if backups are on tape a recovery catalog is required.  

The information in this article will focus on disk backups and running duplicate with only an auxiliary connection.    

To complete an rman duplicate with only an auxiliary connection (no target and no catalog), rman needs the location of the backup sets which should be available on the auxiliary server.  RMAN reads the backup pieces and restores the spfile,controlfile,datafiles and archivelog files to complete the duplicate operation.

An example for this kind of duplicate operation is:

 

Solution

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