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
- 3537 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 |
PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1
ORA-33002: (XSAGDNGL00) In AGGMAP workspace object, the FLOOR argument of number must be less than the CEILING argument of number.
ORA-13281: failure in execution of SQL statement to retrieve WKT
ORA-23355: object string.string does not exist or is invalid at master site
ORA-16607: one or more databases have failed
TNS-04009: %-25s | number
ORA-00115: connection refused; dispatcher connection table is full
ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
ORA-14062: one or more of table's partitions reside in a read-only tablespace
RMAN-06562: available space of number kb needed to avoid reading the backup set multiple times
ORA-00066: LOG_FILES is string but needs to be string to be compatible
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
Oracle Errors 
