ORA-01244: unnamed datafile(s) added to controlfile by media
recovery
- 1 Answers
- 4658 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 |
NNL-00004: invalid command argument "string"
SQL-02140: An unnamed connection already exists
NNO-00250: invalid administrative region description
ORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.
PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.
ORA-00210: cannot open the specified controlfile
PCB-00403: EXEC statement cannot begin in Area A
ORA-31417: column list contains control column string
DRG-50801: failed to parse cursor
ORA-06767: TLI Driver: alloc failed during release
KUP-04004: error while reading file string
QSM-02127: not supported for this type mv by Oracle version at master site
Oracle Errors 
