ORA-01115 IO error reading block from file

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01115: IO error reading block from file 92 (block # 39457)
ORA-01110: data file 92: '/opt/oracle/oradata/rundata/runvistadata218.dbf'
ORA-27072: File I/O error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 39457
Additional information: 12288

SQL> recover datafile 92;
ORA-00283: recovery session canceled due to errors
ORA-12801: error signaled in parallel query server P001
ORA-01115: IO error reading block from file 92 (block # 39455)
ORA-01110: data file 92: '/opt/oracle/oradata/rundata/runvistadata218.dbf'
ORA-27072: File I/O error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional informat

SQL> alter database datafile 92 offline drop;

Database altered.

SQL> alter database open;

Database altered.

SQL> select status from v$instance;

STATUS
------------------------
OPEN

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/563971/viewspace-660795/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/563971/viewspace-660795/