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 |
ORA-26696: no streams data dictionary for object with number string and version number string from source database string
ORA-23424: materialized view "string"."string" at string not registered
ORA-32591: connect string too long
TNS-00112: Failed to find configuration file name
ORA-08108: may not build or rebuild this type of index online
ORA-16093: dependent archive log destination is not LGWR-enabled
NZE-28767: invalid version number
PLS-00117: Duplicate connect-by clause in table expression
ORA-30564: Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
ORA-25508: database is not mounted
ORA-10566: Test recovery has used all the memory it can use
ORA-06265: NETNTT: break protocol error