Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-38771: unnamed datafile(s) added to controlfile by
flashback recovery
- 1 Answers
- 3379 Views
- I also Faced
- E-Mail Answers
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-00355: change numbers out of order
NNL-00020: warning: no TNSNAMES.ORA file and no preferred name servers in SQLNET.ORA
PLS-00395: wrong number of values in VALUES clause of INSERT statement
RMAN-06512: copy will be obsolete on date string
RMAN-06110: changed controlfile copy unavailable
DRG-51202: invalid key mapping operation mode : string
NZE-28772: invalid file ID
ORA-26049: Unscoped REF column has non-existent table name.
ORA-07247: skgfrfms, skgfrnms: read error, unable to read block from database file
DRG-11006: invalid alter index parameter string
NNC-00407: alias loop in name request
ORA-28503: bind value cannot be translated into SQL text for non-Oracle system
Oracle Errors 
