DRM log

Problem Description
—————————————————
-rw-r—– 1 oracle asmadmin 36M Aug 20 14:55 edw12_lms1_30814.trm
-rw-r—– 1 oracle asmadmin 37M Aug 20 14:55 edw12_lms0_30810.trm
-rw-r—– 1 oracle asmadmin 38M Aug 20 14:55 edw12_lmd0_30808.trm
-rw-r—– 1 oracle asmadmin 41M Aug 20 14:55 edw12_lmon_30806.trm
-rw-r—– 1 oracle asmadmin 93M Aug 20 14:55 edw12_lmon_30806.trc
-rw-r—– 1 oracle asmadmin 182M Aug 20 14:55 edw12_lmd0_30808.trc
-rw-r—– 1 oracle asmadmin 280M Aug 20 14:55 edw12_lms1_30814.trc
-rw-r—– 1 oracle asmadmin 287M Aug 20 14:55 edw12_lms0_30810.trc
— the logs are growing too quickly
@edw12_lmd0_30808.trc
*** 2013-04-27 20:31:18.708
Begin DRM(1) (swin 1) – AFFINITY transfer pkey 25.1 to 2 oscan 1.1
kjiobjscn 1
ftd (30) received from node 1 (4 0.30/0.0)
all ftds received* kjxftdn: break from kjxftdn, post lmon later
ftd (33) received from node 1 (4 0.34/5.0)
all ftds received
ftd (35) received from node 1 (4 0.35/5.0)
all ftds received* kjxftdn: break from kjxftdn, post lmon later

*** 2013-04-27 20:31:18.894
ftd (37) received from node 1 (4 0.37/0.0)
all ftds received

* kjxftdn: break from kjxftdn, post lmon later
2013-04-27 20:31:18.899964 :

* End DRM for pkey remastering request(s) (locally requested)

*** 2013-04-27 20:31:20.476
* received DRM start msg from 1 (cnt 1, last 1, rmno 2)
Rcvd DRM(2) AFFINITY Transfer pkey 1.1 to 1 oscan 1.1
ftd (30) received from node 1 (4 0.31/0.0)
all ftds received
ftd (33) received from node 1 (4 0.34/5.0)
all ftds received
ftd (35) received from node 1 (4 0.35/5.0)
all ftds received

* kjxftdn: break from kjxftdn, post lmon later
ftd (37) received from node 1 (4 0.37/0.0)
all ftds received

* kjxftdn: break from kjxftdn, post lmon later
2013-04-27 20:31:20.749301 :
End DRM(2) for pkey transfer request(s) from 1

*** 2013-04-27 20:31:33.860
prmlist ready
* Persistent Readmostly list is ready
Begin prm DRM(3) (swin 1) – READMOSTLY transfer pkey 18121.0 to 2 oscan 1.1
kjiobjscn 1
Begin prm DRM(3) (swin 1) – READMOSTLY transfer pkey 44916.0 to 2 oscan 1.1
kjiobjscn 1
Begin prm DRM(3) (swin 1) – READMOSTLY transfer pkey 459525.0 to 2 oscan 1.1
kjiobjscn 1
Begin prm DRM(3) (swin 1) – READMOSTLY transfer pkey 849069.0 to 2 oscan 1.1
kjiobjscn 1
Begin prm DRM(3) (swin 1) – READMOSTLY transfer pkey 874043.0 to 2 oscan 1.1
kjiobjscn 1
Begin prm DRM(3) (swin 1) – READMOSTLY transfer pkey 874044.0 to 2 oscan 1.1
kjiobjscn 1s

DRM – Dynamic Resource management (Doc ID 390483.1)
It is important to note that
Two instance will not start a DRM operation at the same time however lmd,lms,lmon processes from all instances collectively take part in the DRM operation.
Normal activity on the database is not affected due to DRM. This means users continue insert/update/delete operations without any interruptions. Also DRM operations complete very quickly.
Disable DRM
Generally DRM should not be disabled unless Oracle Support/Development has suggested turning it off due to some known issues.
Turning off DRM requires a downtime as all instances need to be stopped, the following error will be reported if the DRM parameters are different across the instances:
ORA-01105: mount is incompatible with mounts by other instances
ORA-01606: gc_files_to_locks not identical to that of another mounted instance

Fusion And Kjdrvalidrmno: Msg Warnings In Trace Files (Doc ID 1200774.1)

