ORA-01580
Oracle11g RAC 一次生产的RMAN备份报错，错误信息大致如下（以下信息为测试环境模拟的）：
|
1 2 3 4 5 6 7 8 |
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/29/2014 16:12:47 ORA-01580: error creating control backup file /u01/app/oracle/product/11.2.0/db_1/dbs/DATA/RAC11G/SNAPSHOT/snapcf_RAC11G.f ORA-27040: file create error, unable to create file Linux-x86_64 Error: 2: No such file or directory Additional information: 1 |
这个错误从字面上看，就是生成控制文件快照的时候，无法创建，没有找到相应的目录。既然是这个错误，那么我们查看一下RMAN的配置信息，如下：
|
1 2 3 4 5 6 |
RMAN> show SNAPSHOT CONTROLFILE NAME; RMAN configuration parameters for database with db_unique_name RAC11G are: CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'DATA/RAC11G/SNAPSHOT/snapcf_RAC11G.f'; RMAN> |
我们看控制文件快照的配置信息改动过，默认情况下是放在本地文件系统中，现在改为存放在共享存储中，乍一看似乎没什么问题，仔细看，磁盘组前没有写“+”
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/RAC11G/SNAPSHOT/snapcf_RAC11G.f'; old RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'DATA/RAC11G/SNAPSHOT/snapcf_RAC11G.f'; new RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/RAC11G/SNAPSHOT/snapcf_RAC11G.f'; new RMAN configuration parameters are successfully stored RMAN> RMAN> show SNAPSHOT CONTROLFILE NAME; RMAN configuration parameters for database with db_unique_name RAC11G are: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/RAC11G/SNAPSHOT/snapcf_RAC11G.f'; RMAN> |
OK，修改完毕后，解决了这个由于操作不仔细而发生的错误。