当前位置: 代码迷 >> Oracle技术 >> ORA-00376,ORA-01110异常
  详细解决方案

ORA-00376,ORA-01110异常

热度:67   发布时间:2016-04-24 08:31:54.0
ORA-00376,ORA-01110错误
小弟初学者,请教各位高手,我查询表的时候提示ORA-00376,ORA-01110错误。
ORA-00376:file 28 cannot be read at this time
ORA-01110:data file 28:'/home/oracle/oradatea/AAA/D_ACCAUD.dbf'
执行SQL> select file#,status from v$datafile;
显示
  FILE# STATUS
---------- --------------
  23 ONLINE
  24 ONLINE
  25 ONLINE
  26 ONLINE
  27 ONLINE
  28 RECOVER
  29 ONLINE
  30 ONLINE

SQL> recover datafile 28;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 28: '/home/oracle/oradata/AAA/D_ACCAUD.dbf'
ORA-01157: cannot identify/lock data file 28 - see DBWR trace file
ORA-01110: data file 28: '/home/oracle/oradata/AAA/D_ACCAUD.dbf'

请教各位高手这是个什么错误,如何解决呢?

------解决方案--------------------
探讨
小弟初学者,请教各位高手,我查询表的时候提示ORA-00376,ORA-01110错误。
ORA-00376:file 28 cannot be read at this time
ORA-01110:data file 28:'/home/oracle/oradatea/AAA/D_ACCAUD.dbf'
执行SQL> select file#,status from v$datafile……