4 Replies Latest reply: Oct 1, 2013 12:13 AM by sb92075 RSS

    ORA-01115: IO error reading block from file

    992895

      Os -  windows 7
      Database version -  oracle 10.2.0.1.0

      Database in no archive log mode

       

      i got the following errors at the time of select records from some table,
      same error at the time of export backup,

       

      i try dbms_repair.check_object, but same errors message

       

      Plz help me to resolve it.

       


      SQL> select count(*) from abc.party_mas;
      select count(*) from abc.party_mas
                                  *
      ERROR at line 1:
      ORA-01115: IO error reading block from file 6 (block # 30297)
      ORA-01110: data file 6: 'H:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACLE\ABC_DATA.DAT'
      ORA-27091: unable to queue I/O
      ORA-27070: async read/write failed
      OSD-04006: ReadFile() failure, unable to read from file
      O/S-Error: (OS 23) Data error (cyclic redundancy check).

       


      thanks in advance

        • 1. Re: ORA-01115: IO error reading block from file
          sb92075

          [oracle@localhost ~]$ oerr ora 1115

          01115, 00000, "IO error reading block from file %s (block # %s)"

          // *Cause:  Device on which the file resides is probably offline

          // *Action: Restore access to the device

           

          OS error

          Oracle is victim; not culprit

          • 2. Re: ORA-01115: IO error reading block from file
            992895

            thanks sb92075 for quick reply,

            but i can access records from some table the error occurred at the time when i select from some tables only , so how can we say that Device on which the file resides is probably offline,

            correct me if i am wrong.

            • 3. Re: ORA-01115: IO error reading block from file
              sb92075

              992895 wrote:

               

              thanks sb92075 for quick reply,

              but i can access records from some table the error occurred at the time when i select from some tables only , so how can we say that Device on which the file resides is probably offline,

              correct me if i am wrong.

              you do not have to convince me of anything.

              The issue is between you & the OS.

              errors are thrown because a problem exists; whether you acknowledge it or not.

              • 4. Re: ORA-01115: IO error reading block from file
                992895

                i totally agree with you sir,

                i just ask about device offline because may be i cant understand it properly as i am newbie .

                i also checked the hardware storage disk by os check disk utility but can't find any solution.

                Let me now search on net for this type os error,

                some one help me if they have any solution for this type of os error,

                 

                and thanks sb92075 for your support and help.