rac两节点数据库多了一组redo

通过查看日志：

2 (myinst: 2) 
 Global Resource Directory frozen
 * dead instance detected - domain 0 invalid = TRUE 
 Communication channels reestablished
 Master broadcasted resource hash value bitmaps
 Non-local Process blocks cleaned out
Tue Jul 21 22:19:10 2015
Tue Jul 21 22:19:10 2015
Tue Jul 21 22:19:10 2015
Tue Jul 21 22:19:10 2015
 LMS 0: 28 GCS shadows cancelled, 20 closed, 0 Xw survived
 LMS 2: 31 GCS shadows cancelled, 16 closed, 0 Xw survived
 LMS 1: 32 GCS shadows cancelled, 17 closed, 0 Xw survived
 LMS 3: 26 GCS shadows cancelled, 13 closed, 0 Xw survived
Tue Jul 21 22:19:10 2015
 LMS 4: 28 GCS shadows cancelled, 16 closed, 0 Xw survived
 Set master node info 
 Submitted all remote-enqueue requests
 Dwn-cvts replayed, VALBLKs dubious
 All grantable enqueues granted
 Post SMON to start 1st pass IR
Tue Jul 21 22:19:13 2015
Instance recovery: looking for dead threads
Instance recovery: lock domain invalid but no dead threads
Tue Jul 21 22:19:49 2015
 Submitted all GCS remote-cache requests
 Post SMON to start 1st pass IR
 Fix write in gcs resources
Reconfiguration complete
Tue Jul 21 22:19:58 2015
Thread 2 advanced to log sequence 260841 (LGWR switch)
  Current log# 40 seq# 260841 mem# 0: +ASMREDOLOG/zjsbos/onlinelog/group40
Tue Jul 21 22:20:11 2015
Archived Log entry 503499 added for thread 2 sequence 260840 ID 0x5e4be7bd dest 1:
Tue Jul 21 22:22:05 2015
Reconfiguration started (old inc 14, new inc 16)
List of instances:
 1 2 (myinst: 2) 
 Global Resource Directory frozen
 Communication channels reestablished
Tue Jul 21 22:22:05 2015
 * domain 0 valid = 1 according to instance 1 
 Master broadcasted resource hash value bitmaps
 Non-local Process blocks cleaned out
Tue Jul 21 22:22:05 2015
Tue Jul 21 22:22:05 2015
 LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Tue Jul 21 22:22:05 2015
Tue Jul 21 22:22:05 2015
 LMS 3: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Tue Jul 21 22:22:05 2015
 LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 LMS 4: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 Set master node info 
 Submitted all remote-enqueue requests
 Dwn-cvts replayed, VALBLKs dubious
 All grantable enqueues granted
Tue Jul 21 22:22:26 2015
 Submitted all GCS remote-cache requests
 Fix write in gcs resources
Reconfiguration complete
Tue Jul 21 22:22:34 2015
alter database add logfile thread 3 SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736
Tue Jul 21 22:24:00 2015
Completed: alter database add logfile thread 3 SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736 , SIZE 1610612736
alter database enable public thread 3
Completed: alter database enable public thread 3
Tue Jul 21 22:24:14 2015
Redo thread 3 internally disabled at seq 4 (CKPT)
Tue Jul 21 22:24:15 2015
ARC3: Archiving disabled thread 3 sequence 4
Archived Log entry 503500 added for thread 3 sequence 4 ID 0x5e4be7bd dest 1:
Tue Jul 21 22:30:34 2015

通过查看log发现

发现有一组thread 3 属于实例2，并且是inactive，没有被两个节点所使用

并且使用alter database disable  thread 3;

select ' alter database drop logfile group '||group#||';' from v$log where thread#=3

alter database drop logfile group 33;

重启节点后，thread 3 redo 又会被创建

SQL> select thread#, status, enabled, instance, current_group#, sequence# from v$thread; 
 
   THREAD# STATUS ENABLED  INSTANCE                                                                         CURRENT_GROUP#  SEQUENCE#
---------- ------ -------- -------------------------------------------------------------------------------- -------------- ----------
         1 OPEN   PUBLIC   bos1                                                                                      31     245562
         2 OPEN   PRIVATE  bos2                                                                                      34     261279

SQL> sho parameter thread 
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
parallel_threads_per_cpu             integer     2
thread                               integer     1


SQL> sho parameter thread 
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
parallel_threads_per_cpu             integer     2
thread                               integer     2

解决方案：

节点二：

srvctl stop listener -n bos2
ps -f -Ugrid | grep "oracle*** (LOCAL=NO)" | grep -v grep | awk '{print $2}' | xargs kill -9
srvctl stop instance -d  bos -i bos2


节点一：
alter database disable thread 2;
alter database enable public thread 2;


节点二：


srvctl start instance -d  bos -i bos2
select inst_id, thread#, status, enabled, instance from gv$thread; 
alter database disable thread 3;

   select ' alter database drop logfile group '||group#||';' from v$log where thread#=3；

到此问题解决，重启后，thread 3 redo不会被创建