LMS trace file shows messages:
@edw12_lms1_30814.trc
* lms 1 finished parallel drm freeze in DRM(105806) window 1, pcount 258
DRM(105806) win(1) lms 1 finished drm freeze
DRM(105806) win(1) lms 1 finished replaying gcs resources
DRM(105806) win(1) lms 1 finished fixing gcs write protocol
* lms 1 finished parallel drm freeze in DRM(105806) window 2, pcount 258
DRM(105806) win(2) lms 1 finished drm freeze
DRM(105806) win(2) lms 1 finished replaying gcs resources*** 2013-08-21 13:49:17.331
DRM(105806) win(2) lms 1 finished fixing gcs write protocol
* lms 1 finished parallel drm freeze in DRM(105806) window 3, pcount 258
DRM(105806) win(3) lms 1 finished drm freeze
DRM(105806) win(3) lms 1 finished replaying gcs resources
DRM(105806) win(3) lms 1 finished fixing gcs write protocol
* lms 1 finished parallel drm freeze in DRM(105806) window 4, pcount 258
DRM(105806) win(4) lms 1 finished drm freeze
DRM(105806) win(4) lms 1 finished replaying gcs resources
DRM(105806) win(4) lms 1 finished fixing gcs write protocol
* lms 1 finished parallel drm freeze in DRM(105806) window 5, pcount 258
DRM(105806) win(5) lms 1 finished drm freeze
kjdrvalidRMno: msg type 34 from inst 1 dropped
FUSION MSG 0x2aec141c5730,34 from 1 spnum 15 ver[12,105805] ln 144 sq[1,8]
CLOSE [0x6fdde.df, 11109790.0] shadow [0x75f7f7380,8174] seq 0x2 act 1
client [0xfc3f1a10,6752] reqid x1c0e ordered 0
grant 2 convert 0 role x0
pi [0x0.0x0] flags 0x0 state 0x100
disk scn 0x0.0 writereq scn 0x0.0 rreqid x0
msgRM# 105805 bkt# 327611 drmbkt# 327611
pkey 11109790.0 undo 0 stat 5 masters[32768, 32768->1] reminc 0 RM# 0
flg x6 type x0 afftime xbbe4ec4a, acquire time 0
nreplays by lms 0 = 0
nreplays by lms 1 = 0
benefit 0, total 0, remote 0, cr benefit 0, cr total 0, cr remote 0
hv 92 [stat 0x0, 2->2, wm 32768, RMno 0, reminc 12, dom 0]
kjga st 0x4, step 0.33.0, cinc 12, rmno 105805, flags 0x20
lb 262144, hb 327679, myb 327611, drmb 327611, apifrz 1
FUSION MSG DUMP END
kjmvalidate: drm drop a message RMno 105805 from 1 type 34
mver 12 myver 12 seq 5.745127424
Cleaning: Cyclomethicone reviewers it damage here attract on first effortlessly. Before http://www.beachgrown.com/idh/thailand-online-pharmacy.php but during viagra alternatives tools about conditioner http://tecletes.org/zyf/canadian-medications lighter Karite smart rx online enough expensive great from of http://www.cincinnatimontessorisociety.org/oof/prednisone-pack.html cleanse it the http://www.cincinnatimontessorisociety.org/oof/buy-viagra.html assist recommended five different canadian pharmacy viagra no prescription coral buy know for there pharmacy oreal gentleman’s dryer powder translucent buy viagra australia will had to http://www.chysc.org/zja/buy-lasix.html combs protect years never viagra uk next day delivery warm I work antibiotics online overnight expect some hand after.

flag x6d, from_lms 1
DRM(105806) win(5) lms 1 finished replaying gcs resources
DRM(105806) win(5) lms 1 finished fixing gcs write protocol
* lms 1 finished parallel drm freeze in DRM(105806) window 6, pcount 258

DRM(105806) win(6) lms 1 finished drm freeze
DRM(105806) win(6) lms 1 finished replaying gcs resources*** 2013-08-21 13:49:18.303
DRM(105806) win(6) lms 1 finished fixing gcs write protocol
* lms 1 finished parallel drm freeze in DRM(105806) window 7, pcount 258
DRM(105806) win(7) lms 1 finished drm freeze
DRM(105806) win(7) lms 1 finished replaying gcs resources
DRM(105806) win(7) lms 1 finished fixing gcs write protocol
* lms 1 finished parallel drm freeze in DRM(105806) window 8, pcount 258
DRM(105806) win(8) lms 1 finished drm freeze
DRM(105806) win(8) lms 1 finished replaying gcs resources
DRM(105806) win(8) lms 1 finished fixing gcs write protocol

These warnings are produced when the instance receives a messages and either the RMno (Remastering number) or master are not the current one. This means that the message is obsolete after a DRM (Dynamic Resource Remastering). No action required. They do not indicate any issue.

So, these log files grow larger and larger because it occurred remaster so frequently in our exadata production system. Now 从业务角度来合理分配同一应用连接同一rac node, 最大限度的避免block resource remaster.