Oracle DBA, How To, Error, Cause and Action

ORA-01111: name for data file string is unknown - rename to correct file

ORA-01111: name for data file string is unknown - rename to correct file



Cause: The data file was missing from a CREATE CONTROLFILE command or backup control file recovery was done with a control file that was saved before the file was created.



Action: Rename the MISSING file to the name of the real file.