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 |
NNL-00960: Time until cache flush: string
RMAN-06598: conversion between platforms 'string' and 'string' is not needed
TNS-00560: extraction of name from Entrust certificate failed
RMAN-06748: no or more than one tertiary storage channel found
ORA-31456: error executing a procedure in the DBMS_CDC_UTILITY package
QSM-01096: Materialized view with grouping sets contains duplicates
ORA-00478: SMON process terminated due to error string
O2I-00129: No Java file specified
ORA-01298: conflicting dictionary option
ORA-00331: log version string incompatible with ORACLE version string
ORA-00215: must be at least one controlfile
NCR-03019: NCRO: Unable to initialize thread support