asm磁盘组属性--9号文件
概述
ASM的元数据9号文件,是ASM属性目录,包含了磁盘组的属性信息。属性目录只有在磁盘组的compatible.asm属性设置为11.1或以上时才会存在,是磁盘组层面而非ASM实例层面的。它被用来细粒度的调整磁盘组的属性。有些属性只能在磁盘组创建时指定(如au_size),有些属性可以在任何时候指定(如disk_repair_time)。有些属性保存在磁盘头中(如au_size),有些属性被存储在【成员关系和状态表】中或磁盘头中,这取决于ASM的版本。每个磁盘组都具有一些磁盘组的属性,磁盘组属性用来细粒度的控制磁盘组的特性。大多数属性存放在属性目录并且可以通过查询v$asm_attribute视图获得。
查看磁盘组的重要属性
asm磁盘组属性有3种查看方式:
1)asmcmd lsattr
2)v$asm_attribute
3)9号元数据文件
asmcmd lsattr
- 查看不同版本属性值
11204
[grid@11gasm ~]$ asmcmd lsattr -G datadg -l
Name Value
access_control.enabled FALSE
access_control.umask 066
au_size 4194304
cell.smart_scan_capable FALSE
compatible.asm 11.2.0.0.0
compatible.rdbms 11.2.0.0.0
content.type data
disk_repair_time 4h
idp.boundary auto
idp.type dynamic
sector_size 512
19c
[grid@19crac1 ~]$ asmcmd lsattr -G datadg -l
Name Value
access_control.enabled FALSE
access_control.umask 066
appliance._partnering_type GENERIC
ate_conversion_done true
au_size 4194304
cell.smart_scan_capable FALSE
cell.sparse_dg allnonsparse
compatible.advm 19.0.0.0.0
compatible.asm 19.0.0.0.0
compatible.rdbms 10.1.0.0.0
content.check FALSE
content.type data
content_hardcheck.enabled FALSE
disk_repair_time 12.0h
failgroup_repair_time 24.0h
idp.boundary auto
idp.type dynamic
logical_sector_size 512
phys_meta_replicated true
preferred_read.enabled FALSE
scrub_async_limit 1
scrub_metadata.enabled TRUE
sector_size 512
thin_provisioned FALSE
vam_migration_done false
- asmcmd查看具体属性值和修改属性值
[grid@11gasm ~]$ asmcmd lsattr -G datadg -lm au_size
Group_Name Name Value RO Sys
DATADG au_size 4194304 Y Y
[grid@11gasm ~]$ asmcmd setattr -G datadg au_size ‘1M’
ORA-15032: not all alterations performed
ORA-15242: could not set attribute au_size
ORA-15241: attribute au_size is read only (DBD ERROR: OCIStmtExecute)
[grid@11gasm ~]$ asmcmd setattr -G datadg compatible.rdbms ‘11.2.0.0.0’
[grid@11gasm ~]$ asmcmd lsattr -G datadg -lm compatible.rdbms
Group_Name Name Value RO Sys
DATADG compatible.rdbms 11.2.0.0.0 N Y
[grid@11gasm ~]$ asmcmd setattr -G datadg compatible.asm ‘11.2.0.4.0’
[grid@11gasm ~]$ asmcmd lsattr -G datadg -lm compatible.asm
Group_Name Name Value RO Sys
DATADG compatible.asm 11.2.0.4.0 N Y
字段v$asm_attribute.read_only为N的,才可以修改,为N的,必须在磁盘组创建的时候指定。
v$asm_attribute
大多数属性存放在属性目录并且可以通过查询v$asm_attribute视图获得。我们通过查询这个视图来看下我的所有磁盘组的属性信息:
SQL> set pages 1000 lines 1000
SQL> col value for a20
SQL> col name for a50
SQL> select * from v$asm_attribute;
NAME VALUE GROUP_NUMBER ATTRIBUTE_INDEX ATTRIBUTE_INCARNATION READ_ON SYSTEM_
-------------------------------------------------- -------------------- ------------ --------------- --------------------- ------- -------
disk_repair_time 3.6h 1 0 1 N Y
au_size 4194304 1 5 1 Y Y
sector_size 512 1 6 1 Y Y
compatible.asm 11.2.0.4.0 1 20 1 N Y
compatible.rdbms 11.2.0.0.0 1 21 1 N Y
cell.smart_scan_capable FALSE 1 30 1 N N
access_control.enabled FALSE 1 40 1 N Y
access_control.umask 066 1 41 1 N Y
template_version 186646528 1 50 1 N Y
template.PARAMETERFILE.stripe 0 1 71 1 N Y
template.PARAMETERFILE.redundancy 17 1 74 1 N Y
template.PARAMETERFILE.primary_region 0 1 75 1 N Y
template.PARAMETERFILE.mirror_region 0 1 76 1 N Y
template.ASMPARAMETERFILE.stripe 0 1 81 1 N Y
template.ASMPARAMETERFILE.redundancy 17 1 84 1 N Y
template.ASMPARAMETERFILE.primary_region 0 1 85 1 N Y
template.ASMPARAMETERFILE.mirror_region 0 1 86 1 N Y
template.DUMPSET.stripe 0 1 101 1 N Y
template.DUMPSET.redundancy 17 1 104 1 N Y
template.DUMPSET.primary_region 0 1 105 1 N Y
template.DUMPSET.mirror_region 0 1 106 1 N Y
template.CONTROLFILE.stripe 1 1 111 1 N Y
template.CONTROLFILE.redundancy 17 1 114 1 N Y
template.CONTROLFILE.primary_region 0 1 115 1 N Y
template.CONTROLFILE.mirror_region 0 1 116 1 N Y
template.FLASHFILE.stripe 0 1 121 1 N Y
template.FLASHFILE.redundancy 17 1 124 1 N Y
template.FLASHFILE.primary_region 0 1 125 1 N Y
template.FLASHFILE.mirror_region 0 1 126 1 N Y
template.ARCHIVELOG.stripe 0 1 131 1 N Y
template.ARCHIVELOG.redundancy 17 1 134 1 N Y
template.ARCHIVELOG.primary_region 0 1 135 1 N Y
template.ARCHIVELOG.mirror_region 0 1 136 1 N Y
template.ONLINELOG.stripe 0 1 141 1 N Y
template.ONLINELOG.redundancy 17 1 144 1 N Y
template.ONLINELOG.primary_region 0 1 145 1 N Y
template.ONLINELOG.mirror_region 0 1 146 1 N Y
template.DATAFILE.stripe 0 1 151 1 N Y
template.DATAFILE.redundancy 17 1 154 1 N Y
template.DATAFILE.primary_region 0 1 155 1 N Y
template.DATAFILE.mirror_region 0 1 156 1 N Y
template.TEMPFILE.stripe 0 1 161 1 N Y
template.TEMPFILE.redundancy 17 1 164 1 N Y
template.TEMPFILE.primary_region 0 1 165 1 N Y
template.TEMPFILE.mirror_region 0 1 166 1 N Y
template.BACKUPSET.stripe 0 1 181 1 N Y
template.BACKUPSET.redundancy 17 1 184 1 N Y
template.BACKUPSET.primary_region 0 1 185 1 N Y
template.BACKUPSET.mirror_region 0 1 186 1 N Y
template.XTRANSPORT BACKUPSET.stripe 0 1 191 1 N Y
template.XTRANSPORT BACKUPSET.redundancy 17 1 194 1 N Y
template.XTRANSPORT BACKUPSET.primary_region 0 1 195 1 N Y
template.XTRANSPORT BACKUPSET.mirror_region 0 1 196 1 N Y
template.AUTOBACKUP.stripe 0 1 201 1 N Y
template.AUTOBACKUP.redundancy 17 1 204 1 N Y
template.AUTOBACKUP.primary_region 0 1 205 1 N Y
template.AUTOBACKUP.mirror_region 0 1 206 1 N Y
template.XTRANSPORT.stripe 0 1 211 1 N Y
template.XTRANSPORT.redundancy 17 1 214 1 N Y
template.XTRANSPORT.primary_region 0 1 215 1 N Y
template.XTRANSPORT.mirror_region 0 1 216 1 N Y
template.CHANGETRACKING.stripe 0 1 221 1 N Y
template.CHANGETRACKING.redundancy 17 1 224 1 N Y
template.CHANGETRACKING.primary_region 0 1 225 1 N Y
template.CHANGETRACKING.mirror_region 0 1 226 1 N Y
template.FLASHBACK.stripe 0 1 231 1 N Y
template.FLASHBACK.redundancy 17 1 234 1 N Y
template.FLASHBACK.primary_region 0 1 235 1 N Y
template.FLASHBACK.mirror_region 0 1 236 1 N Y
template.DATAGUARDCONFIG.stripe 0 1 241 1 N Y
template.DATAGUARDCONFIG.redundancy 17 1 244 1 N Y
template.DATAGUARDCONFIG.primary_region 0 1 245 1 N Y
template.DATAGUARDCONFIG.mirror_region 0 1 246 1 N Y
template.OCRFILE.stripe 0 1 251 1 N Y
template.OCRFILE.redundancy 17 1 254 1 N Y
template.OCRFILE.primary_region 0 1 255 1 N Y
template.OCRFILE.mirror_region 0 1 256 1 N Y
idp.type dynamic 1 280 1 N Y
idp.boundary auto 1 281 1 N Y
content.type data 1 290 1 N Y
80 rows selected.
根据视图修改磁盘组属性值:
SQL> alter diskgroup datadg set attribute 'sector_size'='1024';
alter diskgroup datadg set attribute 'sector_size'='1024'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute sector_size
ORA-15241: attribute sector_size is read only
SQL> alter diskgroup datadg set attribute 'disk_repair_time'=4h;
alter diskgroup datadg set attribute 'disk_repair_time'=4h
*
ERROR at line 1:
ORA-15214: missing or invalid attribute specification
SQL> alter diskgroup datadg set attribute "disk_repair_time"=4h;
alter diskgroup datadg set attribute "disk_repair_time"=4h
*
ERROR at line 1:
ORA-15214: missing or invalid attribute specification
SQL> alter diskgroup datadg set attribute 'disk_repair_time'='4h';
Diskgroup altered.
注意单引号。
字段v$asm_attribute.read_only为N的,才可以修改。为Y的,必须在磁盘组创建的时候指定。
扩展此字段的语法:
ALTER DISKGROUP SET ATTRIBUTE 'DISK_REPAIR_TIME'='2D4H30M'
9号元数据文件(隐藏的属性)
[grid@11gasm ~]$ kfed read /dev/asm_data01 aus=4194304 aun=2 blkn=9|more --定位9号文件的文件目录
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 4 ; 0x002: KFBTYP_FILEDIR
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 9 ; 0x004: blk=9
kfbh.block.obj: 1 ; 0x008: file=1
kfbh.check: 69688603 ; 0x00c: 0x04275d1b
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfffdb.node.incarn: 1 ; 0x000: A=1 NUMM=0x0
kfffdb.node.frlist.number: 4294967295 ; 0x004: 0xffffffff
kfffdb.node.frlist.incarn: 0 ; 0x008: A=0 NUMM=0x0
kfffdb.hibytes: 0 ; 0x00c: 0x00000000
kfffdb.lobytes: 1048576 ; 0x010: 0x00100000
kfffdb.xtntcnt: 1 ; 0x014: 0x00000001
kfffdb.xtnteof: 1 ; 0x018: 0x00000001
kfffdb.blkSize: 4096 ; 0x01c: 0x00001000
kfffdb.flags: 17 ; 0x020: O=1 S=0 S=0 D=0 C=1 I=0 R=0 A=0
kfffdb.fileType: 15 ; 0x021: 0x0f
kfffdb.dXrs: 17 ; 0x022: SCHE=0x1 NUMB=0x1
kfffdb.iXrs: 17 ; 0x023: SCHE=0x1 NUMB=0x1
kfffdb.dXsiz[0]: 4294967295 ; 0x024: 0xffffffff
kfffdb.dXsiz[1]: 0 ; 0x028: 0x00000000
kfffdb.dXsiz[2]: 0 ; 0x02c: 0x00000000
kfffdb.iXsiz[0]: 4294967295 ; 0x030: 0xffffffff
kfffdb.iXsiz[1]: 0 ; 0x034: 0x00000000
kfffdb.iXsiz[2]: 0 ; 0x038: 0x00000000
kfffdb.xtntblk: 1 ; 0x03c: 0x0001
kfffdb.break: 60 ; 0x03e: 0x003c
kfffdb.priZn: 0 ; 0x040: KFDZN_COLD
kfffdb.secZn: 0 ; 0x041: KFDZN_COLD
kfffdb.ub2spare: 0 ; 0x042: 0x0000
kfffdb.alias[0]: 4294967295 ; 0x044: 0xffffffff
kfffdb.alias[1]: 4294967295 ; 0x048: 0xffffffff
kfffdb.strpwdth: 0 ; 0x04c: 0x00
kfffdb.strpsz: 0 ; 0x04d: 0x00
kfffdb.usmsz: 0 ; 0x04e: 0x0000
kfffdb.crets.hi: 33090551 ; 0x050: HOUR=0x17 DAYS=0x1f MNTH=0xa YEAR=0x7e3
kfffdb.crets.lo: 518444032 ; 0x054: USEC=0x0 MSEC=0x1b5 SECS=0x2e MINS=0x7
kfffdb.modts.hi: 0 ; 0x058: HOUR=0x0 DAYS=0x0 MNTH=0x0 YEAR=0x0
kfffdb.modts.lo: 0 ; 0x05c: USEC=0x0 MSEC=0x0 SECS=0x0 MINS=0x0
kfffdb.dasz[0]: 0 ; 0x060: 0x00
kfffdb.dasz[1]: 0 ; 0x061: 0x00
kfffdb.dasz[2]: 0 ; 0x062: 0x00
kfffdb.dasz[3]: 0 ; 0x063: 0x00
kfffdb.permissn: 0 ; 0x064: 0x00
kfffdb.ub1spar1: 0 ; 0x065: 0x00
kfffdb.ub2spar2: 0 ; 0x066: 0x0000
kfffdb.user.entnum: 0 ; 0x068: 0x0000
kfffdb.user.entinc: 0 ; 0x06a: 0x0000
kfffdb.group.entnum: 0 ; 0x06c: 0x0000
kfffdb.group.entinc: 0 ; 0x06e: 0x0000
kfffdb.spare[0]: 0 ; 0x070: 0x00000000
kfffdb.spare[1]: 0 ; 0x074: 0x00000000
kfffdb.spare[2]: 0 ; 0x078: 0x00000000
kfffdb.spare[3]: 0 ; 0x07c: 0x00000000
kfffdb.spare[4]: 0 ; 0x080: 0x00000000
kfffdb.spare[5]: 0 ; 0x084: 0x00000000
kfffdb.spare[6]: 0 ; 0x088: 0x00000000
kfffdb.spare[7]: 0 ; 0x08c: 0x00000000
kfffdb.spare[8]: 0 ; 0x090: 0x00000000
kfffdb.spare[9]: 0 ; 0x094: 0x00000000
kfffdb.spare[10]: 0 ; 0x098: 0x00000000
kfffdb.spare[11]: 0 ; 0x09c: 0x00000000
kfffdb.usm: ; 0x0a0: length=0
kfffde[0].xptr.au: 10 ; 0x4a0: 0x0000000a --AU分布在AU10
kfffde[0].xptr.disk: 1 ; 0x4a4: 0x0001
kfffde[0].xptr.flags: 0 ; 0x4a6: L=0 E=0 D=0 S=0
kfffde[0].xptr.chk: 33 ; 0x4a7: 0x21
kfffde[1].xptr.au: 4294967295 ; 0x4a8: 0xffffffff
kfffde[1].xptr.disk: 65535 ; 0x4ac: 0xffff
kfffde[1].xptr.flags: 0 ; 0x4ae: L=0 E=0 D=0 S=0
kfffde[1].xptr.chk: 42 ; 0x4af: 0x2a
kfffde[2].xptr.au: 4294967295 ; 0x4b0: 0xffffffff
kfffde[2].xptr.disk: 65535 ; 0x4b4: 0xffff
kfffde[2].xptr.flags: 0 ; 0x4b6: L=0 E=0 D=0 S=0
kfffde[2].xptr.chk: 42 ; 0x4b7: 0x2a
kfffde[3].xptr.au: 4294967295 ; 0x4b8: 0xffffffff
[grid@11gasm ~]$ kfed read /dev/asm_data02 aus=4194304 aun=10 blkn=0 --查看9号文件的具体AU值
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 23 ; 0x002: KFBTYP_ATTRDIR
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: blk=0
kfbh.block.obj: 9 ; 0x008: file=9
kfbh.check: 2154115585 ; 0x00c: 0x80653201
kfbh.fcn.base: 2764 ; 0x010: 0x00000acc
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kffdnd.bnode.incarn: 1 ; 0x000: A=1 NUMM=0x0
kffdnd.bnode.frlist.number: 4294967295 ; 0x004: 0xffffffff
kffdnd.bnode.frlist.incarn: 0 ; 0x008: A=0 NUMM=0x0
kffdnd.overfl.number: 5 ; 0x00c: 0x00000005
kffdnd.overfl.incarn: 1 ; 0x010: A=1 NUMM=0x0
kffdnd.parent.number: 0 ; 0x014: 0x00000000
kffdnd.parent.incarn: 1 ; 0x018: A=1 NUMM=0x0
kffdnd.fstblk.number: 0 ; 0x01c: 0x00000000
kffdnd.fstblk.incarn: 1 ; 0x020: A=1 NUMM=0x0
kfede[0].entry.incarn: 1 ; 0x024: A=1 NUMM=0x0
kfede[0].entry.hash: 0 ; 0x028: 0x00000000
kfede[0].entry.refer.number: 4294967295 ; 0x02c: 0xffffffff
kfede[0].entry.refer.incarn: 0 ; 0x030: A=0 NUMM=0x0
kfede[0].name: disk_repair_time ; 0x034: length=16
kfede[0].value: 4h6h ; 0x074: length=4
kfede[0].length: 2 ; 0x174: 0x0002
kfede[0].flags: 16 ; 0x176: R=0 D=0 H=0 H=0 S=1 C=0 S=0 V=0 I=0
kfede[0].spare1[0]: 0 ; 0x178: 0x00000000
kfede[0].spare1[1]: 0 ; 0x17c: 0x00000000
kfede[0].spare1[2]: 0 ; 0x180: 0x00000000
kfede[0].spare1[3]: 0 ; 0x184: 0x00000000
kfede[0].spare1[4]: 0 ; 0x188: 0x00000000
kfede[0].spare1[5]: 0 ; 0x18c: 0x00000000
kfede[0].spare1[6]: 0 ; 0x190: 0x00000000
kfede[0].spare1[7]: 0 ; 0x194: 0x00000000
kfede[1].entry.incarn: 1 ; 0x198: A=1 NUMM=0x0
kfede[1].entry.hash: 0 ; 0x19c: 0x00000000
kfede[1].entry.refer.number: 4294967295 ; 0x1a0: 0xffffffff
kfede[1].entry.refer.incarn: 0 ; 0x1a4: A=0 NUMM=0x0
kfede[1].name: _rebalance_compact ; 0x1a8: length=18
kfede[1].value: FALSE ; 0x1e8: length=5
kfede[1].length: 5 ; 0x2e8: 0x0005
kfede[1].flags: 20 ; 0x2ea: R=0 D=0 H=1 H=0 S=1 C=0 S=0 V=0 I=0
kfede[1].spare1[0]: 0 ; 0x2ec: 0x00000000
kfede[1].spare1[1]: 0 ; 0x2f0: 0x00000000
kfede[1].spare1[2]: 0 ; 0x2f4: 0x00000000
kfede[1].spare1[3]: 0 ; 0x2f8: 0x00000000
kfede[1].spare1[4]: 0 ; 0x2fc: 0x00000000
kfede[1].spare1[5]: 0 ; 0x300: 0x00000000
kfede[1].spare1[6]: 0 ; 0x304: 0x00000000
kfede[1].spare1[7]: 0 ; 0x308: 0x00000000
kfede[2].entry.incarn: 1 ; 0x30c: A=1 NUMM=0x0
kfede[2].entry.hash: 0 ; 0x310: 0x00000000
kfede[2].entry.refer.number: 4294967295 ; 0x314: 0xffffffff
kfede[2].entry.refer.incarn: 0 ; 0x318: A=0 NUMM=0x0
kfede[2].name: _extent_sizes ; 0x31c: length=13
kfede[2].value: 1 4 16 ; 0x35c: length=6
kfede[2].length: 6 ; 0x45c: 0x0006
kfede[2].flags: 22 ; 0x45e: R=0 D=1 H=1 H=0 S=1 C=0 S=0 V=0 I=0
kfede[2].spare1[0]: 0 ; 0x460: 0x00000000
kfede[2].spare1[1]: 0 ; 0x464: 0x00000000
kfede[2].spare1[2]: 0 ; 0x468: 0x00000000
kfede[2].spare1[3]: 0 ; 0x46c: 0x00000000
kfede[2].spare1[4]: 0 ; 0x470: 0x00000000
kfede[2].spare1[5]: 0 ; 0x474: 0x00000000
kfede[2].spare1[6]: 0 ; 0x478: 0x00000000
kfede[2].spare1[7]: 0 ; 0x47c: 0x00000000
kfede[3].entry.incarn: 1 ; 0x480: A=1 NUMM=0x0
kfede[3].entry.hash: 0 ; 0x484: 0x00000000
kfede[3].entry.refer.number: 4294967295 ; 0x488: 0xffffffff
kfede[3].entry.refer.incarn: 0 ; 0x48c: A=0 NUMM=0x0
kfede[3].name: _extent_counts ; 0x490: length=14
kfede[3].value: 20000 20000 2147483647 ; 0x4d0: length=22
kfede[3].length: 22 ; 0x5d0: 0x0016
kfede[3].flags: 22 ; 0x5d2: R=0 D=1 H=1 H=0 S=1 C=0 S=0 V=0 I=0
kfede[3].spare1[0]: 0 ; 0x5d4: 0x00000000
kfede[3].spare1[1]: 0 ; 0x5d8: 0x00000000
kfede[3].spare1[2]: 0 ; 0x5dc: 0x00000000
kfede[3].spare1[3]: 0 ; 0x5e0: 0x00000000
kfede[3].spare1[4]: 0 ; 0x5e4: 0x00000000
kfede[3].spare1[5]: 0 ; 0x5e8: 0x00000000
kfede[3].spare1[6]: 0 ; 0x5ec: 0x00000000
kfede[3].spare1[7]: 0 ; 0x5f0: 0x00000000
kfede[4].entry.incarn: 1 ; 0x5f4: A=1 NUMM=0x0
kfede[4].entry.hash: 0 ; 0x5f8: 0x00000000
kfede[4].entry.refer.number: 1 ; 0x5fc: 0x00000001
kfede[4].entry.refer.incarn: 1 ; 0x600: A=1 NUMM=0x0
kfede[4].name: _ ; 0x604: length=1
kfede[4].value: 0 ; 0x644: length=1
kfede[4].length: 1 ; 0x744: 0x0001
kfede[4].flags: 22 ; 0x746: R=0 D=1 H=1 H=0 S=1 C=0 S=0 V=0 I=0
kfede[4].spare1[0]: 0 ; 0x748: 0x00000000
kfede[4].spare1[1]: 0 ; 0x74c: 0x00000000
kfede[4].spare1[2]: 0 ; 0x750: 0x00000000
kfede[4].spare1[3]: 0 ; 0x754: 0x00000000
kfede[4].spare1[4]: 0 ; 0x758: 0x00000000
kfede[4].spare1[5]: 0 ; 0x75c: 0x00000000
kfede[4].spare1[6]: 0 ; 0x760: 0x00000000
kfede[4].spare1[7]: 0 ; 0x764: 0x00000000
kfede[5].entry.incarn: 1 ; 0x768: A=1 NUMM=0x0
kfede[5].entry.hash: 0 ; 0x76c: 0x00000000
kfede[5].entry.refer.number: 4294967295 ; 0x770: 0xffffffff
kfede[5].entry.refer.incarn: 0 ; 0x774: A=0 NUMM=0x0
kfede[5].name: au_size ; 0x778: length=7
kfede[5].value: <virtual> ; 0x7b8: length=9
kfede[5].length: 9 ; 0x8b8: 0x0009
kfede[5].flags: 147 ; 0x8ba: R=1 D=1 H=0 H=0 S=1 C=0 S=0 V=1 I=0
kfede[5].spare1[0]: 0 ; 0x8bc: 0x00000000
kfede[5].spare1[1]: 0 ; 0x8c0: 0x00000000
kfede[5].spare1[2]: 0 ; 0x8c4: 0x00000000
kfede[5].spare1[3]: 0 ; 0x8c8: 0x00000000
kfede[5].spare1[4]: 0 ; 0x8cc: 0x00000000
kfede[5].spare1[5]: 0 ; 0x8d0: 0x00000000
kfede[5].spare1[6]: 0 ; 0x8d4: 0x00000000
kfede[5].spare1[7]: 0 ; 0x8d8: 0x00000000
kfede[6].entry.incarn: 1 ; 0x8dc: A=1 NUMM=0x0
kfede[6].entry.hash: 0 ; 0x8e0: 0x00000000
kfede[6].entry.refer.number: 4294967295 ; 0x8e4: 0xffffffff
kfede[6].entry.refer.incarn: 0 ; 0x8e8: A=0 NUMM=0x0
kfede[6].name: sector_size ; 0x8ec: length=11
kfede[6].value: <virtual> ; 0x92c: length=9
kfede[6].length: 9 ; 0xa2c: 0x0009
kfede[6].flags: 147 ; 0xa2e: R=1 D=1 H=0 H=0 S=1 C=0 S=0 V=1 I=0
kfede[6].spare1[0]: 0 ; 0xa30: 0x00000000
kfede[6].spare1[1]: 0 ; 0xa34: 0x00000000
kfede[6].spare1[2]: 0 ; 0xa38: 0x00000000
kfede[6].spare1[3]: 0 ; 0xa3c: 0x00000000
kfede[6].spare1[4]: 0 ; 0xa40: 0x00000000
kfede[6].spare1[5]: 0 ; 0xa44: 0x00000000
kfede[6].spare1[6]: 0 ; 0xa48: 0x00000000
kfede[6].spare1[7]: 0 ; 0xa4c: 0x00000000
kfede[7].entry.incarn: 1 ; 0xa50: A=1 NUMM=0x0
kfede[7].entry.hash: 0 ; 0xa54: 0x00000000
kfede[7].entry.refer.number: 2 ; 0xa58: 0x00000002
kfede[7].entry.refer.incarn: 1 ; 0xa5c: A=1 NUMM=0x0
kfede[7].name: compatible ; 0xa60: length=10
kfede[7].value: <virtual> ; 0xaa0: length=9
kfede[7].length: 9 ; 0xba0: 0x0009
kfede[7].flags: 178 ; 0xba2: R=0 D=1 H=0 H=0 S=1 C=1 S=0 V=1 I=0
kfede[7].spare1[0]: 0 ; 0xba4: 0x00000000
kfede[7].spare1[1]: 0 ; 0xba8: 0x00000000
kfede[7].spare1[2]: 0 ; 0xbac: 0x00000000
kfede[7].spare1[3]: 0 ; 0xbb0: 0x00000000
kfede[7].spare1[4]: 0 ; 0xbb4: 0x00000000
kfede[7].spare1[5]: 0 ; 0xbb8: 0x00000000
kfede[7].spare1[6]: 0 ; 0xbbc: 0x00000000
kfede[7].spare1[7]: 0 ; 0xbc0: 0x00000000
kfede[8].entry.incarn: 1 ; 0xbc4: A=1 NUMM=0x0
kfede[8].entry.hash: 0 ; 0xbc8: 0x00000000
kfede[8].entry.refer.number: 3 ; 0xbcc: 0x00000003
kfede[8].entry.refer.incarn: 1 ; 0xbd0: A=1 NUMM=0x0
kfede[8].name: cell ; 0xbd4: length=4
kfede[8].value: FALSE ; 0xc14: length=5
kfede[8].length: 5 ; 0xd14: 0x0005
kfede[8].flags: 34 ; 0xd16: R=0 D=1 H=0 H=0 S=0 C=1 S=0 V=0 I=0
kfede[8].spare1[0]: 0 ; 0xd18: 0x00000000
kfede[8].spare1[1]: 0 ; 0xd1c: 0x00000000
kfede[8].spare1[2]: 0 ; 0xd20: 0x00000000
kfede[8].spare1[3]: 0 ; 0xd24: 0x00000000
kfede[8].spare1[4]: 0 ; 0xd28: 0x00000000
kfede[8].spare1[5]: 0 ; 0xd2c: 0x00000000
kfede[8].spare1[6]: 0 ; 0xd30: 0x00000000
kfede[8].spare1[7]: 0 ; 0xd34: 0x00000000
kfede[9].entry.incarn: 1 ; 0xd38: A=1 NUMM=0x0
kfede[9].entry.hash: 0 ; 0xd3c: 0x00000000
kfede[9].entry.refer.number: 4 ; 0xd40: 0x00000004
kfede[9].entry.refer.incarn: 1 ; 0xd44: A=1 NUMM=0x0
kfede[9].name: access_control ; 0xd48: length=14
kfede[9].value: FALSE ; 0xd88: length=5
kfede[9].length: 5 ; 0xe88: 0x0005
kfede[9].flags: 18 ; 0xe8a: R=0 D=1 H=0 H=0 S=1 C=0 S=0 V=0 I=0
kfede[9].spare1[0]: 0 ; 0xe8c: 0x00000000
kfede[9].spare1[1]: 0 ; 0xe90: 0x00000000
kfede[9].spare1[2]: 0 ; 0xe94: 0x00000000
kfede[9].spare1[3]: 0 ; 0xe98: 0x00000000
kfede[9].spare1[4]: 0 ; 0xe9c: 0x00000000
kfede[9].spare1[5]: 0 ; 0xea0: 0x00000000
kfede[9].spare1[6]: 0 ; 0xea4: 0x00000000
kfede[9].spare1[7]: 0 ; 0xea8: 0x00000000
为了看属性值,我们可以过滤下
[grid@11gasm ~]$ kfed read /dev/asm_data02 aus=4194304 aun=10 blkn=0|egrep "name|value"
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 23 ; 0x002: KFBTYP_ATTRDIR
kfbh.datfmt: 1 ; 0x003: 0x01
。。。。。。
kfede[0].name: disk_repair_time ; 0x034: length=16
kfede[0].value: 3.6h ; 0x074: length=4
kfede[1].name: _rebalance_compact ; 0x1a8: length=18
kfede[1].value: TRUE ; 0x1e8: length=4
kfede[2].name: _extent_sizes ; 0x31c: length=13
kfede[2].value: 1 4 16 ; 0x35c: length=6
kfede[3].name: _extent_counts ; 0x490: length=14
kfede[3].value: 20000 20000 2147483647 ; 0x4d0: length=22
kfede[4].name: _ ; 0x604: length=1
kfede[4].value: 0 ; 0x644: length=1
kfede[5].name: au_size ; 0x778: length=7
kfede[5].value: <virtual> ; 0x7b8: length=9
kfede[6].name: sector_size ; 0x8ec: length=11
kfede[6].value: <virtual> ; 0x92c: length=9
kfede[7].name: compatible ; 0xa60: length=10
kfede[7].value: <virtual> ; 0xaa0: length=9
kfede[8].name: cell ; 0xbd4: length=4
kfede[8].value: FALSE ; 0xc14: length=5
kfede[9].name: access_control ; 0xd48: length=14
kfede[9].value: FALSE ; 0xd88: length=5
隐藏的属性:kfede[i]字段包含了磁盘组属性的名称和值。
以上,我们还窥探到了许多隐藏的磁盘组属性。我们看到_REBALANCE_COMPACT属性是TRUE。这个属性关系到磁盘组rebalance中的compact环节。
我们还可以看到extent的增长方式(_EXTENT_SIZES),初始化大小会从1个AU到4个AU再到16AU。_EXTENT_COUNTS表示extent增长的断点,前20000个extent只包含1个AU,
接下来20000个extent包含4个AU,再往后的extent都会包含16个AU。
磁盘组属性和asm实例参数区别:
上述的隐藏属性名称和parameter查询出来参数名称长的很像,如下:
PARAMETER SESSION_VALUE INSTANCE_VALUE DESCRIPTION
---------------------------------------- -------------------- -------------------- ------------------------------------------------------------
_asm_disk_repair_time 14400 14400 seconds to wait before dropping a failing disk
_disable_rebalance_compact FALSE FALSE disable space usage checks for storage reconfiguration
设置asm实例参数值
SQL> alter system set "_disable_rebalance_compact"=true;
System altered.
SQL> alter system set "_rebalance_compact"=false;
alter system set "_rebalance_compact"=false
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
不识别asm磁盘组属性查询出来的隐藏参数
设置隐藏属性值:
SQL> ALTER DISKGROUP datadg SET ATTRIBUTE '_rebalance_compact'='FALSE';
Diskgroup altered.
参数asm实例的,针对所有asm磁盘组都生效,属性值是针对单个磁盘组的,对单个磁盘组生效。
两者设置的方法不一样:
参数:alter system set
属性值:
1)隐藏的属性值:ALTER DISKGROUP datadg SET ATTRIBUTE ;
2)asmcmd lsattr能查询出来的属性值: asmcmd setattr