online redo log损坏，启动报：ORA-00313和ORA-00312

今天打开虚拟机中的一个DB，这个DB好久没打开过了，在执行STARTUP启动时报错：

[oracle@ligle-db admin]$ sqlplus '/as sysdba'

 

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 28 14:03:00 2011

 

Copyright (c) 1982, 2007, Oracle.All Rights Reserved.

 

Connected to an idle instance.

 

SQL> startup;

 

ORACLE instance started.

 

Total System Global Area180355072 bytes

 

Fixed Size1266464 bytes

 

Variable Size100666592 bytes

 

Database Buffers75497472 bytes

 

Redo Buffers2924544 bytes

 

Database mounted.

 

ORA-00313: open failed for members of log group 2 of thread 1

 

ORA-00312: online log 2 thread 1: '/u01/oraclefs/liglefs/redo02.log'

 

查看V$LOG：

 

SQL> select * from v$log;

 

GROUP#THREAD#SEQUENCE#BYTESMEMBERS ARC STATUSFIRST_CHANGE# FIRST_TIM

 

---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------

 

1140524288001 NOCURRENT2147702598 15-MAR-11

 

3139524288001 YES INACTIVE2147702577 15-MAR-11

 

2138524288001 YES INACTIVE2147702575 15-MAR-11

 

损坏的不是CURRENT日志组中的重做日志文件，可通过CLEAR方式直接重建该重做日志。

 

SQL> alter database clear logfile group 2;

 

Database altered.

 

SQL> alter database open;

 

Database altered.

 

解决起来比较简单，不过如果是坏掉了当前的重做日志组，就需要根据备份执行不完全恢复了（前提是要有备份，且为归档模式）。

 

--- END ---

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

转载于:http://blog.itpub.net/25834554/viewspace-706600/