如果自己搞不定可以找诗檀软件专业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 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
Comment