- 最后登录
- 2014-1-14
- 在线时间
- 40 小时
- 威望
- 125
- 金钱
- 782
- 注册时间
- 2012-4-23
- 阅读权限
- 50
- 帖子
- 69
- 精华
- 1
- 积分
- 125
- UID
- 381
|
1#
发表于 2012-6-25 15:43:28
|
查看: 11300 |
回复: 8
suse 10
三个rac 节点,以前运行正常,22号变的缓慢,平时很快的也很慢.
附件是其中一个节点的awr .
现把第一个节点 rac 1 stop ,用 rac2 rac3 工作正常。
单用rac1 也正常,但只要rac1 与其它节点一起运行就有问题
现在rac 1 alert .log 里发现
Thread 1 advanced to log sequence 13199 (LGWR switch)
Current log# 34 seq# 13199 mem# 0: +ASMREDO1/redo_1_34_01.log
Fri Jun 22 14:18:43 2012
Suspending MMON slave action kewrmafsa_ for 82800 seconds
Fri Jun 22 14:18:58 2012
Reconfiguration started (old inc 6, new inc 8)
List of nodes:
0 1
Global Resource Directory frozen
* dead instance detected - domain 0 invalid = TRUE
Communication channels reestablished
Fri Jun 22 14:18:58 2012
* domain 0 not valid according to instance 1
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Fri Jun 22 14:18:59 2012
LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Fri Jun 22 14:18:59 2012
LMS 0: 3 GCS shadows cancelled, 0 closed, 0 Xw survived
Fri Jun 22 14:18:59 2012
LMS 2: 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
Post SMON to start 1st pass IR
Fri Jun 22 14:19:00 2012
Top 5 Timed Foreground Events Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class | DB CPU | | 23,678 | | 45.94 | | gc cr block lost | 22,846 | 15,377 | 673 | 29.83 | Cluster | db file sequential read | 500,797 | 4,596 | 9 | 8.92 | User I/O | direct path read temp | 76,901 | 2,217 | 29 | 4.30 | User I/O | direct path write temp | 15,650 | 591 | 38 | 1.15 | User I/O |
|
|