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

 

posted @ 2019-06-03 11:01  高伟-林州  阅读(1315)  评论(0编辑  收藏  举报