Oracle数据库失败由于 ORA-63999 ORA-01114 和ORA-27061 但未发现损坏

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：[email protected]

ORA-01114
oerr ora 1114
01114, 00000, "IO error writing block to file %s (block # %s)"
// *Cause:  The device on which the file resides is probably offline. If the 
//          file is a temporary file, then it is also possible that the device
//          has run out of space. This could happen because disk space of
//          temporary files is not necessarily allocated at file creation time.
// *Action: Restore access to the device or remove unnecessary files to free
//          up space.


ORA-63999

oerr ora 63999
63999, 00000, "data file suffered media failure"
// *Cause:  A data file was detected as inaccessible due to media failure.
// *Action: Restore accessibility to the file mentioned in the error stack
//          and restart the instance.



ORA-27061
oerr ora 27061
27061, 00000, "waiting for async I/Os failed"
// *Cause:  aiowait function returned error
// *Action: check errno

适用于：

Oracle Database – Enterprise Edition –版本 11.2.0.1 及以上
本文信息适用于任何平台。
** Checked for Currency 03/11/2014 **

症状

由于这些错误，数据库崩溃且无法启动。数据库在一个NAS上。Unix团队未找到关于NAS的任何问题。

Mon Apr 29 18:50:48 2013
KCF: read, write or open error, block=0x1b70 online=1
file=3 ‘/databases/oemdev12c/undotbs01.dbf’
error=27061 txt: ‘Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 131072’
Errors in file /usr/local/oracle/diag/rdbms/oemdev12c/oemdev12c/trace/oemdev12c_dbw0_5508.trc:
Errors in file /usr/local/oracle/diag/rdbms/oemdev12c/oemdev12c/trace/oemdev12c_dbw0_5508.trc:
ORA-63999: data file suffered media failure
ORA-01114: IO error writing block to file 3 (block # 7024)
ORA-01110: data file 3: ‘/databases/oemdev12c/undotbs01.dbf’
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 131072
DBW0 (ospid: 5508): terminating the instance due to error 63999

Additional Information:
NAME TYPE VALUE
———————————— ———– ——————————
filesystemio_options string setall
disk_asynch_io boolean TRUE

更改

Unix系统管理员在操作系统级别执行了一些更改

原因

这些是I/O 错误：

ORA-01114: IO error writing block to file 3 (block # 7024)
ORA-01110: data file 3: ‘/databases/oemdev12c/undotbs01.dbf’
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error

RMAN validate检查逻辑数据库未发现任何问题， 所以该问题是Oracle外部的。
解决方案

执行一个操作系统检查，并确保NAS被正确mount。
fstab从一开始的：

fasaud08a:/vol/oemdbaud01_archive/archive /archive nfs defaults 0 0
fasaud08a:/vol/oemdbaud01_data/databases /databases nfs defaults 0 0
fasaud08a:/vol/oemdbaud01_oracle/oracle /usr/local/oracle nfs defaults 0 0

更改为：

fasaud08a:/vol/oemdbaud01_archive/archive /archive nfs hard,intr,rw,rsize=32768,wsize=32768,suid,proto=tcp,vers=3 0 0
fasaud08a:/vol/oemdbaud01_data/databases /databases nfs hard,intr,rw,rsize=32768,wsize=32768,suid,proto=tcp,vers=3 0 0
fasaud08a:/vol/oemdbaud01_oracle/oracle /usr/local/oracle nfs hard,intr,rw,rsize=32768,wsize=32768,suid,proto=tcp,vers=3 0 0

在进行更改之前unmount mount points并在更改之后mount它们。
参考

NOTE:1323649.1 – Known Corruption issues caused by 3rd party Software/Hardware Provider