ORA-38771: unnamed datafile(s) added to control file by flashback recovery
Cause: The recovery step of FLASHBACK DATABASE encountered the creation of a datafile that could not be added to the control file. An entry has been added to the control file 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 control file, 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>.
ORA-38774
Custom Search


More Oracle errors
ORA-31490could not attach to LogMiner session
DRG-11101failed to open file string
ORA-54538unexpected gtype
ORA-36632(XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
CLSR-00501Error number encountered when connecting to EVM daemon
ORA-32027There is no string column with the matching type in string.string.
ORA-02073sequence numbers not supported in remote updates
ORA-19003Missing XML root element name
ORA-18015invalid source outline signature
ORA-38503index already defined using the parameters
ORA-27190skgfrd: sbtread2 returned error
QSM-03112Invalid CREATE MATERIALIZED VIEW statement string
ORA-00395online logs for the clone database must be renamed
NNL-00807Queries received, type SOA: number
ORA-16150FINISH recovery performed on another, older standby database
PGU-42026COPY copies a COPY REPLACING or vice versa
ORA-01356active logminer sessions found
ORA-16720no LOG_ARCHIVE_DEST_n initialization parameters available
PCC-02454Must use option OUTLINE when option OUTLINPREFIX is used
NZE-28854Memory allocation failure




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-38771unnamed datafile(s) added to control file by flashback recovery