RAC DG删除备库redo时报ORA-01623

背景：

数据库版本：11.2.0.3
数据库环境：单实例（生产主库RAC的备库）
原因：在做生产RAC环境的备库时,为使用管理环境干净地无用的redo进行drop操作时报错：ORA-01623

报错:

SQL> alter database drop logfile group 6;
alter database drop logfile group 6
*
ERROR at line 1:
ORA-01623: log 6 is current log for instance rac2(thread 2) - cannot drop
ORA-00312: online log 6 thread 2: '+REDO1/rac/onlinelog/group_6.274.1004176209'
ORA-00312: online log 6 thread 2: '+REDO2/rac/onlinelog/group_6.261.1004176209'

解决方案

SQL> select t.thread#,t.status,t.instance from v$thread t;

   THREAD# STATUS INSTANCE
---------- ------ --------------------------------------------------------------------------------
         1 OPEN   rac1
         2 CLOSED rac2
-- 将CLOSED 状态的THREAD# 进行disable
SQL> alter database disable thread 2;
-- 现在就可清除rac2实例在备库的redo组了
SQL> select GROUP#,THREAD#,STATUS  from v$log;
GROUP# THREAD#  STATUS   
------ -------  ---------
     1       1  INACTIVE 
     2       1  INACTIVE 
     3       1  CURRENT  
     4       1  INACTIVE 
     5       1  INACTIVE 
     6       2  UNUSED   
     7       2  UNUSED   
     8       2  UNUSED   
     9       2  UNUSED   
    10       2  UNUSED   
-- 清理THREAD# = 2的日志组
SQL> alter database drop logfile group 6;

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> select GROUP#,THREAD#,STATUS  from v$log;
GROUP# THREAD#  STATUS   
------ -------  ---------
     1       1  INACTIVE 
     2       1  INACTIVE 
     3       1  CURRENT  
     4       1  INACTIVE 
     5       1  INACTIVE 
SQL> select t.thread#,t.status,t.instance from v$thread t;

   THREAD# STATUS INSTANCE
---------- ------ ------------------------
         1 OPEN   rac1

可参照官方文档： ID 2341816.1

                         文章推荐