【RMAN】RMAN-05001: auxiliary filename conflicts with the target database ╰+哭是因爲堅強的太久メ 2022-09-29 00:24 40阅读 0赞 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 03/10/2017 18:22:21 RMAN-05501: aborting duplication of target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/t02.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/t01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/users01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/undotbs01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/sysaux01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/system01.dbf conflicts with a file used by the target database 如果在RMAN恢复时不指定 nofilenamecheck 参数,则在数据文件相同文件名恢复时会出现RMAN-05501错误,当主库,备库的数据库文件目录是一样的时候,必须使用 nofilenamecheck参数告诉rman主库和被创建的备份库拥有一样的文件目录和文件名。 $ rman targetsys/oracle@orcl auxiliary sys/oracle@orcldg Recovery Manager:Release 11.2.0.4.0 - Production on Mon Jun 27 03:19:00 2016 Copyright (c) 1982,2011, Oracle and/or its affiliates. Allrights reserved. connected to targetdatabase: ORCL (DBID=1443368985) connected toauxiliary database: ORCL (not mounted) RMAN> run \{ allocate channelprmy1 type disk; allocate channelprmy2 type disk; allocate channelprmy3 type disk; allocate channelprmy4 type disk; allocateauxiliary channel stby1 type disk; allocateauxiliary channel stby2 type disk; allocateauxiliary channel stby3 type disk; allocateauxiliary channel stby4 type disk; duplicate targetdatabase for standby from active database nofilenamecheck; \}
还没有评论,来说两句吧...