drm oracle,近距离接触RAC DRM

最新推荐文章于 2021-04-11 08:29:19 发布

是minno

最新推荐文章于 2021-04-11 08:29:19 发布

阅读量318

点赞数

文章标签： drm oracle

drm 是Oracle rac中独有的动态资源管理操作，我们听了很多关于DRM的理论，但是你是否亲眼见证过DRM, 今天我们就来看一下：

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

SQL>

SQL> select count(*) from gv$instance;

COUNT(*)

----------

SQL> create table drm_mac(t1 int) tablespace users;

Table created.

SQL> insert into drm_mac values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> alter system flush buffer_cache;

System altered.

SQL>select * from drm_mac;

----------

SQL> select object_id,data_object_id from dba_objects where object_name='DRM_MAC';

OBJECT_ID DATA_OBJECT_ID

---------- --------------

64046 64046

--FIRST FIND THE OBJECT IDS

With OBJ_IDS As

(Select DATA_Object_Id OBJECT_ID From Dba_Objects

Where Object_Name = 'DRM_MAC'), --注意替换这里！！！！！！！！！！！！！！！！！

Addr As (Select /*+ materialize */

Le_Addr, class, state From X$Bh, OBJ_IDS

Where Object_Id = Obj),

--NOW GET THE RESOURCE NAME IN HEX

Hexnames As (Select

Rtrim(B.Kjblname, ' '||chr(0)) Hexname

From X$Le A, X$Kjbl B, Addr

Where A.Le_Kjbl=B.Kjbllockp

and class = 1 and state <> 3

And A.Le_Addr = Addr.Le_Addr)

-- NOW FIND THE NODE MASTERS

Select A.Master_Node Mast, Count(*)

From Gv$Dlm_Ress A, Hexnames H

Where

Rtrim(A.Resource_Name, ' '||chr(0)) = H.Hexname

Group by A.Master_Node;

MAST COUNT(*)

---------- ----------

0 5

==> 说明DRM_MAC MASTER 在0节点,共5个BLOCk

对2节点的LMS进程做DRM TRACE

oradebug setospid 29295;

oradebug event trace[RAC_DRM] disk highest;

之后使用 lkdebug -m pkey data_object_id 来手动出发对DRM_MAC的REMASTER操作

注意即便是手动触发DRM也仅仅是将该OBJECT放入DRM ENQUEUE

*** 2012-11-27 09:27:20.728

Processing Oradebug command 'lkdebug -m pkey 64045'

*****************************************************************

GLOBAL ENQUEUE SERVICE DEBUG INFORMATION

----------------------------------------

Queued DRM request for pkey 64045.0, tobe master 1, flags x1

***************** End of lkdebug output *************************

Processing Oradebug command 'lkdebug -m pkey 64045'

*****************************************************************

GLOBAL ENQUEUE SERVICE DEBUG INFORMATION

----------------------------------------

kjdrrmq: pkey 64045.0 is already on the affinity request queue, old tobe == new tobe 1

***************** End of lkdebug output *************************

SQL> oradebug setmypid

Statement processed.

SQL> oradebug lkdebug -m pkey 64046;

--FIRST FIND THE OBJECT IDS

With OBJ_IDS As

(Select DATA_Object_Id OBJECT_ID From Dba_Objects

Where Object_Name = 'DRM_MAC'), --Customize

Addr As (Select /*+ materialize */

Le_Addr, class, state From X$Bh, OBJ_IDS

Where Object_Id = Obj),

--NOW GET THE RESOURCE NAME IN HEX

Hexnames As (Select

Rtrim(B.Kjblname, ' '||chr(0)) Hexname

From X$Le A, X$Kjbl B, Addr

Where A.Le_Kjbl=B.Kjbllockp

and class = 1 and state <> 3

And A.Le_Addr = Addr.Le_Addr)

-- NOW FIND THE NODE MASTERS

Select A.Master_Node Mast, Count(*)

From Gv$Dlm_Ress A, Hexnames H

Where

Rtrim(A.Resource_Name, ' '||chr(0)) = H.Hexname

Group by A.Master_Node;

MAST COUNT(*)

---------- ----------

1 5

通过 oradebug lkdebug -m pkey 将 MACLEAN_DRM REMASTER到2节点。

SQL> select * from v$gcspfmaster_info where DATA_OBJECT_ID=64045;

FILE_ID DATA_OBJECT_ID GC_MASTERIN CURRENT_MASTER PREVIOUS_MASTER REMASTER_CNT

