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

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32582: table function with left correlation to a table cannot also be left outer-joined to the table

1 Answers  


LSX-00106: duplicate attribute "~S"

1 Answers  


ORA-23606: invalid object string

1 Answers  


ORA-12215: TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA

1 Answers  


ORA-32739: Hang analysis aborted due to failed heap re-grow

1 Answers  


RMAN-06087: read-only files may only be skipped in a datafile backup set

1 Answers  


IMP-00012: invalid export mode (character) in header

1 Answers  


RMAN-06593: platform name 'string' specified in FROM PLATFORM is not valid

1 Answers  


ORA-26053: Row was not loaded due to conversion error.

1 Answers  


ORA-28556: authorization insufficient to access table

1 Answers  


ORA-09317: szprv: insufficient privileges

1 Answers  


ORA-09870: spini: failure initializing maximum number of open files.

1 Answers  


Categories