问题: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/[email protected]
duplicate target database for standby from active database;