Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01244: unnamed datafile(s) added to controlfile by media
recovery
- 1 Answers
- 5280 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-30442: can not find the definition for filter string
ORA-22923: amount of data specified in streaming LOB write is 0
NCR-04004: NCRR: Invalid interface instance handle
TNS-12661: Protocol authentication to be used
NNO-00055: invalid domain minimum TTL "string"
ORA-04077: WHEN clause cannot be used with table level triggers
ORA-29809: cannot drop an operator with dependent objects
ORA-39951: incomplete values specified for PL/SQL warning settings
ORA-14604: During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified
ORA-13603: The specified parameter string cannot be fetched as a numeric value for task or object string.
ORA-21300: objects option not installed
ORA-08005: specified row does not exist
Oracle Errors 
