RMAN复制数据库 RMAN-05517　错误

时间：2010-09-06 来源：todayboy

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

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')

参考：

相关阅读更多 +