block corruption
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: block corruption

  1. #1
    Join Date
    Aug 2011
    Posts
    1

    block corruption

    Hi!
    We found block corruption in full export log
    EXP-00056: ORACLE error 1115 encountered
    ORA-01115: IO error reading block from file 5 (block # 395561)
    ORA-01110: data file 5: 'D:\ORACLE\ORADATA\ORCL\USERS02.DBF'
    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 1117) The request could not be performed because of an I/O device error.


    after using dbv utility on that file users02.dbf we got error again.

    DBV-00102: File I/O error on FILE (d:\oracle\oradata\ORCL\users02.dbf) during ve
    rification read operation (-2)

    after we created repair_table and, we tried to use dbms_repair utility to check block corruption

    DECLARE num_corrupt INT;
    BEGIN
    num_corrupt := 0;
    DBMS_REPAIR.CHECK_OBJECT (
    SCHEMA_NAME => 'ARH2010',
    OBJECT_NAME => 'MR300',
    REPAIR_TABLE_NAME => 'REPAIR_TABLE',
    CORRUPT_COUNT => num_corrupt);
    DBMS_OUTPUT.PUT_LINE('number corrupt: ' || TO_CHAR (num_corrupt));
    END;
    /

    ORA-01115: IO error reading block from file 5 (block # 395561)
    ORA-01110: data file 5: 'D:\ORACLE\ORADATA\ORCL\USERS02.DBF'
    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 1117) The request could not be performed because of an I/O device error.
    ORA-06512: at "SYS.DBMS_REPAIR", line 293
    ORA-06512: at line 4


    after we stoped all oracle services we unsuccesfully tried to copy users02.dbf to other destination

    does anyone have suggestion about this problem (data block coruption, media corruption)?

    Oracle DBMS 10.2.0.3 on Microsoft Windows Server 2003 Standard Edition SP2 and IBM XSERIES_3500 Intel XEON 5130 2GHz, 4 GB of RAM

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Cool

    1) Have your Windoze admin check for DISK corruption.

    2) If DBMS_REPAIR.FIX_CORRUPT_BLOCKS did not work, then use DBMS_REPAIR.SKIP_CORRUPT_BLOCKS.

    Good luck!
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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