今天在做坏块测试的时候,破坏数据数据块,然后进行数据文件恢复后,使用DBV测试也恢复正常。但就是读取数据文件里的数据时提示ora-00376。有人说重启数据库,但没用,我甚至OS也重启了,最后将数据文件OFFLINE,再ONLINE,问题解决
oracle@oracle10g[/home/oracle]dbv file='/tmp/test01.dbf'
DBVERIFY: Release 10.2.0.1.0 - Production on Mon Jul 29 13:50:09 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = /tmp/test01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 1280
Total Pages Processed (Data) : 20
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 12
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 1248
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 902693 (0.902693)
SQL> startup
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 1218460 bytes
Variable Size 79693924 bytes
Database Buffers 104857600 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> select count(*) from t1;
select count(*) from t1
*
ERROR at line 1:
ORA-00376: file 6 cannot be read at this time
ORA-01110: data file 6: '/tmp/test01.dbf'
SQL> alter database datafile 6 offline;
Database altered.
SQL> alter database datafile 6 online;
Database altered.
SQL> select count(*) from t1;
COUNT(*)
----------
10000
其他案例参考:
http://hi.baidu.com/mediinfodba/item/062cf3e637b5f91187d9de5b