ORA-00393: log string of thread string is needed for
recovery of offline datafiles



ORA-00393: log string of thread string is needed for recovery of offline datafiles..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-13118: invalid node_id [string]

1 Answers  


ORA-00702: bootstrap verison 'string' inconsistent with version 'string'

1 Answers  


ORA-04073: column list not valid for this trigger type

1 Answers  


NMP-00001: value too big

1 Answers  


ORA-13386: commit/rollback operation error: [string]

1 Answers  


ORA-28670: mapping table cannot be dropped due to an existing bitmap index

1 Answers  


ORA-06043: NETDNT: message send failure

1 Answers  


ORA-24784: Transaction exists

1 Answers  


ORA-16599: Data Guard broker detected a stale configuration.

1 Answers  


DGM-16948: Can not proceed to switchover. Primary is still "string".

1 Answers  


ORA-28275: Multiple mappings for user nickname to LDAP distinguished name exist.

1 Answers  


DRG-12202: error while creating section group

1 Answers  


Categories