ORA-00392: log 3 of thread 1 is being cleared, operation not all
数据库：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;
Databasealtered.
SQL>alter database clear logfile group 3;
Databasealtered.
SQL>alter database clear logfile group 5;
Databasealtered.
SQL>select group#,status from v$log;
GROUP# STATUS
--------------------------
1 CLEARING
2 CLEARING
3 CURRENT
4 UNUSED
5 UNUSED
6 CLEARING
7 CLEARING
8 CLEARING
9 CLEARING
10 CLEARING
11 CLEARING
GROUP# STATUS
--------------------------
12 UNUSED
12 rowsselected.
SQL>alter database open resetlogs;
Databasealtered.
说明：成功以resetlogs方式打开数据库.
