ORA-00313: open failed for members of log group

最新推荐文章于 2023-04-18 00:52:44 发布

cikuaizhen9509

最新推荐文章于 2023-04-18 00:52:44 发布

阅读量356

点赞数

文章标签：数据库

本文记录了Oracle数据库中出现的ORA-00313和ORA-27037错误，涉及日志文件standbyredo04.log至standbyredo07.log无法打开或不存在的问题，并给出了通过删除故障日志组的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '/opt/oracle/oradata/xxxdb/standbyredo04.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
CJQ0 started with pid=18, OS id=13456
Thu Jul 15 21:00:02 2010
Errors in file /opt/oracle/admin/xxxdb/bdump/xxxdb_arc2_13450.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '/opt/oracle/oradata/xxxdb/standbyredo05.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Thu Jul 15 21:00:03 2010
Errors in file /opt/oracle/admin/xxxdb/bdump/xxxdb_arc2_13450.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/opt/oracle/oradata/xxxdb/standbyredo06.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Thu Jul 15 21:00:04 2010
Errors in file /opt/oracle/admin/xxxdb/bdump/xxxdb_arc2_13450.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '/opt/oracle/oradata/xxxdb/standbyredo07.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

select * from v$log;
select group#, sequence#, bytes, members, status from v$log;

column MEMBER format a50
select * from v$logfile;

ALTER DATABASE DROP LOGFILE GROUP 4;
ALTER DATABASE DROP LOGFILE GROUP 5;
ALTER DATABASE DROP LOGFILE GROUP 6;
ALTER DATABASE DROP LOGFILE GROUP 7;

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

转载于:http://blog.itpub.net/77164/viewspace-668188/