Standby Creation using RMAN DUPLICATE Without Target And Recovery Catalog Connection
Last updated on MARCH 10, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
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:
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