ORA-00392: log 3 of thread 1 is being cleared, operation not allowed

数据库：oracle 11.2.0.4

系统：AnolisOS7.9

问题描述：Rman恢复后，以resetlogs方式打开数据库，报错ORA-00392、ORA-00312，如下所示：

SQL>alter database open resetlogs;

alterdatabase open resetlogs

*

ERROR atline 1:

ORA-00392:log 3 of thread 1 is being cleared, operation not allowed

ORA-00312:online log 3 thread 1: '/u01/app/oracle/oradata/orcl/redo03.log'

异常原因：在线日志文件log 3正在被清除，无法open数据库.

解决过程如下：

SQL>select group#,status from v$log;

GROUP# STATUS

--------------------------

1 CLEARING

2 CLEARING

3 CLEARING_CURRENT

4 CLEARING

5 CLEARING

6 CLEARING

7 CLEARING

8 CLEARING

9 CLEARING

10 CLEARING

11 CLEARING

GROUP# STATUS

--------------------------

12 UNUSED

12 rows selected.

SQL>alter database clear logfile group 4