ORA-01623 告警处理

数据库：oracle 11.2.0.4

系统：AnolisOS 7.9

问题描述：Rman恢复后，log日志文件存在Thread 2，当前环境为单实例,删除group 7报错ORA-01623，如下所示：

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

    GROUP# STATUS
---------- ----------------
         1 ACTIVE
         2 CURRENT
         3 UNUSED
         4 UNUSED
         5 UNUSED
         6 UNUSED
         7 UNUSED
         8 UNUSED
         9 UNUSED
        10 UNUSED
        11 UNUSED

    GROUP# STATUS
---------- ----------------
        12 UNUSED

12 rows selected.


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

    GROUP#    THREAD#  SEQUENCE#    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
         1          1         13          1 CURRENT
         2          1          8          1 INACTIVE
         3          1          9          1 INACTIVE
         4          1         10          1 ACTIVE
         5          1         11          1 ACTIVE
         6          1         12          1 ACTIVE
         7          2          0          1 UNUSED
         8          2          0          1 UNUSED
         9          2          0          1 UNUSED
        10          2          0          1 UNUSED
        11          2          0          1 UNUSED

    GROUP#    THREAD#  SEQUENCE#    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
        12          2          0          1 UNUSED

12 rows selected.

SQL> alter database drop logfile group 7;
alter database drop logfile group 7
*
ERROR at line 1:
ORA-01623: log 7 is current log for instance orcl2 (thread 2) - cannot drop
ORA-00312: online log 7 thread 2: '/u01/app/oracle/oradata/orcl/redo07.log'

解决过程如下：

SQL> alter database disable thread 2;

Database altered.

SQL> alter database drop logfile group 7;

Database altered.

SQL> alter database drop logfile group 8;

Database altered.

SQL> alter database drop logfile group 9;

Database altered.

SQL> alter database drop logfile group 10;

Database altered.

SQL> alter database drop logfile group 11;

Database altered.

SQL> alter database drop logfile group 12;

Database altered.