OCI-00393
Log log_number of thread thread_number is needed for recovery of offline data files.
- log_number: The log group number that is needed for recovery.
- thread_number: The log thread number.
Cause
The log cannot be cleared because the redo in it is needed to recover offline data files. 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 if dropping the tablespaces is acceptable, then add the clause UNRECOVERABLE DATAFILE at the end of the CLEAR command.
OCI-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.
OCI-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.
