ORA-00376: file 88 cannot be read at this time

2010-08-02 07:26:43 327 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

ORA-00376：file x cannot be read at this time 之前出现过机房断电情况，重启数据库后发现出现ORA-00376的错误。通过查询数据文件状态： SQL> select file_id,online_status from dba_data_files order by 1; FILE_ID ONLINE_STATUS ---------- ------------- 1 SYSTEM 阅读详情



ORA-01171: datafile 88 going offline due to error advancing checkpoint

ORA-01122: database file 88 failed verification check

ORA-01110: data file 88: '/u01/oracle/app/oradata/orcl/test01.dbf'

ORA-01251: Unknown File Header Version read for file number 88





  在这之前 执行了：

BBED> info

 File#  Name                                                        Size(blks)

 -----  ----                                                        ----------

    88  /u01/oracle/app/oradata/orcl/test01.dbf                           6400



BBED> modify 22 55



然后  

SQL>alter system checkpoint;



SQL> conn test/test

Connected.

SQL> select count(*) from test.t1;

select count(*) from test.t1

*

ERROR at line 1:

ORA-00376: file 88 cannot be read at this time

ORA-01110: data file 88: '/u01/oracle/app/oradata/orcl/test01.dbf'