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: 'C:/APP/WANG/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 an ALTER DATABASE CLEAR