| ORA-1115 error [message #339368] |
Thu, 07 August 2008 06:45  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi,
My database version is 9.2.0.8 and it's using raw filesystem.
For the last one week,I'm getting the following error in alert log,
Errors in file /u02/oracle/app/product/orahome/admin/testdb/bdump/testdb_smon_512324.trc
ORA-01115: IO error reading block from file 1 (block # 10057)
ORA-01110: data file 1: '/dev/rpsystem01'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
I ran DBVERIFY utility on this file,it says that the file is fine,please look at the output of dbverify utility,
$ dbv file=/dev/rpsystem01 blocksize=8192
DBVERIFY: Release 9.2.0.8.0 - Production on Thu Aug 7 12:16:04 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /dev/rpsystem01
DBVERIFY - Verification complete
Total Pages Examined : 130944
Total Pages Processed (Data) : 42571
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 9294
Total Pages Failing (Index): 0
Total Pages Processed (Other): 11969
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 67110
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 2776196209960 (646.1647336744)
But the database is up and running fine without any issue,
please someone help me in resolving this error and the trace file (testdb_smon_512324.trc) is also not generated for me in bdump,please help me in fixnig this problem also.
Thanks...
|
|
|
|
|
|
| Re: ORA-1115 error [message #339391 is a reply to message #339368] |
Thu, 07 August 2008 07:26  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi Taj,
Thanks for your reply. May I know why the trace file (testdb_smon_512324.trc) was not generated for me in bdump?
Thanks..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
