在Oracle问题解决之前曾遇到过这样的问题，当时由于时间紧急，不知怎么解决，所以就拿出来和大家一起分享，以下就是文章的详细内容介绍，望大家借鉴。今天又遇到，造成的原因是log被损坏。

cmd->sqlplus 
SQL>selectgroup#,sequence#,archived,statusfromv$log; 
GROUP#SEQUENCE#ARCSTATUS 
86NOINACTIVE 
87NOINVALIDATED 
85NOINACTIVE 
alterdatabaseclearlogfilegroup1; 
alterdatabaseclearlogfilegroup2; 
alterdatabaseclearlogfilegroup3; 
shutdownimmediate; 
startupmount; 
SQL>selectgroup#,sequence#,archived,statusfromv$log; 
GROUP#SEQUENCE#ARCSTATUS 
88NOCURRENT 
0NOUNUSED 
0NOUNUSED 
alterdatabaseclearlogfilegroup1; 
alterdatabaseclearunarchivedlogfilegroup1; 
alterdatabaseclearlogfilegroup2; 
alterdatabaseclearunarchivedlogfilegroup2; 
alterdatabaseclearlogfilegroup3; 
alterdatabaseclearunarchivedlogfilegroup3; 
shutdown; 
startupmount; 
alterdatabaseopen;