一，恢复非当前的日志组
[oracle@zwc primarydb]$ rm -rf redo01*
SYS@zwcdb:~>startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed SIZE 1218992 bytes
Variable SIZE 96470608 bytes
DATABASE Buffers 184549376 bytes
Redo Buffers 2973696 bytes
DATABASE mounted.
ORA-00313: OPEN failed FOR members OF log GROUP 1 OF thread 1
ORA-00312: online log 1 thread 1: ‘/u01/app/oracle/oradata/primarydb/redo01.log‘
ORA-00312: online log 1 thread 1: ‘/u01/app/oracle/oradata/primarydb/redo01_.log‘
SYS@zwcdb:~>ALTER DATABASE clear logfile GROUP 1;
DATABASE altered.
SYS@zwcdb:~>ALTER DATABASE OPEN;
DATABASE altered.
二，恢复当前日志组
SYS@zwcdb:~>startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed SIZE 1218992 bytes
Variable SIZE 96470608 bytes
DATABASE Buffers 184549376 bytes
Redo Buffers 2973696 bytes
DATABASE mounted.
ORA-00313: OPEN failed FOR members OF log GROUP 1 OF thread 1
ORA-00312: online log 1 thread 1: ‘/u01/app/oracle/oradata/primarydb/redo01.log‘
ORA-00312: online log 1 thread 1: ‘/u01/app/oracle/oradata/primarydb/redo01_.log‘
SYS@zwcdb:~>recover DATABASE until cancel;
Media recovery complete.
SYS@zwcdb:~>ALTER DATABASE OPEN resetlogs;
DATABASE altered.
SYS@zwcdb:~>SELECT a.GROUP#,a.TYPE,b.STATUS,b.bytes/1024/1024||‘M‘ "SIZE",a.member,a.is_recovery_dest_file
FROM v$logfile a,v$log b WHERE a.GROUP#=b.GROUP# ORDER BY 1;
GROUP# TYPE STATUS SIZE MEMBER IS_RECOVERY_DEST_FILE
三，以上都无效时，可选择强制忽略日志检查
执行
1，alter system set "_allow_resetlogs_corruption"=true scope=spfile;
2，然后startup数据库
原文：http://www.cnblogs.com/wu1314421/p/4448733.html