oracle ora 00279,ORA-00376错误解决案例

今天开始磁盘空间100%，删完日志后，查询表遇到ORA-00376错误：

SQL> select count(*) from

tab_test;

ORA0-00376: "file '/data1/oradata/e_data1.dbf'

cannot be read at this time"

重启数据库没有问题，数据文件都能打开。

[oracle@game ~]$ oerr ora

376

00376, 00000, "file %s cannot be read at this time"

// *Cause: attempting to read from a file that is not readable.

Most likely

// the file is offline.

// *Action: Check the state of the file. Bring it online

[oracle@game ~]$

经检查，操作系统下数据文件属性正常，磁盘空间正常。

怀疑数据文件有问题：

SQL> select file#,status from

v$datafile;

FILE# STATUS

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

1 SYSTEM

2 ONLINE

3 ONLINE

4 ONLINE

5 RECOVER

6 ONLINE

7 ONLINE

8 ONLINE

8 rows selected.<