-
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.
Jeff Hunter
-
Can anyone suggest me how i can find the corrupt data blocks from the database!!!!
-
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|