梦想有多远

查了下METALINK找到如下解决方法：
首先看下是什么是DRM
DRM - Dynamic Resource Mastering
When using Real application Clusters (RAC), Each instance has its own SGA and buffer cache. RAC will ensure that these block changes are co-ordinated to maximize performance and to ensure data intergrity. Each copy of the buffer also called as a cache resource has a master which is one of the nodes of the cluster.

In database releases before 10g (10.1.0.2) once a cache resource is mastered on an instance, a re-mastering or a change in the master would take place only during a reconfiguration that would happen automatically during both normal operations like instance startup or instance shutdown or abnormal events like Node eviction by Cluster Manager. So if Node B is the master of a cache resource, this resource will remain mastered on Node B until reconfiguration.

10g introduces a concept of resource remastering via DRM. With DRM a resource can be re-mastered on another node say from Node B to Node A if it is found that the cache resource is accessed more frequently from Node A. A reconfiguration is no longer the only reason for a resource to be re-mastered.

Bug 5600050

解决方法：

关闭ORACLE RAC DRM 具体操作方法如下：
alter system set “_gc_undo_affinity”=false scope=spfile sid=’*';
alter system set “_gc_affinity_time”=0 scope=spfile sid=’*';
然后重启RAC数据库。

This entry was posted on 星期四, 七月 24th, 2008 at 13:57 and is filed under oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.