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

DRG-11728: phrase does not have any broader terms of this type

1 Answers  


ORA-27369: job of type EXECUTABLE failed with exit code: string

1 Answers  


ORA-02303: cannot drop or replace a type with type or table dependents

1 Answers  


PCB-00701: MAX OCCURRANCES must be between 1 and 65535

1 Answers  


RMAN-08112: archivelog failover was done on string, check alert log for more info

1 Answers  






ORA-29960: line string, string

1 Answers  


ORA-09837: addCallback: could not add allocate a callback link.

1 Answers  


ORA-13137: failed to generate tablespace sequence number

1 Answers  


ORA-01487: packed decimal number too large for supplied buffer

1 Answers  


ORA-14252: invalid ALTER TABLE MODIFY PARTITION option for a Hash partition

1 Answers  


ORA-27064: cannot perform async I/O to file

1 Answers  


ORA-38310: cannot purge tablespace for other users

1 Answers  


Categories