Home » RDBMS Server » Server Administration » ORA-00333: redo log read error block 96739 count 8192
ORA-00333: redo log read error block 96739 count 8192 [message #317242] Wed, 30 April 2008 03:47 Go to next message
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...

Re: ORA-00333: redo log read error block 96739 count 8192 [message #317243 is a reply to message #317242] Wed, 30 April 2008 03:53 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support.

Quote:
Linux Error: 2: No such file or directory
Additional information: 98786

Something happened to your file or file system.

Regards
Michel
Previous Topic: Upgrading oracle 10G -- catupgrd.sql file
Next Topic: action taken on scatterds read
Goto Forum:
  


Current Time: Sun Dec 04 04:14:47 CST 2016

Total time taken to generate the page: 0.04675 seconds