ORA-01244: unnamed datafile(s) added to controlfile by media
recovery
- 1 Answers
- 4942 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: Media recovery with a backup controlfile or a
controlfile that was rebuilt, encountered the creation of a
datafile that was not in the controlfile. An entry has been
added to the controlfile for the new datafiles, but with the
file name UNNAMEDnnnn, where nnnn is the file number.
Attached errors describe the file names that were originally
used to create the files.
Action: Rename the files to valid file names and resume
recovery. If necessary the command ALTER DATABASE CREATE
DATAFILE may be used to create a file suitable for recovery
and do the rename. If the file is not going to be recovered
then take it offline with the FOR DROP option.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
ORA-36706: (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.
ORA-40206: invalid setting value for setting name string
IMG-00860: assert failure, number of region exceeds allocated
ORA-26024: SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable
ORA-24360: Type Descriptor Object not specified for Object Bind/Define
ORA-13023: interior element interacts with exterior element
NNF-01008: XDS attribute syntax string incorrect for Oracle Names syntax string
NID-00500: Keyword Description (Default)
DRG-13004: language is invalid
TNS-00243: Connection Manager: Tracing is now OFF
ORA-12234: TNS:Redirect to destination
RMAN-10006: error running SQL statement: string
Oracle Errors 
