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

TNS-01009: service [<listener_name>] : get the service information of the listener

1 Answers  


RMAN-08036: channel string: could not create controlfile record for string string

1 Answers  


ORA-19026: EXTRACTVALUE can only retrieve value of leaf node

1 Answers  


ORA-02322: failure in accessing storage table of the nested table column

1 Answers  


ORA-28290: Multiple entries found for the same Kerberos Principal Name

1 Answers  


ORA-25242: cannot change subscriber name from string to string without FIRST_MESSAGE option

1 Answers  


ORA-09274: szrfc: insufficient role name buffer space

1 Answers  


LPX-00116: element "~1S" attribute "~2S" has invalid value "~3S", must be "~4S"

1 Answers  


CLSR-01002: Unable to process instance startup

2 Answers  


ORA-02432: cannot enable primary key - primary key not defined for table

1 Answers  


ORA-13226: interface not supported without a spatial index

2 Answers  


ORA-19614: archivelog thread string sequence string not found in backup set

1 Answers  


Categories