DG duplicate报错:RMAN-05001:auxiliary file name /u01/app/oracle/oradata/fratbs01.dbf conflicts with a file used by the target database
阅读原文时间:2023年07月10日阅读:2

问题:rman duplicate时报错:

RMAN-05001:auxiliary file name /u01/app/oracle/oradata/fratbs01.dbf conflicts with a file used by the target database

分析:应该是主库的这个数据文件位置没有在参数里面做转换

解决:

1)更改参数DB_FILE_NAME_CONVERT

查看原来参数配置:(vi initSBDB1.dbf)

DB_FILE_NAME_CONVERT='SBDB1','PROD1'      (默认所有的主备库路径

把报错数据文件文件转换加入DB_FILE_NAME_CONVERT

更改为:DB_FILE_NAME_CONVERT='SBDB1','PROD1','/u01/app/oracle/oradata','/u01/app/oracle/oradata/SBDB1'

2)把备库关闭,创建spfile文件,重启到nomount状态

shu immediate;                      create spfile from pfile;          startup nomount;

3)主库重新执行duplicate命令,成功

rman target / auxiliary sys/oracle@sbdb1

duplicate target database for standby from active database;