疫情严重，不知能否明天离开
看了看资料，原理不懂，方法先练习一下
全局队列锁被损坏，如何不重启而实现reconfig?
相关bug
解决方法：
好吧，我看看这个lkdebug是什么鬼，打开我的测试RAC
执行：
SQL> oradebug setmypid
Statement processed.
SQL> oradebug lkdebug -m reconfig lkdebug
Statement processed.
SQL>
没啥反应？看alert.log，哦，原来是它：
2021-01-05 23:23:07.017000 +08:00
Reconfiguration started (old inc 6, new inc 8)
List of instances (total 1) :
1
My inst 1
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
LMS 0: 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
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete (total time 0.1 secs)
或者刷新shared pool (也可能不管用，重启实例肯定管用，但有时客户环境又不允许)。
来自真实世界的例子：
阅读(1936) | 评论(0) | 转发(0) |
