- 最后登录
- 2016-8-16
- 在线时间
- 147 小时
- 威望
- 207
- 金钱
- 2622
- 注册时间
- 2011-10-31
- 阅读权限
- 60
- 帖子
- 170
- 精华
- 0
- 积分
- 207
- UID
- 75
|
1#
发表于 2013-3-21 11:08:10
|
查看: 3359 |
回复: 2
本帖最后由 gtlions 于 2013-3-21 11:09 编辑
版本OEL5.7 86_64+ORA 11GR2+GRID+ASM
我想通过kfed查看某个文件的au分布,比如非元数据265号文件:- sys@GT11G> show parameter spfile;
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- spfile string +DATA01/gt11g/spfilegt11g.ora
- +ASM> select name,group_number,file_number from v$asm_alias where lower(name)='spfilegt11g.ora';
- NAME GROUP_NUMBER FILE_NUMBER
- -------------------- ------------ -----------
- spfileGT11G.ora 1 265
- +ASM> select name,group_number from v$asm_diskgroup;
- NAME GROUP_NUMBER
- -------- ------------
- DATA01 1
- FRA 2
- SYSDG 3
- +ASM> select group_kffxp,number_kffxp,pxn_kffxp,xnum_kffxp,disk_kffxp from x$kffxp where group_kffxp=1 and number_kffxp=265;
- GROUP_KFFXP NUMBER_KFFXP PXN_KFFXP XNUM_KFFXP DISK_KFFXP
- ----------- ------------ ---------- ---------- ----------
- 1 265 0 0 1
- +ASM> select group_number,disk_number,path from v$asm_disk where group_number=1 and disk_number=0;
- GROUP_NUMBER DISK_NUMBER PATH
- ------------ ----------- --------------------
- 1 0 /dev/asm11g-f
- [grid@gtser2 ~]$ kfed read /dev/asm11g-f aun=2 blkn=1 | more
- kfbh.endian: 1 ; 0x000: 0x01
- kfbh.hard: 130 ; 0x001: 0x82
- kfbh.type: 4 ; 0x002: KFBTYP_FILEDIR
- kfbh.datfmt: 1 ; 0x003: 0x01
- kfbh.block.blk: 1 ; 0x004: blk=1
- kfbh.block.obj: 1 ; 0x008: file=1
- kfbh.check: 4093010779 ; 0x00c: 0xf3f6635b
- kfbh.fcn.base: 443 ; 0x010: 0x000001bb
- 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: 2097152 ; 0x010: 0x00200000
- kfffdb.xtntcnt: 2 ; 0x014: 0x00000002
- kfffdb.xtnteof: 2 ; 0x018: 0x00000002
- kfffdb.blkSize: 4096 ; 0x01c: 0x00001000
- kfffdb.flags: 1 ; 0x020: O=1 S=0 S=0 D=0 C=0 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: 2 ; 0x03c: 0x0002
- 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: 32984682 ; 0x050: HOUR=0xa DAYS=0x13 MNTH=0x3 YEAR=0x7dd
- kfffdb.crets.lo: 3985358848 ; 0x054: USEC=0x0 MSEC=0x2f0 SECS=0x18 MINS=0x3b
- kfffdb.modts.hi: 32984682 ; 0x058: HOUR=0xa DAYS=0x13 MNTH=0x3 YEAR=0x7dd
- kfffdb.modts.lo: 3985358848 ; 0x05c: USEC=0x0 MSEC=0x2f0 SECS=0x18 MINS=0x3b
- 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.usm: ; 0x0a0: length=0
- kfffde[0].xptr.au: 2 ; 0x4a0: 0x00000002
- kfffde[0].xptr.disk: 0 ; 0x4a4: 0x0000
- kfffde[0].xptr.flags: 0 ; 0x4a6: L=0 E=0 D=0 S=0
- kfffde[0].xptr.chk: 40 ; 0x4a7: 0x28
- kfffde[1].xptr.au: 31 ; 0x4a8: 0x0000001f
- kfffde[1].xptr.disk: 1 ; 0x4ac: 0x0001
- kfffde[1].xptr.flags: 0 ; 0x4ae: L=0 E=0 D=0 S=0
- kfffde[1].xptr.chk: 52 ; 0x4af: 0x34
- +ASM> select group_number,disk_number,path from v$asm_disk where group_number=1 and disk_number=1;
- GROUP_NUMBER DISK_NUMBER PATH
- ------------ ----------- --------------------
- 1 1 /dev/asm11g-g
复制代码 通过上述信息,我得到的是:
256文件开始相关的au分布信息是存放在磁盘1的au31位置,但是我通过kfed查看该位置的信息居然不对:- [grid@gtser2 ~]$ kfed read /dev/asm11g-g aun=31 blkn=11 | more
- kfbh.endian: 1 ; 0x000: 0x01
- kfbh.hard: 130 ; 0x001: 0x82
- kfbh.type: 4 ; 0x002: KFBTYP_FILEDIR
- kfbh.datfmt: 1 ; 0x003: 0x01
- kfbh.block.blk: 267 ; 0x004: blk=267
- kfbh.block.obj: 1 ; 0x008: file=1
- kfbh.check: 17072832 ; 0x00c: 0x010482c0
- kfbh.fcn.base: 199 ; 0x010: 0x000000c7
- kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
- kfbh.spare1: 0 ; 0x018: 0x00000000
- kfbh.spare2: 0 ; 0x01c: 0x00000000
- kfffdb.node.incarn: 0 ; 0x000: A=0 NUMM=0x0
- kfffdb.node.frlist.number: 268 ; 0x004: 0x0000010c
- kfffdb.node.frlist.incarn: 0 ; 0x008: A=0 NUMM=0x0
- kfffdb.hibytes: 0 ; 0x00c: 0x00000000
- kfffdb.lobytes: 0 ; 0x010: 0x00000000
- kfffdb.xtntcnt: 0 ; 0x014: 0x00000000
- kfffdb.xtnteof: 0 ; 0x018: 0x00000000
- kfffdb.blkSize: 0 ; 0x01c: 0x00000000
- kfffdb.flags: 0 ; 0x020: O=0 S=0 S=0 D=0 C=0 I=0 R=0 A=0
- kfffdb.fileType: 0 ; 0x021: 0x00
- kfffdb.dXrs: 0 ; 0x022: SCHE=0x0 NUMB=0x0
- kfffdb.iXrs: 0 ; 0x023: SCHE=0x0 NUMB=0x0
- kfffdb.dXsiz[0]: 0 ; 0x024: 0x00000000
- kfffdb.dXsiz[1]: 0 ; 0x028: 0x00000000
- kfffdb.dXsiz[2]: 0 ; 0x02c: 0x00000000
- kfffdb.iXsiz[0]: 0 ; 0x030: 0x00000000
- kfffdb.iXsiz[1]: 0 ; 0x034: 0x00000000
- kfffdb.iXsiz[2]: 0 ; 0x038: 0x00000000
- kfffdb.xtntblk: 0 ; 0x03c: 0x0000
- kfffdb.break: 0 ; 0x03e: 0x0000
- kfffdb.priZn: 0 ; 0x040: KFDZN_COLD
- kfffdb.secZn: 0 ; 0x041: KFDZN_COLD
- kfffdb.ub2spare: 0 ; 0x042: 0x0000
- kfffdb.alias[0]: 0 ; 0x044: 0x00000000
- kfffdb.alias[1]: 0 ; 0x048: 0x00000000
- kfffdb.strpwdth: 0 ; 0x04c: 0x00
- kfffdb.strpsz: 0 ; 0x04d: 0x00
- kfffdb.usmsz: 0 ; 0x04e: 0x0000
- kfffdb.crets.hi: 0 ; 0x050: HOUR=0x0 DAYS=0x0 MNTH=0x0 YEAR=0x0
- kfffdb.crets.lo: 0 ; 0x054: USEC=0x0 MSEC=0x0 SECS=0x0 MINS=0x0
- 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.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: 0 ; 0x4a0: 0x00000000
- kfffde[0].xptr.disk: 0 ; 0x4a4: 0x0000
- kfffde[0].xptr.flags: 0 ; 0x4a6: L=0 E=0 D=0 S=0
- kfffde[0].xptr.chk: 0 ; 0x4a7: 0x00
- kfffde[1].xptr.au: 0 ; 0x4a8: 0x00000000
- kfffde[1].xptr.disk: 0 ; 0x4ac: 0x0000
- kfffde[1].xptr.flags: 0 ; 0x4ae: L=0 E=0 D=0 S=0
- kfffde[1].xptr.chk: 0 ; 0x4af: 0x00
- kfffde[2].xptr.au: 0 ; 0x4b0: 0x00000000
- kfffde[2].xptr.disk: 0 ; 0x4b4: 0x0000
- kfffde[2].xptr.flags: 0 ; 0x4b6: L=0 E=0 D=0 S=0
- kfffde[2].xptr.chk: 0 ; 0x4b7: 0x00
- kfffde[3].xptr.au: 0 ; 0x4b8: 0x00000000
- [grid@gtser2 ~]$
复制代码 如果正确的话,应该这里看到的只是有kffed[0]的数据信息有正确的配置。
|
爱老婆,爱FM,爱音乐;挨踢,爱折腾,爱Oracle
|
|