ORA-01244: unnamed datafile(s) added to controlfile by media
recovery



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

Post New Answer

More Oracle Errors Interview Questions

ORA-07570: szrfc: $IDTOASC failure

1 Answers  


DRG-12403: template string was not found

1 Answers  


ORA-39950: invalid parameter for PLSQL warnings flag

1 Answers  


TNS-01013: set|show trc_{ } [<value>]: set|show trace parameters of current listener

1 Answers  


ORA-26062: Can not continue from previous errors.

1 Answers  






NPL-00313: requested form string does not match actual form string

1 Answers  


ORA-02295: found more than one enable/disable clause for constraint

1 Answers  


PLS-00144: duplicate external CALLING STANDARD specification in subprogram expression

1 Answers  


DRG-11812: Moved Permanently

1 Answers  


ORA-13364: layer dimensionality does not match geometry dimensions

1 Answers  


ORA-12453: label string already exists

1 Answers  


ORA-01528: EOF while processing SQL statement

1 Answers  


Categories