错误信息:
SQL> alter database open resetlogs;
alter database open resetlogs*
ERROR at line 1:
ORA-00392: log 3 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 3 thread 1: '/orabase/bak/oradata/orcl/redo03.log'
官方解释:
-
CLEARING_CURRENT- Current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header. -
<CLEARING- Log is being re-created as an empty log after anALTER DATABASE CLEAR

在尝试使用`ALTER DATABASE OPEN RESETLOGS`命令时,遇到ORA-00392和ORA-00312错误。错误信息表明当前日志正被清除,可能是由于日志切换时的I/O错误。日志状态包括CURRENT、ACTIVE、INACTIVE、UNUSED和CLEARING/CLEARING_CURRENT,其中CLEARING_CURRENT状态表示日志重建过程中遇到问题。要解决这个问题,需要调查并修复日志文件的I/O错误。
最低0.47元/天 解锁文章
421

被折叠的 条评论
为什么被折叠?



