背景：

數(shù)據(jù)庫版本：11.2.0.3
數(shù)據(jù)庫環(huán)境：單實(shí)例（生產(chǎn)主庫RAC的備庫）
原因：在做生產(chǎn)RAC環(huán)境的備庫時(shí),為使用管理環(huán)境干凈地?zé)o用的redo進(jìn)行drop操作時(shí)報(bào)錯(cuò)：ORA-01623

報(bào)錯(cuò):

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 狀態(tài)的THREAD# 進(jìn)行disable
SQL> alter database disable thread 2;
-- 現(xiàn)在就可清除rac2實(shí)例在備庫的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

?????????????????????????文章推薦