ORA-01157: cannot identify/lock data file string - see DBWR
trace file
- 1 Answers
- 6119 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: 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.
Action: Have operating system make file available to
database. Then either open the database or do ALTER SYSTEM
CHECK DATAFILES.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
ORA-07760: slemtr: $open failure
ORA-08117: Index Organized Table operation released its block pin
ORA-01339: logfile is too old
ORA-01967: invalid option for CREATE CONTROLFILE
DRG-13010: alt_value is already used by another sub lexer
PLS-00378: invalid compilation unit for this release of PL/SQL
RMAN-04022: target database mount id string does not match channel's mount id string
DRG-51803: failed to open file: %(1)
RMAN-06027: no archive logs found that match specification
RMAN-06560: WARNING: backup set with key number will be read number times
PLS-00225: subprogram or cursor 'string' reference is out of scope
ORA-19676: one or more files failed during proxy backup or restore
Oracle Errors 
