以resetlogs方式open数据库报错ORA-00392 ORA-00312

来源：恒创科技编辑：恒创科技编辑部

2023-12-06 10:04:59

数据库：oracle 11.2.0.4

系统：AnolisOS 7.9

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

以resetlogs方式open数据库报错ORA-00392 ORA-00312

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: '/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;

Database altered.

SQL> alter database clear logfile group 3;

Database altered.

SQL> alter database clear logfile group 5;

Database altered.

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 rows selected.

SQL> alter database open resetlogs;

Database altered.