Urgent Datafile error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Urgent Datafile error

  1. #1
    Join Date
    May 2001
    Posts
    57

    Angry

    Iam trying to export my databse and for one of the tables my export is failing and giving me a message like below:
    EXP-00056: ORACLE error 1115 encountered
    ORA-01115: IO error reading block from file 6 (block # 524311)
    ORA-01110: data file 6: '/DISK01/oradata/cmt10/data/cmt_data01.dbf'
    ORA-27072: skgfdisp: I/O error
    SVR4 Error: 25: Inappropriate ioctl for device
    My OS is solaris 2.6. Can anyone of you suggest me what I can do on this. The shared disk devices are on.

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Probably you have a disk failure. Check if you have access to this disk.

    Regards

    Angel

  3. #3
    Join Date
    Mar 2002
    Posts
    25
    The Device on which the file resides is probably off line or has Faild. I also agree , you might have Disk Failure.
    Good Luck !

  4. #4
    Join Date
    May 2001
    Posts
    57
    I have already mentioned that my shared disk group device, sun store edge array is on. Iam able to export all other tables except one for which iam getting the above mentioned error.-

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Have you passed the dbv on this datafile. Maybe you have corrupted blocks on it.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You either have a disk going bad or have a bad block on disk. Check /var/adm/messages for any SCSI errors and start thinking about recovery.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    May 2001
    Posts
    57

    Angry

    Can anyone suggest me how i can find the corrupt data blocks from the database!!!!

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What version?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Dec 2001
    Posts
    221
    you can use DBMS_REPAIR package. It contains procedures CHECK_OBJECT,FIX_CORRUPT_BLOCKS and some other procedures. u can check it onOracle's documentation
    Santosh Jadhav
    8i OCP DBA

  10. #10
    Join Date
    May 2001
    Posts
    57
    The database version is 8.0.5.
    The database is running with veritas volume manager on solaris 2.6 and sun store edge array.

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