日期:2014-05-16  浏览次数:21535 次

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