ORA-01115 Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-01115 Error

Hybrid View

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    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...

  2. #2
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    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

  3. #3
    Join Date
    Feb 2006
    Posts
    162
    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...

  4. #4
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    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

  5. #5
    Join Date
    Feb 2006
    Posts
    162
    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
  •  



Click Here to Expand Forum to Full Width