ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01115 IO error reading block from file

ORA-01115 IO error reading block from file

原创 Linux操作系统 作者:kris3106 时间:2010-04-26 15:42:34 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: TNS-00515
请登录后发表评论 登录
全部评论

注册时间:2008-04-07

  • 博文量
    93
  • 访问量
    190287