ORA-01244: unnamed datafile(s) added to controlfile by media
recovery
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 |
PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
KUP-04040: file string in string not found
ORA-28042: Server authentication failed
NZE-28863: SSL session not found
ORA-16585: illegal operation on a primary site
ORA-29851: cannot build a domain index on more than one column
DRG-12229: special section string already exists in this section group
LPX-00120: entity "~1S" NDATA (notation) "~2S" is undefined
PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands
ORA-29389: too many errors during validation
ORA-13148: failed to generate SQL filter
NNL-00898: Responses sent: number