log string of thread string is needed for recovery of offline datafiles

Solution ID: ORA-00393

Type: Oracle

Arguments: log string of thread string is needed for recovery of offline datafiles

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.

Actions

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.

Browse all solutions to database errors from Oracle, MS SQL or MySQL


Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm


https://community.oracle.com/message/668263