回滚的问题

[yun198183]

日志里面会报一下错误

java.sql.SQLException: ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: '/app/oracle/9.2/dbs/undodbs03.dbf'

plsql打开一张表也会报同样错误....有谁能帮我

[zhpsam109]

ORA-00376 file string cannot be read at this time

Cause: An attempt was made 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.

[bm1408]

首先看一下文件在吗?
是否offline?

[ruihuahan]

undo 表空间有问题了。

[SYUEHOKO]

路过..学习.

[qiyousyc]

undodbs03.dbf这个数据文件好像是offline的
或者这个文件出现了问题。
看下这个文件的状态。

[多壮志]

不好说，第一的反应，可能是磁盘错误。如果是这样就很难处理。
如果仅仅是off line那是比较好处理。使用alter tablespace xxx datafile online/offline
，但是如果你的数据库本来就出于非归档模式，那么磁盘问题的可能性居多。