Perform Backup Based RMAN DUPLICATE Without Connecting To Target Database For Both Disk & Tape Backups (Doc ID 1375864.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
*** Check on currency 10-Dec-2015 ***

Goal

If you are performing a backup based RMAN duplicate and using a recovery catalog as well, it is not required to connect to the source database as TARGET in RMAN.

This technique is advantageous where network connections from the auxiliary host to the source database are restricted or prone to intermittent disruptions. In duplication without a TARGET connection, the source database is unaffected by the duplication.

For this RMAN duplication, we will connect rman to the auxiliary instance and recovery catalog database and run duplicate command similar to below:

duplicate database ora11gR2 dbid 82843743 to dup11gR2
  until scn 274615
  db_file_name_convert 'ora11gR2','dup11gR2'
  spfile
  parameter_value_convert 'ora11gR2','dup11gR2'
  set log_file_name_convert 'ora11gR2','dup11gR2';


Section below has more details regarding the complete step by step procedure. Note that:

a) We can use this technique for both disk as well as tape (sbt) backups.

b) Use of recovery catalog is mandatory

c) If you do not have a recovery catalog, you can still perform RMAN DUPLICATE without connecting to the target database but ONLY for disk backups. This is achieved via BACKUP LOCATION clause of DUPLICATE command i.e.
DUPLICATE DATABASE TO dupdb
  UNTIL TIME "TO_DATE('11/01/2007 14:00:00', 'MM/DD/YYYY HH24:MI:SS')"
  SPFILE
  BACKUP LOCATION '/prod_backups'
  NOFILENAMECHECK;

Below document has more details for this procedure:
(Doc ID 874352.1) RMAN 11GR2 : DUPLICATE Without Target And Recovery Catalog Connection

#

 

Additional Note: Targetless DUPLCIATE at same HOST as TARGET

 If you are using TARGETLESS Duplicate using 'BACKUP LOCATION' on the same Host/Node as the Target exist
 Then you must make sure that no existing files from TARGET are overwritten.
 This is done by CONVERT Parameters as shown, but you must also ensure to get controlfile to a unique location
 so using -> set control_files='<unique-path-location-name>'   in SPFILE clause
 .
 Otherwise it is possible that this error might be encountered because rman will restore
 the spfile and then the control_files setting would point to the source/target db controlfile:
 
 RMAN-06136: ORACLE error from auxiliary database: ORA-00600: internal error code, arguments: [kccsbck_first], [2], [4191010098], [], [],
 
 
Example:

run {
allocate auxiliary channel ch1 type disk;
duplicate database ora11gR2 dbid 82843743 to dup11gR2
  until scn 274615
  db_file_name_convert 'ora11gR2','dup11gR2'
  spfile
  parameter_value_convert 'ora11gR2','dup11gR2'
  set control_files '/oradata/dup11gR2/control01.ctl'
  set log_file_name_convert 'ora11gR2','dup11gR2';
}

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