ORA-00376 运气不好，遭遇这个

今天下午，User突然反应数据都没法删除，收到他们的截图看，是

ORA-00376 file 2 cannot be read at this time

[@more@]

然后file 2 是什么呢，一看是UNDO…

去Alert.log看了下：

CF: write/open error block=0x69 online=1

file=5 /data2/hhsas/undotbs02.dbf

file=2 /data1/hhsas/undotbs01.dbf

error=27061 txt: 'Linux-x86_64 Error: 30: Read-only file system

error=27061 txt: 'Linux-x86_64 Error: 30: Read-only file system

Additional information: -1

Additional information: -1

Additional information: 8192'

Additional information: 8192'

Automatic datafile offline due to write error on

file 2: /data1/hhsas/undotbs01.dbf

……

Select file#,status from v$datafile 看了下

Datafile 2是recover的.

OK.

先新建UNDOTBS2 然后把系统UNDO设定切过去，但是User还是不能作DML,

出现

ORA-20119: ORA-01552: cannot use system rollback segment for non-system tablespace 'TT'

看来还没完。直接进行恢复。

alter database datafile 2 offline;

从Physical Standby上COPY 过来出问题的datafile;

SQL> recover datafile 2;

Media recovery complete.

SQL> alter database datafile 2 online;

Database altered.

SQL> alter system archive log current;

System altered.

接下来让测试DML, OK…

下面就去查那个该死的'Linux-x86_64 Error: 30: Read-only file system 到底出了什么问题…

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10856805/viewspace-1033059/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10856805/viewspace-1033059/