ORA-01219: database not open: queries allowed on fixed tables/views only

[dippa]

数据库已经启动，
SQL> conn as sysoper
Enter user-name: back
Enter password:
Connected.

但是执行查询时出现错误
ORA-01219: database not open: queries allowed on fixed tables/views only

上网查了半天 都没有解决 不知何故 郁闷异常 烦请高手指点

[skytears]

connect system/manager;
alter database open;

[yuanscar]

你的数据库可能只打开到MOUNT状态，这样可以查询一些固定的视图，比如动态性能视图。但不能对数据库的数据进行查询和操作。向楼上所说的就行了，不过可能是因为别的原因不能启动到OPEN状态，你试一下好了

[dippa]

to skytears(苦) :
你的方法我式过了 但是得到如下错误
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle/oradata/bbc/redo02.log'
ORA-27037: unable to obtain file status

哦 对了 先前我删除了 三个 redo log 不知道该如何恢复

[black_snail]

create another group by redo log then .

[dippa]

楼上的大侠 能否说的详细点 我oracle巨菜

还有我的三个redo log 使用rm 删除的

[dippa]

我现在启动数据库出现如下错误 不知道如何消除这种错误

SQL> startup
ORACLE instance started.

Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle/oradata/bbc/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

[yuanscar]

你的联机重做日志出了问题，那东西不能随便删除的。ORACLE里面至少需要有两个联机日志组，一般来说，每组里面还需要多个成员作镜像防止日志文件丢失。
先查询V$LOGFILE视图，看看你的数据库里面有几个联机日志组，出错的是哪一个。
如果能够用的有2个以上
就清除错误的组
ALTER DATABASE [database]
CLEAR LOGFILE GROUP 2
如果少于两个，就要先创建新的联机重做日志组，然后再清除了。
ALTER DATABASE [database]
ADD LOGFILE [GROUP integer] filespec
[, [GROUP integer] filespec]...]

[xunx]

ORA-01219 database not open: queries allowed on fixed tables/views only

Cause A query was issued against an object not recognized as a fixed table or fixed view before the database has been opened.
Action Re-phrase the query to include only fixed objects, or open the database.