ORA-38771: unnamed datafile(s) added to controlfile by
flashback recovery



ORA-38771: unnamed datafile(s) added to controlfile by flashback recovery..

Answer / guest

Cause: The recovery step of FLASHBACK DATABASE encountered
the creation of a datafile that could not be added to the
controlfile. An entry has been added to the controlfile for
the new datafile, but with the file name UNNAMEDnnnn, where
nnnn is the file number. Related error messages provide the
file names that were originally used to create the files.

Action: Rename the file in the controlfile, or use the ALTER
ALTER DATABASE CREATE DATAFILE command to create a file
suitable for recovery. If the file is not going to be
recovered, then take it offline with the FOR DROP option.
The recovery step of Flashback can be resumed by entering a
RECOVERY command with the same SCN or timestamp as used in
the FLASHBACK DATABASE command. For example, RECOVER
AUTOMTAIC DATABASE UNTIL CHANGE <flashback-scn>.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00385: type mismatch found at 'string' in SELECT...INTO statement

1 Answers  


PLS-00457: expressions have to be of SQL types

1 Answers  


ORA-06523: Maximum number of arguments exceeded

1 Answers  


ORA-24386: statement/server handle is in use when being freed

1 Answers  


ORA-16028: new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires

1 Answers  






PCC-02150: Error at line number, column number in file string

1 Answers  


ORA-12062: transaction string received out of sequence from site string

1 Answers  


KUP-04009: invalid SLF handle

1 Answers  


NZE-28751: memory allocation failure

1 Answers  


ORA-13123: invalid <TOPOLOGY> name specified

1 Answers  


RMAN-06718: could not find file "string" in catalog

1 Answers  


ORA-24126: invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure

1 Answers  


Categories