. . 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: 134504096Is 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!
dbv file=filename blocksize=xxxxYou 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.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.