ORA-15005: name "orcl" is already used by an existing alias

958317280

　　在进行ASM操作的时候，如果目录不存在的话，那么可能会报如下的错误：
　　<pre name=&quot;code&quot; class=&quot;plain&quot;>RMAN> backup as copy database format '+kel/or';
Starting backup at 13-JUN-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/home/oracle/oradata/ipap/system01.dbf
output filename=+KEL/or tag=TAG20140613T002201 recid=16 stamp=850090987
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:16
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/home/oracle/oradata/ipap/sysaux01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/13/2014 00:23:20
ORA-19504: failed to create file &quot;+KEL/or&quot;
ORA-17502: ksfdcre:4 Failed to create file +KEL/or
ORA-15005: name &quot;or&quot; is already used by an existing alias

但是在查看文件的时候，这个文件却已经创建了




ASMCMD> ls -l
Type      Redund  Striped  Time             Sys  Name
Y    IPAP/
N    or => +KEL/IPAP/DATAFILE/SYSTEM.257.850090925

文件创建做的好像是一个链接，但是这个备份应该没有做完，因为在创建第一个文件的时候就开始报错。　　
　　有人说配置控制文件自动进行备份即可，从而进行配置：
　　RMAN> configure controlfile autobackup on;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

但是发现依然报错
　　在进行直接备份的时候是OK的，也就是不添加不存在的文件夹，直接来进行备份，如下：
　　


　　RMAN> backup as copy database format '+KEL';
Starting backup at 13-JUN-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/home/oracle/oradata/ipap/system01.dbf
output filename=+KEL/ipap/datafile/system.257.850091431 tag=TAG20140613T003030 recid=17 stamp=850091498
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/home/oracle/oradata/ipap/sysaux01.dbf
output filename=+KEL/ipap/datafile/sysaux.256.850091507 tag=TAG20140613T003030 recid=18 stamp=850091538
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/home/oracle/oradata/ipap/undotbs01.dbf
output filename=+KEL/ipap/datafile/undotbs1.258.850091543 tag=TAG20140613T003030 recid=19 stamp=850091544
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/home/oracle/oradata/ipap/users01.dbf
output filename=+KEL/ipap/datafile/users.259.850091545 tag=TAG20140613T003030 recid=20 stamp=850091545
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 13-JUN-14
Starting Control File and SPFILE Autobackup at 13-JUN-14
piece handle=/home/oracle/flash_recovery_area/IPAP/autobackup/2014_06_13/o1_mf_s_850091546_9sob8ck2_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 13-JUN-14

创建一个文件夹，再次来进行备份发现还是不行的。。。只能直接备份在ASM磁盘组中，而不能指定文件夹：
　　RMAN> backup as copy database format '+kel/test';
Starting backup at 13-JUN-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/home/oracle/oradata/ipap/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/13/2014 00:43:51
ORA-19504: failed to create file &quot;+KEL/test&quot;
ORA-17502: ksfdcre:4 Failed to create file +KEL/test
ORA-15005: name &quot;test&quot; is already used by an existing alias


　　



版权声明：本文为博主KEL原创文章，未经KEL允许不得转载。