ORA-00333 Current online redo log got corrupted

 
-----  Alert log shows the following

Mon Feb 22 10:47:13 2010

Errors in file d:\oracle\admin\inbkup\udump\inbkup_ora_1776.trc:

ORA-00333: redo log read error block 114690 count 8192
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\INBKUP\REDO03.LOG'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).
 

Mon Feb 22 10:47:13 2010

ORA-333 signalled during: ALTER DATABASE OPEN...

  

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM

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

         1          1      11276  104857600          1 NO  INACTIVE   7.9364E+12 21-FEB-10 

         2          1      11277  104857600          1 NO  INACTIVE   7.9364E+12 21-FEB-10

        3          1      11278  104857600          1 NO  CURRENT   7.9364E+12 21-FEB-10  -> got corrupted

Create pfile from spfile

 

Edit the init.ora and added

 

*._ALLOW_RESETLOGS_CORRUPTION=TRUE

Shut immediate

Startup mount pfile=;

Alter database open resetlogs;

Alter database open;

 

Then it thrown the following error

 Mon Feb 22 15:06:14 2010

Errors in file d:\oracle\admin\inbkup\udump\inbkup_ora_3304.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [79], [35], [], [], [], [], []

 

Mon Feb 22 15:06:14 2010

Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Mon Feb 22 15:06:14 2010
Errors in file d:\oracle\admin\inbkup\bdump\inbkup_smon_844.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [79], [53], [], [], [], [], []

 

Mon Feb 22 15:06:18 2010

Errors in file d:\oracle\admin\inbkup\bdump\inbkup_pmon_2264.trc:

ORA-00607: Internal error occurred while making a change to a data block

Commented the following and started

 

#*.undo_management='AUTO'

#*.undo_retention=10800

#*.undo_tablespace='UNDOTBS1'

 

Deleted the following

 

_ALLOW_RESETLOGS_CORRUPTION=TRUE

 

Startup pfile=init.ora;

 

SQL> create undo tablespace undotbs datafile 'D:\oracle\oradata\INBKU.dbf' size 1024m;

 

Tablespace created.

 SQL> shut immediate

Database closed.

Database dismounted.
ORACLE instance shut down.

 

 

Uncommented the following

#*.undo_management='AUTO'

#*.undo_retention=10800

#*.undo_tablespace='UNDOTBS'  à changed this from UNDOTBS1 to UNDOTBS

 

SQL> startup

ORACLE instance started.

 

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.

Database opened.

SQL> create spfile from pfile;

 File created.

 

Bounced the database…