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 不知道该如何恢复
create another group by redo log then .
楼上的大侠 能否说的详细点 我oracle巨菜 还有我的三个redo log 使用rm 删除的
我现在启动数据库出现如下错误 不知道如何消除这种错误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
你的联机重做日志出了问题,那东西不能随便删除的。ORACLE里面至少需要有两个联机日志组,一般来说,每组里面还需要多个成员作镜像防止日志文件丢失。 先查询V$LOGFILE视图,看看你的数据库里面有几个联机日志组,出错的是哪一个。 如果能够用的有2个以上 就清除错误的组 ALTER DATABASE [database] CLEAR LOGFILE GROUP 2 如果少于两个,就要先创建新的联机重做日志组,然后再清除了。 ALTER DATABASE [database] ADD LOGFILE [GROUP integer] filespec [, [GROUP integer] filespec]...]
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.
你的方法我式过了 但是得到如下错误
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 不知道该如何恢复
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
先查询V$LOGFILE视图,看看你的数据库里面有几个联机日志组,出错的是哪一个。
如果能够用的有2个以上
就清除错误的组
ALTER DATABASE [database]
CLEAR LOGFILE GROUP 2
如果少于两个,就要先创建新的联机重做日志组,然后再清除了。
ALTER DATABASE [database]
ADD LOGFILE [GROUP integer] filespec
[, [GROUP integer] filespec]...]
Action Re-phrase the query to include only fixed objects, or open the database.