-
ORA-01115 Error
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...
-
Are you on ML05 and above.
There is an issue between "IO Interoperability Issue between IBM ML05 and Oracle Databases"
If on ML05 you need to apply IBM AIX fix + Database Patch.
If you are on ML06 Only Database Patch.
Please read Metalink Note :- Note:390656.1 completely for exact details.
I have faced this earlier.
Rgds
Parag
-
Hi Parag,
Thanks for your opt information.
I'll check with my AIX admin and update the ML information later.
Please clear this doubt also,in this condition if I shutdown and restart the database,Will my database come up properly without any error?
Thanks...
-
yes it should come up properly.
Actually its no bad block or anything on said datafile
but because of io interoperatibilty issue between AIX and Oracle it cant do IO operation.
Otherwise you would have got failed/corrupt block in you DBV run which u did.
But for to be on safer side take proper backup.
You can use RMAN also to check block corruption.
Rgds
Parag
-
Thanks for your information.After resolving this issue,I'll let you know.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|