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

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

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

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 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