ora-19624 ora-19502 ora-27040

最新推荐文章于 2025-06-27 09:42:42 发布

原创最新推荐文章于 2025-06-27 09:42:42 发布 · 3.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

Oracle Basic 专栏收录该内容

20 篇文章

订阅专栏

在Oracle 11.2.0.1 RAC环境中，遇到ORA-19624、ORA-19504和ORA-27040错误，问题源于尝试在非共享路径/home/oracle/backup/创建控制文件备份。解决方案包括将备份路径改为共享存储或手动备份控制文件。

数据库环境：
oracle 11.2.0.1 rac(两个节点)
centos 6.5
netapp存储
alert.log
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_m000_19756.trc:
ORA-19624: operation failed, retry possible
ORA-19504: failed to create file “/home/oracle/backup/onlinebak/1606152110/c-1422707784-20160615-02”
ORA-27040: file create error, unable to create file
错误分析
报错之前在node02上做rman群备份，操作如下：

configure controlfile autobackup format for device type disk to '/home/oracle/backup/onlinebak/1606152110/%F';
run{
    allocate channel ch1 device type disk format = '/home/oracle/backup/onlinebak/1606152110/%U';
    backup as compressed backupset database;
    release channel ch1;
}

在node01上添加redo，操作如下：

alter database add logfile thread 1 group 5 ('+DATA/orcl/onlinelog/redo05_01.log','+OCR/redo/redo05_02.log')  size 100M;
alter database add logfile thread 2 group 6 ('+DATA/orcl/onlinelog/redo06_01.log','+OCR/redo/redo06_02.log')  size 100M;
alter database add logfile thread 1 group 7 ('+DATA/orcl/onlinelog/redo07_01.log','+OCR/redo/redo07_02.log')  size 100M;
alter database add logfile thread 2 group 8 ('+DATA/orcl/onlinelog/redo08_01.log','+OCR/redo/redo08_02.log')  size 100M;

日志切换到group 05上后出现错误

[oracle@rac1 trace]$ oerr ora 19624
19624, 00000, "operation failed, retry possible"
// *Cause:  A backup, restore or image copy operation failed with an I/O
//          error.  If the source of the I/O error can be corrected, then
//          the operation may be retried.
// *Action: This message is used by recovery manager to decide whether or not
//          to retry the operation.

开启了自动控制文件备份，添加日志的操作会修改控制文件信息，因此数据库会帮助我们做控制文件的自动备份，从错误的信息来看备份的名称为/home/oracle/backup/onlinebak/1606152110/c-1422707784-20160615-02，但是在orcl1上没办法访问到该路径，因此报错。
解决办法
1、可以把备份的路径该到共享存储上；
2、手动备份控制文件；