---------- -------------- ----------- -------------- --------------- ------------

0 64046 Affinity 1 0 1

SQL> select * from gv$policy_history

where DATA_OBJECT_ID=64046

order by EVENT_DATE;

no rows selected

SQL> select * from x$object_policy_statistics;

no rows selected

*** 2013-11-15 04:08:35.191

2013-11-15 04:08:35.191065 : kjbldrmnextpkey: AFFINITY pkey 64046.0

pkey 64046.0 undo 0 stat 5 masters[1, 1->2] reminc 13 RM# 18

flg x7 type x0 afftime x8b0628ee, acquire time 0

nreplays by lms 0 = 0

benefit 0, total 0, remote 0, cr benefit 0, cr total 0, cr remote 0

kjblpkeydrmqscchk: Begin for pkey 64046/0 bkt[0->8191] read-mostly 0

kjblpkeydrmqscchk: End for pkey 64046.0

2013-11-15 04:08:35.191312 : DRM(20) quiesced basts [0-8191]

2013-11-15 04:08:35.197815 :

* lms acks DRMFRZ (8191)

* lms 0 finished parallel drm freeze in DRM(20) window 1, pcount 47

DRM(20) win(1) lms 0 finished drm freeze

2013-11-15 04:08:35.200436 :

* kjbrrcres: In this window: 278 GCS resources, 0 remastered

* In all windows: 278 GCS resources, 0 remastered

2013-11-15 04:08:35.201606 : kjbldrmnextpkey: AFFINITY pkey 64046.0

pkey 64046.0 undo 0 stat 5 masters[1, 1->2] reminc 13 RM# 18

flg x7 type x0 afftime x8b0628ee, acquire time 0

nreplays by lms 0 = 0

benefit 0, total 0, remote 0, cr benefit 0, cr total 0, cr remote 0

kjbldrmrpst: no more locks for pkey 64046.0, #lk 0, #rm 0, #replay 0, #dup 0 objscan 4

DRM(20) Completed replay (highb 8191)

DRM(20) win(1) lms 0 finished replaying gcs resources

kjbmprlst: DRMFRZ replay msg from 1 (clockp 0x92f96c18, 3)

0x1fe6a.5, 64046.0, x0, lockseq 0x13c5, reqid 0x3

state 0x100, 1 -> 0, role 0x0, wrt 0x0.0

GCS RESOURCE 0xb28963a0 hashq [0xbb4cdd38,0xbb4cdd38] name[0x1fe6a.5] pkey 64046.0

grant 0xb19a8370 cvt (nil) send (nil)@0,0 write (nil),0@65536

flag 0x0 mdrole 0x1 mode 1 scan 0.0 role LOCAL

disk: 0x0000.00000000 write: 0x0000.00000000 cnt 0x0 hist 0x0

xid 0x0000.000.00000000 sid 0 pkwait 0s rmacks 0

refpcnt 0 weak: 0x0000.00000000

pkey 64046.0 undo 0 stat 5 masters[1, 1->2] reminc 13 RM# 18

flg x7 type x0 afftime x8b0628ee, acquire time 0

nreplays by lms 0 = 0

benefit 0, total 0, remote 0, cr benefit 0, cr total 0, cr remote 0

hv 3 [stat 0x0, 1->1, wm 32768, RMno 0, reminc 3, dom 0]

kjga st 0x4, step 0.36.0, cinc 15, rmno 19, flags 0x20

lb 0, hb 8191, myb 8141, drmb 8141, apifrz 1

GCS SHADOW 0xb19a8370,4 resp[0xb28963a0,0x1fe6a.5] pkey 64046.0

grant 1 cvt 0 mdrole 0x1 st 0x100 lst 0x40 GRANTQ rl LOCAL

master 2 owner 1 sid 0 remote[0x92f96c18,3] hist 0x10c1430c0218619

history 0x19.0xc.0x6.0x1.0xc.0x6.0x5.0x6.0x1.0x0.

cflag 0x0 sender 0 flags 0x0 replay# 0 abast (nil).x0.1 dbmap (nil)

disk: 0x0000.00000000 write request: 0x0000.00000000

pi scn: 0x0000.00000000 sq[0xb28963d0,0xb28963d0]

msgseq 0x1 updseq 0x0 reqids[3,0,0] infop (nil) lockseq x13c5

GCS SHADOW END

GCS RESOURCE END

2013-11-15 04:08:35.204351 : 0 write requests issued in 72 GCS resources