Oracle Error ORA-38773: cannot add data file ‘string’ – file already part of database

Oracle Error Message

ORA-38773: cannot add data file ‘string’ – file already part of database

Reason for the Error

The recovery step of FLASHBACK database encountered the creation of a datafile and could not create the file because the file name is already in use in the database. The control file file entry for the file is ‘UNNAMEDnnnnn’.

Solution

Use the ALTER DATABASE CREATE DATAFILE statement to create the file with a different name.