在尝试使用`ALTER DATABASE OPEN RESETLOGS`命令时，遇到ORA-00392和ORA-00312错误。错误信息表明当前日志正被清除，可能是由于日志切换时的I/O错误。日志状态包括CURRENT、ACTIVE、INACTIVE、UNUSED和CLEARING/CLEARING_CURRENT，其中CLEARING_CURRENT状态表示日志重建过程中遇到问题。要解决这个问题，需要调查并修复日志文件的I/O错误。
错误信息：
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
最低0.47元/天 解锁文章
197
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
