RMAN DUPLICATE DATABASE with SET NEWNAME failed: RMAN-05501 RMAN-05517 (Doc ID 387093.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 7-Dec-2015***

Symptoms

Executing RMAN Duplicate , on same host as Target Database using
SET NEWNAME to redirect datafiles to new location.

SET NEWNAME has been specified for all datafiles for example like
following RMAN script:

RMAN> run {
allocate auxiliary channel a1 device type disk ;
SET NEWNAME for datafile 1 to 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUPL\SYSTEM01.DBF';
SET NEWNAME for datafile 2 to 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUPL\UNDOTBS01.DBF';
SET NEWNAME for datafile 3 to 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUPL\SYSAUX01.DBF';
SET NEWNAME for datafile 4 to 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUPL\USERS01.DBF';
SET NEWNAME for datafile 5 to 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUPL\EXAMPLE01.DBF';
SET NEWNAME for datafile 6 to 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUPL\USERS02.DBF';
SET NEWNAME for datafile 7 to 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUPL\DATA01.DBF';
#
# run the DUPLICATE command
# specify client-side parameter file for auxiliary instance if necessary
DUPLICATE TARGET DATABASE TO DUPL
PFILE = 'D:\oracle\product\10.2.0\admin\DUPL\pfile\initDUPL.ora'
UNTIL scn 22753868
LOGFILE
  GROUP 1 ('D:\oracle\product\10.2.0\oradata\DUPL\redo01a.log') SIZE 20M REUSE ,
  GROUP 2 ('D:\oracle\product\10.2.0\oradata\DUPL\redo02a.log') SIZE 20M REUSE ,
  GROUP 3 ('D:\oracle\product\10.2.0\oradata\DUPL\redo03a.log') SIZE 20M REUSE ;
}


This fails with Errors:
=======================
....
Starting Duplicate Db at 11-AUG-2006:14:20:47
Datafile 8 skipped by request
released channel: a1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/11/2006 14:20:52
RMAN-05501: aborting duplication of target database
RMAN-05517: temporary file D:\ORACLE\PRODUCT\10.2.0\ORADATA\D102\TEMP01.DBF conflicts with file used by target database

 

Cause

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