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.
|
