ORA-00393: log string of thread string is needed for
recovery of offline datafiles
- 1 Answers
- 3014 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-31506: duplicate subscription name string
ORA-24416: Invalid session Poolname was specified.
ORA-12618: TNS:versions are incompatible
DRG-50000: requested size larger than pagesize
ORA-00298: Missing or invalid attribute value
ORA-13351: two or more rings of a complex polygon overlap
ORA-12155: TNS:received bad datatype in NSWMARKER packet
ORA-10621: data block does not belong to the segment
ORA-10615: Invalid tablespace type for temporary tablespace
NZE-29106: Cannot import PKCS #12 wallet.
ORA-31675: worker process interrupt for unexpected death of master process
ORA-26701: STREAMS process string does not exist
Oracle Errors 
