rac dg删除备库redo时报ora-m6米乐安卓版下载

背景：

数据库版本：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'

m6米乐安卓版下载的解决方案

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

                         文章推荐