ORA-00393: log string of thread string is needed for
recovery of offline datafiles
- 1 Answers
- 2691 Views
- I also Faced
- E-Mail Answers
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 |
CLSR-00527: OCR operation failed
ORA-39065: unexpected master process exception in string
SQL*Loader-00508: record formating error in data file string
PLS-01421: FOR UPDATE clause
ORA-09765: osnmop: fork failed
ORA-08465: input mask contains more than 32 characters
PROC-00004: The cluster registry key to be operated on does not exist.
DRG-13312: user CTXSYS does not own USER_LEXER stored procedure string
ORA-00724: ALTER DATABASE CONVERT command has been de-supported
ORA-09207: sfsrd: error reading from file
TNS-00275: Navigator: Tracing is now ON
ORA-28172: distinguished name not provided by proxy
Oracle Errors 
