I got this error while I was doing an export: 
. . exporting table    OLD_POTRXDST
EXP-00014: error on row 27905296 of table OLD_POTRXDST

EXP-00008: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 20 (block # 430943)
 
ORA-01110: data file 20: /dev/rdsk/c100t1d0s8'

ORA-07372: sfrfb: read error, unable to read requested block from database file.
NCR System 3000 Error: 5: I/O error
Additional information: 430943
Additional information: -1978599220
Additional information: 134504096
Is this a problem with the object or is the data file corrupt? How can I fix this? Could the file size be the problem? How can I check this? Thank in advance!

    Requires Free Membership to View

    Login

The ORA-1115 error tells me that there is some problem between the Oracle database and the file. First, make sure that Oracle can read the datafile. You can use the database verification utility, dbv, to do this. Use dbv as follows: 
dbv file=filename blocksize=xxxx
You will need to know the block size for this file. If the dbv utility reports that everything is correct, then Oracle can talk with the file just fine and you might have some block-level corruption. The dbv utility will report some corruption as well.

If the dbv utility cannot read the file, then you have an OS issue with this filesystem. Your sysadmin should be able to fix the problem. If the dbv utility can read the file, then you have an issue with corruption in the file. Your best option at that point is to restore the file from a good backup.

This was first published in September 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top