ORA-00393: log string of thread string is needed for recovery of offline datafiles
Cause: Log cannot be cleared because the redo in it is needed to recover offline datafiles. It has not been archived so there is no other copy available. If the log is cleared the tablespaces containing the files will have to be dropped.
Action: Archive the log then repeat the clear command. If archiving is not possible, and dropping the tablespaces is acceptible, then add the clause UNRECOVERABLE DATAFILE at the end of the clear command.
ORA-00394
Custom Search


More Oracle errors
ORA-22864cannot ALTER or DROP LOB indexes
ORA-24503codepoint length overflows for piecewise operation
ORA-54608CREATE_PC: error writing Point Cloud LOB
ORA-06556the pipe is empty, cannot fulfill the unpack_message request
ORA-29895duplicate base datatype specified
ORA-29706incorrect value string for parameter ACTIVE_INSTANCE_COUNT
ORA-22369invalid parameter encountered in method string
ORA-37176argument string is not valid for the sparsity advisor
PGU-39608TG %8ls=> a#string string string
ORA-37412column not mapped by ORGANIZATION CUBE clause
DRG-11849Heuristic Expiration
ORA-38726Flashback database logging is not on.
ORA-16240Waiting for logfile (thread# string, sequence# string)
LSX-00258invalid escape character
ORA-39805Parallel loads are not allowed when loading child and parent.
NNL-00561register <name> [-t<type>] [-d<address>] [-h<hostname>] [-l<listener_name>] : register an object with Oracle Names
DRG-50801failed to parse cursor
ORA-13631The most recent execution of task string contains no results.
ORA-31109Action failed as parent resource string is locked
ORA-44307network name too long




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-00393log string of thread string is needed for recovery of offline datafiles