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

曾春华

ORA-38771: unnamed datafile(s) added tocontrol file by flashback recovery

Cause: The recovery step of FLASHBACKDATABASE encountered the creation

of a datafile that could not be added to the controlfile. An entry has been added to

the control file for the new datafile, but with the filename UNNAMEDnnnn,

where nnnn is the file number. Related error messagesprovide 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 forrecovery. If the file is not

going to be recovered, then take it offline with the FORDROP option. The

recovery step of Flashback can be resumed by entering aRECOVERY command

with the same SCN or timestamp as used in the FLASHBACKDATABASE

command. For example, RECOVER AUTOMTAIC DATABASE UNTILCHANGE

<flashback-scn>.