重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-01623: log 7 is current log for instance orcl2 (thread 2) - cannot drop [打印本页]

作者: denglj 时间: 2022-8-24 11:41
标题: ORA-01623: log 7 is current log for instance orcl2 (thread 2) - cannot drop

数据库：oracle 11.2.0.4

系统：AnolisOS7.9

问题描述：Rman恢复后，log日志文件存在Thread2，当前环境为单实例,删除group7报错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 rowsselected.

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 rowsselected.

SQL>alter database drop logfile group 7;

alterdatabase drop logfile group 7

ERROR atline 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;

Databasealtered.

SQL>alter database drop logfile group 7;

Databasealtered.

SQL>alter database drop logfile group 8;

Databasealtered.

SQL>alter database drop logfile group 9;

Databasealtered.

SQL>alter database drop logfile group 10;

Databasealtered.

SQL>alter database drop logfile group 11;

Databasealtered.

SQL> alterdatabase drop logfile group 12;

Databasealtered.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)