ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'X:\ORACLE\ORADATA\LIT3E2\REDO03.LOG' ORA-27088: skgfglk: unable to get file status OSD-04002: 无法打开文件 O/S-Error: (OS 8) 存储空间不足,无法处理此命令。呵呵,说地对啊!! 有时真的很难找出原因 谢了。ern哥。
报的错误是can not alloate new log
然后LGWR进程就把instance terminated 掉了..
下面是log信息
ARC2: Beginning to archive log# 3 seq# 48528
ARC2: Completed archiving log# 3 seq# 48528
Tue May 23 14:22:52 2006
Thread 1 cannot allocate new log, sequence 48530
Checkpoint not complete
Current log# 1 seq# 48529 mem# 0: X:\ORACLE\ORADATA\LIT3E2\REDO01.LOG
Thread 1 advanced to log sequence 48530
Tue May 23 14:22:54 2006
ARC1: Beginning to archive log# 1 seq# 48529
Tue May 23 14:22:54 2006
Current log# 2 seq# 48530 mem# 0: X:\ORACLE\ORADATA\LIT3E2\REDO02.LOG
Tue May 23 14:22:54 2006
ARC1: Completed archiving log# 1 seq# 48529
Tue May 23 14:24:12 2006
Errors in file x:\oracle\admin\lit3e2\bdump\lit3e2LGWR.TRC:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'X:\ORACLE\ORADATA\LIT3E2\REDO03.LOG'
ORA-27088: skgfglk: unable to get file status
OSD-04002: 无法打开文件
O/S-Error: (OS 8) 存储空间不足,无法处理此命令。Tue May 23 14:24:12 2006
LGWR: terminating instance due to error 313
Tue May 23 14:24:16 2006
Errors in file x:\oracle\admin\lit3e2\udump\ORA05920.TRC:
ORA-00313: 无法打开日志组 (线程 ) 的成员Instance terminated by LGWR, pid = 3660
Dump file x:\oracle\admin\lit3e2\bdump\lit3e2ALRT.LOG
Tue May 23 14:42:10 2006
ARC2: Completed archiving log# 3 seq# 48528
Tue May 23 14:22:52 2006
Thread 1 cannot allocate new log, sequence 48530--------------------这里开始出问题
Checkpoint not complete
Current log# 1 seq# 48529 mem# 0: X:\ORACLE\ORADATA\LIT3E2\REDO01.LOG
Thread 1 advanced to log sequence 48530
Tue May 23 14:22:54 2006
ARC1: Beginning to archive log# 1 seq# 48529
Tue May 23 14:22:54 2006
Current log# 2 seq# 48530 mem# 0: X:\ORACLE\ORADATA\LIT3E2\REDO02.LOG
Tue May 23 14:22:54 2006
ARC1: Completed archiving log# 1 seq# 48529
Tue May 23 14:24:12 2006
Errors in file x:\oracle\admin\lit3e2\bdump\lit3e2LGWR.TRC:---------
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'X:\ORACLE\ORADATA\LIT3E2\REDO03.LOG'
ORA-27088: skgfglk: unable to get file status
OSD-04002: 无法打开文件
O/S-Error: (OS 8) 存储空间不足,无法处理此命令。Tue May 23 14:24:12 2006
LGWR: terminating instance due to error 313-------------然后就terminate 了 instance.
Tue May 23 14:24:16 2006
Errors in file x:\oracle\admin\lit3e2\udump\ORA05920.TRC:
ORA-00313: 无法打开日志组 (线程 ) 的成员Instance terminated by LGWR, pid = 3660
Dump file x:\oracle\admin\lit3e2\bdump\lit3e2ALRT.LOG
Tue May 23 14:42:10 2006..
发生这样的问题,怎么向老板报告啊....我实在是想不出原因...
如果是空间的问题,我recover database后,岂不是空间也不够,可是目前还没有问题,database还在跑..
tablespace 和datafile都有autoextend..
为什么突然日志文件不能allocate了...
你说的分区,我不是很明白.log group 3 的大小为1MB,如果是分区的问题,请能够详细一点说明吗? 谢谢了.
还有,这个文件是否可能有别人上来修改了
Thread 1 cannot allocate new log, sequence 48530--------------------这里开始出问题
Checkpoint not complete
Current log# 1 seq# 48529 mem# 0: X:\ORACLE\ORADATA\LIT3E2\REDO01.LOG
Thread 1 advanced to log sequence 48530
这里应该没问题,只是你没完成checkpoint,造成系统无法做log switch,等待了一点时间而已,后来还是成功切换到1了
Tue May 23 14:24:12 2006
Errors in file x:\oracle\admin\lit3e2\bdump\lit3e2LGWR.TRC:---------问题是在这里,归档完1之后你从2开始切换到3,同时准备开始归档2,这时候3无法被打开写入,可能是3被损坏了
不过你有归档,可以尝试恢复啊
谢谢!
我们磁盘的硬盘分区是足够大的.
存储oracle数据文件的是一个raid 5磁盘阵列.一共有450G,其中存储文件的是300G所以,硬盘是足够大的.
3是无法打开的,可能是被损坏了,我就不明白为什么会报存储空间不足的错误..我查了这个错误,没有查到.
我已经做了recover了.关键是想不出为什么...查了很多资料,都几乎没有怎么讲发生的原因,和预防措施.都是在讲恢复.
我现在多增加了一组redo log到另外一个盘,我想这样的问题应该不会再发生了.
不过我还是很想找出具体的原因..
有很多错误没有原因的,要是所有错误都有原因,那我们不需要备份了。redo要坏,你也没办法
ORA-00312: online log 3 thread 1: 'X:\ORACLE\ORADATA\LIT3E2\REDO03.LOG'
ORA-27088: skgfglk: unable to get file status
OSD-04002: 无法打开文件
O/S-Error: (OS 8) 存储空间不足,无法处理此命令。呵呵,说地对啊!!
有时真的很难找出原因
谢了。ern哥。