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
LPX-00752invalid ~1s, must be ~2s
PCC-02385CHAR_MAP disallowed when using NLS_CHAR and NLS_LOCAL=TRUE
LPX-00254invalid XML declaration
DIA-48107invalid Bfile input, [string]
CLSR-00515A service member is already running on this node
NZE-28845No certificate
QSM-02150select lists must be identical across the UNION operator
LPX-00004internal error "~s"
QSM-00780the task string could not be executed because the workload string is being modified
ORA-19103VALUE keyword keyword
ORA-25253listen failed, queue string.string is not enabled for dequeue
LPX-00708SOAP failed to make HTTP connection
AMD-00154Cannot delete session object "string" in Workspace "string"
RMAN-08522input datafile file number=string name=string
QSM-01007query has NOREWRITE hint
PLS-00706Exception string cannot be used as prefix of a selected component
ORA-12655Password check failed
TNS-12596TNS:internal inconsistency
ORA-01883overlap was disabled during a region transition
ORA-56904pivot value must have datatype that is convertible to pivot column




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