ORA-01244: unnamed datafile(s) added to controlfile by media
recovery
- 1 Answers
- 4660 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-01291: missing logfile
ORA-13829: SQL profile named string already exists
ORA-38441: System could not derive the list of STORED and INDEXED attributes.
CLSR-00504: Error number encountered when posting an EVM event
ORA-25321: enqueue failed, user property specified but queue string.string is not an 8.1 style queue
ORA-28134: object cannot have fine-grained access control policy
TNS-12590: TNS:no I/O buffer
NCR-03003: NCRO: Unexpected message
ORA-28544: connect to agent failed, probable Net8 administration error
ORA-24125: Object string.string has changed
ORA-00740: datafile size of (string) blocks exceeds maximum file size
ORA-23424: materialized view "string"."string" at string not registered
Oracle Errors 
