We see the following error messages in the trace file:
- What are the causes of dbf file corruption ?
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file^M ORA-01110: data file 4: '/oradata/RAIT/tsdata/tsdata_RAIT.dbf'^M ORA-27046: file size is not a multiple of logical block size^M
- What can be the causes for the dbf file truncations ?
The error means that your operating system reports that the data file is a different size than Oracle thinks it is. The cause could be any unauthorized or inadvertent changes to the file at the OS level. Check the DBWR trace file mentioned in the first error message. Make sure that the data files are adequately protected via access privileges.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.