本文共 4640 字，大约阅读时间需要 15 分钟。

通过查看日志：

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不会被创建

转载地址：https://blog.csdn.net/wll_1017/article/details/47079763 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！