ORA-19504: failed to create file "/u01/backup/db_0_20190603_1" ORA-27038: created file already exists
1.问题:在用rman进行0级备份时,报错:
ORA-19504: failed to create file "/u01/backup/db_0_20190603_1"
ORA-27038: created file already exists
2.通过报错,可以看到是文件重复:created file altready exists
3.查看备份脚本:
RMAN> backup incremental level 0 database format '/u01/backup/db_0_%T_%p';
4.查看backup的目录权限和属主情况:(属主和属组分别是:Oracle oinstall ,没问题)
drwxr-xr-x 2 oracle oinstall 4096 Jun 3 10:21 backup
5.通过metalink搜索类似报错,是因为我没有加%U,所以rman备份文件命名时重复了,修改rman备份语句为:
RMAN> backup incremental level 0 database format '/u01/backup/%U_db_0_%T_%p';
6.问题解决,没有报错,并且/backup目录下生成了两个不同的备份文件
[oracle@enmoedu1 backup]$ ls
03u35nms_1_1_db_0_20190603_1 04u35nom_1_1_db_0_20190603_1