RMAN> run {
2> set newname for datafile 1 to '/u01/oracle/oradata/hanmi/system01.dbf';
3> set newname for datafile 2 to '/u01/oracle/oradata/hanmi/undotbs01.dbf';
4> set newname for datafile 3 to '/u01/oracle/oradata/hanmi/sysaux01.dbf';
5> set newname for datafile 4 to '/u01/oracle/oradata/hanmi/users01.dbf';
6> set newname for datafile 5 to '/u01/oracle/oradata/hanmi/bjhanmi01.dbf';
7> set newname for datafile 6 to '/u01/oracle/oradata/hanmi/gsp01.dbf';
8> set newname for datafile 7 to '/u01/oracle/oradata/hanmi/unia01.dbf';
9> set newname for datafile 8 to '/u01/oracle/oradata/hanmi/sfa01.dbf';
10> set newname for datafile 9 to '/u01/oracle/oradata/hanmi/rmkunia01.dbf';
11> set newname for datafile 10 to '/u01/oracle/oradata/hanmi/hmp01.dbf';
12> duplicate target DATABASE TO hanmi LOGFILE
13> '/u01/oracle/oradata/redo01' size 200m,
14> '/u01/oracle/oradata/redo02' size 200m,
15> '/u01/oracle/oradata/redo03' size 200m;
16> }

executing command: SET NEWNAME
using target database control file instead of recovery catalog

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at 06-SEP-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=541 devtype=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: sid=540 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/06/2010 13:50:24
RMAN-05501: aborting duplication of target database
RMAN-05517: temporary file /u01/app/oracle/oradata/hanmi/temp01.dbf conflicts with file used by target database
 解决的方法：

在pfile中加入：

*.db_file_name_convert=('/u01/app/oracle/oradata/hanmi/','/u01/oracle/oradata/hanmi')
*.log_file_name_convert=('/u01/app/oracle/oradata/hanmi/','/u01/oracle/oradata/hanmi')
 

 

 

参考：http://onlinedbasupport.com/content/forum/rman-05517-when-duplicating-database

I am getting the below error message when trying to create a duplicate database using rman backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/07/2010 18:28:47
RMAN-05501: aborting duplication of target database
RMAN-05517: temporary file /oracle/product/10.2.0/oradata/orcl/temp01.dbf conflicts with file used by target database

RMAN> **end-of-file**

Soln :

Add db_file_name_covert in pfile and restart the instance

*.db_file_name_convert=('/oracle/product/10.2.0/oradata/orcl/','/oracle/product/10.2.0/oradata/clone')
*.log_file_name_convert=('/oracle/product/10.2.0/oradata/orcl/','/oracle/product/10.2.0/oradata/clone')