数据库：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.
