Logs in INACTIVE status are corrupted.

INACTIVELog corruption

SQL> alter system switch logfile; 

System altered.

View the log status

SQL>Select * from v $ log;

 

GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIM

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

1 1 28 52428800 1 yes active 579215 07-SEP-12

2 1 29 52428800 1 no current 579450 07-SEP-12

3 1 27 52428800 1 yes inactive 579032 07-SEP-12

The third log group isINACTIVEStatus

View the group to which logs belong and corresponding log files

SQL>Select * from v $ logfile; 

GROUP # status type member is _

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

3ONLINE/u01/tiger/oradata/orcl2/redo03.log NO

2 ONLINE/u01/tiger/oradata/orcl2/redo02.log NO

1 ONLINE/u01/tiger/oradata/orcl2/redo01.log NO

View the log file corresponding to the third log Group

SQL>! Cp/etc/passwd/u01/tiger/oradata/orcl2/redo03.log 

SQL> shutdown immediate

Database closed.

Database dismounted.

Oracle instance shut down.

SQL> startup

ORACLE instance started.

 

Total System Global Area 314572800 bytes

Fixed Size 1219136 bytes

Variable Size 121636288 bytes

Database Buffers 184549376 bytes

Redo Buffers 7168000 bytes

Database mounted.

ORA-00313: open failed for members of loggroup 3 of thread 1

ORA-00312: online log 3 thread 1: '/u01/tiger/oradata/orcl2/redo03.log' 

Clean current log Group

SQL>Alter database clear logfile group 3; 

Database altered. 

SQL> alter database open; 

Database altered. 

SQL>