Q
Problem solve Get help with specific problems with your technologies, process and projects.

Causes of dbf file corruption and truncation

We see the following error messages in the trace file:

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

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

There are many reasons for corruption of your files like:
software malfunction,
hard disk failure,
power failure,
malfunction in database application,
virus infection,
abrupt cancellation of DBF file
and software or hardware errors / issues.
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close