ORA-00393: log string of thread string is needed for
recovery of offline datafiles
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
QSM-02013: SELECT list includes a RAW data type expression
ORA-01568: cannot set space quota on PUBLIC
PLS-00487: Invalid reference to variable 'string'
NNL-00810: Queries received with no type: number
RMAN-08542: channel string: starting proxy archivelog backup at string
EXP-00071: QUERY parameter not compatible with Direct Path export
ORA-12681: Login failed: the SecurID card does not have a pincode yet
NNO-00710: server's cache will be dumped to the trace file in number seconds
TNS-01171: Event detection broke for dispatcher: string
ORA-26032: index string.string loading aborted after string keys
ORA-37127: (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.
ORA-28028: could not authenticate remote server