ORA-00393: log string of thread string is needed for
recovery of offline datafiles
- 1 Answers
- 2711 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-27467: invalid datatype for string value
ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types
RMAN-06726: could not locate archivelog string
SQL*Loader-00526: OCI return status: success with info
NNL-00540: [show] status [<server_list>] : display server status summary
ORA-22809: nonexistent attribute
ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION
ORA-02085: database link string connects to string
PCC-00054: Expected End-of-Statement at column number in line number of file string
DRG-52204: error while registering index
ORA-22287: invalid or modified directory occurred during string operation
PCC-02382: You must specify MODE=ANSI when using NLS_LOCAL=YES
Oracle Errors 
