Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-00393: log string of thread string is needed for
recovery of offline datafiles
- 1 Answers
- 3355 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 |
ORA-00309: log belongs to wrong database
RMAN-06045: LEVEL option not supported for archive log or current/standby controlfile copies
RMAN-08548: recovery area destination: string
ORA-01185: logfile group number string is invalid
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-30341: dropped level has references
ORA-23459: flavor string must contain "string"
DRG-50906: score threshold string is not an integer
ORA-14268: subpartition 'string' of the partition resides in offlined tablespace
DRG-12401: invalid template: query within a loop
IMP-00071: Object identifier of imported table mismatches object identifier of existing table
ORA-32800: internal error string
Oracle Errors 
