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
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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-00393：恢复脱机数据文件需要线程字符串的日志字符串,
.原因：无法清除日志，因为需要重做日志以恢复脱机数据文件。它没有被归档，所以没有其他副本可用。如果清除日志，则必须删除包含文件的表空间。,
.操作：存档日志，然后重复清除命令。如果无法归档，并且删除表空间是可接受的，则在清除命令结束时添加子句UNRECOVERABLE DATAFILE。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题