ORA-00333: redo log read error block 96739 count 8192 [message #317242] |
Wed, 30 April 2008 03:47 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
Orale verison :9.2.0
OS version :Redhat AS 4
Dear All,
when i try to start the db ,after database mount state ,the Database hanged for 30 minutes and then gave the error ORA-00333: redo log read error block 96739 count 8192
SQL> startup pfile='/u01/app/oracle/product/9.2.0/dbs/initdev.ora'
ORACLE instance started.
Total System Global Area 236000320 bytes
Fixed Size 451648 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00333: redo log read error block 96739 count 8192
when i check the alertlog file
Wed Apr 30 12:51:38 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Apr 30 12:51:38 2008
ALTER DATABASE OPEN
Wed Apr 30 12:51:39 2008
Beginning crash recovery of 1 threads
Wed Apr 30 12:51:39 2008
Started redo scan
Wed Apr 30 12:57:37 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Apr 30 13:02:37 2008
Restarting dead background process QMN0
Wed Apr 30 13:04:38 2008
Errors in file /u01/app/oracle/admin/dev/bdump/dev_pmon_4067.trc:
ORA-00445: background process "QMN0" did not start after 120 seconds
Wed Apr 30 13:08:40 2008
Errors in file /u01/app/oracle/admin/dev/bdump/dev_ora_4114.trc:
ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []
Wed Apr 30 13:08:40 2008
Errors in file /u01/app/oracle/admin/dev/udump/dev_ora_4087.trc:
ORA-00333: redo log read error block 98787 count 6144
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/dev/redo01.log'
ORA-27072: skgfdisp: I/O error
Linux Error: 2: No such file or directory
Additional information: 98786
Wed Apr 30 13:08:51 2008
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Apr 30 13:08:54 2008
Errors in file /u01/app/oracle/admin/dev/udump/dev_ora_4087.trc:
ORA-00333: redo log read error block 96739 count 8192
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/dev/redo01.log'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Linux Error: 2: No such file or directory
Additional information: 98787
Wed Apr 30 13:08:54 2008
ORA-333 signalled during: ALTER DATABASE OPEN...
|
|
|
|