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

denglj

数据库：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方式打开数据库.