ORA-01157 cannot identify/lock data file string - see DBWR trace file
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01157 from Oracle 10g ?
The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.
How to deal with ORA-01157 from Oracle 10g ?
Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01149 cannot shutdown - file string has online backup set
- ORA-01150 cannot prevent writes - file string has online backup set
- ORA-01151 use media recovery to recover block, restore backup if needed
- ORA-01152 file string was not restored from a sufficiently old backup
- ORA-01153 an incompatible media recovery is active
- ORA-01154 database busy. Open, close, mount, and dismount not allowed now
- ORA-01155 the database is being opened, closed, mounted or dismounted
- ORA-01156 recovery in progress may need access to files
- ORA-01158 database string already mounted
- ORA-01159 file is not from same database as previous files - wrong database id
- ORA-01160 file is not a string
- ORA-01161 database name string in file header does not match given name of string
- ORA-01162 block size string in file header does not match configured block sizes
- ORA-01163 SIZE clause indicates string (blocks), but should match header string
- ORA-01164 MAXLOGFILES may not exceed string
- ORA-01165 MAXDATAFILES may not exceed string