通过查看日志:
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 bos2ps -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不会被创建