Recover from Redo Group Corruption - Flashback Database Off

ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO
3B.LOG'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 104844176)

Tue Oct 13 10:46:17 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_lgwr_1480.tr
c:
ORA-00321: log 3 of thread 1, cannot update log file header
ORA-00312: online log 3 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'

Tue Oct 13 10:46:17 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_lgwr_1480.trc:
ORA-00313: open failed for members of log group 3 of thread 1

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
NO

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


SQL> alter database clear logfile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG';
alter database clear logfile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'
*
ERROR at line 1:
ORA-01514: error in log specification: no such
log
ORA-01517: log member:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'

SQL> alter database drop logfile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG';
alter database drop logfile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'
*
ERROR at line 1:
ORA-01514: error in log specification: no such
log
ORA-01517: log member:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.L
OG'

SQL> select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 INACTIVE
3 2 CURRENT
2 2 INACTIVE

SQL> alter database clear logfile group 3;
alter database clear logfile group 3
*
ERROR at line 1:
ORA-00350: log 3 of instance orclnew (thread 1)
needs to be archived
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.L
OG'
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A.L
OG'

SQL> alter database open;

Database altered.

SQL> select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 INACTIVE
2 2 INACTIVE
3 2 CURRENT

SQL> alter system switch logfile;

System altered.

SQL> select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 INACTIVE
2 2 CURRENT
3 2 ACTIVE

SQL> alter system switch logfile;

System altered.

SQL> select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 CURRENT
2 2 ACTIVE
3 2 ACTIVE

SQL> alter system switch logfile;

System altered.

SQL> select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 ACTIVE
2 2 ACTIVE
3 2 CURRENT

SQL> alter system switch logfile;

System altered.

SQL> select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 INACTIVE
2 2 CURRENT
3 2 ACTIVE

SQL> alter system switch logfile;

System altered.

SQL> select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 CURRENT
2 2 INACTIVE
3 2 INACTIVE

SQL> alter database clear logfile group 3;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

Tue Oct 13 11:24:42 2009
alter database clear logfile group 3
Tue Oct 13 11:24:42 2009
Clearing online log 3 of thread 1 sequence number 87
Tue Oct 13 11:24:42 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\udump\orclnew_ora_5444.trc
:
ORA-00313: open failed for members of log group 3 of thread 1

Completed: alter database clear logfile group 3
Tue Oct 13 11:25:12 2009
Thread 1 advanced to log sequence 90
Current log# 3 seq# 90 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B
.LOG
Current log# 3 seq# 90 mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A
.LOG
Thread 1 advanced to log sequence 91
Current log# 2 seq# 91 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2A
.LOG
Current log# 2 seq# 91 mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2B
.LOG
Thread 1 cannot allocate new log, sequence 92
Checkpoint not complete
Current log# 2 seq# 91 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2A
.LOG
Current log# 2 seq# 91 mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2B
.LOG
Tue Oct 13 11:25:23 2009
Thread 1 advanced to log sequence 92
Current log# 1 seq# 92 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO1A
.LOG
Current log# 1 seq# 92 mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO1B
.LOG
Thread 1 advanced to log sequence 93
Current log# 3 seq# 93 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B
.LOG
Current log# 3 seq# 93 mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A
.LOG
Thread 1 cannot allocate new log, sequence 94
Checkpoint not complete
Current log# 3 seq# 93 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B
.LOG
Current log# 3 seq# 93 mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A
.LOG
Thread 1 advanced to log sequence 94
Current log# 2 seq# 94 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2A
.LOG
Current log# 2 seq# 94 mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2B
.LOG