本文介绍了如何处理Oracle数据库启动时遇到的ORA-00313, ORA-00312, ORA-27037错误，该错误由联机日志文件损坏引起。通过模拟环境，展示了从删除日志到切换、清除、恢复和重新打开数据库的一系列步骤，最终成功恢复数据库并修复日志问题。"
118403810,1522755,Rust实现CSV解析与序列化：TSV与Serde,"['rust', 'csv', '解析器', 'serde']
天萃荷净
运维DBA反映Oracle数据库在启动时报错ORA-00313 ORA-00312 ORA-27037，分析原因为数据库redo联机日志文件损坏导致
环境模拟
删除状态为active的联机日志，然后强行关闭数据库
1.数据库报错ORA-00313 ORA-00312 ORA-27037
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1260720 bytes
Variable Size 142607184 bytes
Database Buffers 16777216 bytes
Redo Buffers 7127040 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘/u01/oradata/xienfei/redo01.log’
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Alert.log 日志中错误
Wed Aug 24 00:26:33 2011
Errors in file /u01/admin/xienfei/udump/xff_ora_9186.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘/u01/oradata/xienfei/redo01.log’
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
xff_ora_9186.trc文件中错误
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘/u01/oradata/xienfei/redo01.log’
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
查询当前日志组状态
SQL> select a.
最低0.47元/天 解锁文章
扫一扫
1223
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
