Printable View
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.
Probably you have a disk failure. Check if you have access to this disk.
Regards
Angel
The Device on which the file resides is probably off line or has Faild. I also agree , you might have Disk Failure.
Good Luck !
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.-
Have you passed the dbv on this datafile. Maybe you have corrupted blocks on it.
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.
Can anyone suggest me how i can find the corrupt data blocks from the database!!!!
What version?
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
The database version is 8.0.5.
The database is running with veritas volume manager on solaris 2.6 and sun store edge array.
Can anyone suggest how to identify the corrupted database blocks? what are the tables/views associated in writing the queries to disclude the corrupted database blocks?????
Quote:
The same error has cropped up now again. Earleir it was in production and now it has even cascaded to development server. Marist, when I click your link it asks me for a username and password. I do not have a metalink support. Can any one of you help me with this. Any help is greatly appreciated. The following is the error now:
ORA-01115: IO error reading block from file 5 (block # 524297)
ORA-01110: data file 5: '/DISK02/oradata/cmt10/data/cmt_data01.dbf'
ORA-27072: skgfdisp: I/O error
SVR4 Error: 25: Inappropriate ioctl for device
Additional information: 524265
when I ran the query select count(*) from validated_mcn_detail;
The earlier error and this are the same except that their block ids are different. But the number of blocks which are affected look to be the same. Please suggest.
Moderators,
Can anyone of you throw some light on my issue. Any response is truly appreciated.
Did you just upgrade to 8.1.7 or run any large procedures to populate data? Is the amount of blocks that are corrupt high? What did the dbv utility report on all of your datafiles?
The version of oracle is 8.0.5 I am really not sure if there is a bug with this version of oracle when the datafile size is over 2gb. It shows the message whatever I have posted earlier.
Hi All,
Thanks a lot to each one of you who responded and viewed this thread. The problem looks to be solved for now. I just ran the analyze statement and that fixed my corruption i guess. After this ran successfully, Iam able to query all my rows.
Thanks a bunch to all.