磁盘头恢复学习
1、首先编译kfed
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk ikfed
2、kfed读取正确的磁盘头
$ ll /dev/oracleasm/disks/
total 0
brw-rw---- 1 oracle dba 8, 65 Jun 29 11:20 VOL1
brw-rw---- 1 oracle dba 8, 66 Jun 29 11:20 VOL2
brw-rw---- 1 oracle dba 8, 69 Jun 29 11:30 VOL3
brw-rw---- 1 oracle dba 8, 70 Jun 29 11:30 VOL4
brw-rw---- 1 oracle dba 8, 71 Jun 29 11:30 VOL5
$ kfed read /dev/oracleasm/disks/VOL1
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check: 613012642 ; 0x00c: 0x2489d4a2
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKVOL1 ; 0x000: length=12
kfdhdb.driver.reserved[0]: 827084630 ; 0x008: 0x314c4f56
kfdhdb.driver.reserved[1]: 0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 168820736 ; 0x020: 0x0a100000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: VOL1 ; 0x028: length=4
kfdhdb.grpname: DG1 ; 0x048: length=3
kfdhdb.fgname: VOL1 ; 0x068: length=4
kfdhdb.capname: ; 0x088: length=0
kfdhdb.crestmp.hi: 32922539 ; 0x0a8: HOUR=0xb DAYS=0x1d MNTH=0x6 YEAR=0x7d9
kfdhdb.crestmp.lo: 2155521024 ; 0x0ac: USEC=0x0 MSEC=0x2a9 SECS=0x7 MINS=0x20
kfdhdb.mntstmp.hi: 32922539 ; 0x0b0: HOUR=0xb DAYS=0x1d MNTH=0x6 YEAR=0x7d9
kfdhdb.mntstmp.lo: 2164349952 ; 0x0b4: USEC=0x0 MSEC=0x57 SECS=0x10 MINS=0x20
kfdhdb.secsize: 512 ; 0x0b8: 0x0200
kfdhdb.blksize: 4096 ; 0x0ba: 0x1000
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80
kfdhdb.dsksize: 95378 ; 0x0c4: 0x00017492
kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002
kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001
kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002
kfdhdb.f1b1locn: 2 ; 0x0d4: 0x00000002
kfdhdb.redomirrors[0]: 0 ; 0x0d8: 0x0000
kfdhdb.redomirrors[1]: 0 ; 0x0da: 0x0000
kfdhdb.redomirrors[2]: 0 ; 0x0dc: 0x0000
kfdhdb.redomirrors[3]: 0 ; 0x0de: 0x0000
kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000
kfdhdb.grpstmp.hi: 32922539 ; 0x0e4: HOUR=0xb DAYS=0x1d MNTH=0x6 YEAR=0x7d9
kfdhdb.grpstmp.lo: 2155424768 ; 0x0e8: USEC=0x0 MSEC=0x24b SECS=0x7 MINS=0x20
kfdhdb.ub4spare[0]: 0 ; 0x0ec: 0x00000000
kfdhdb.ub4spare[1]: 0 ; 0x0f0: 0x00000000
kfdhdb.ub4spare[2]: 0 ; 0x0f4: 0x00000000
kfdhdb.ub4spare[3]: 0 ; 0x0f8: 0x00000000
kfdhdb.ub4spare[4]: 0 ; 0x0fc: 0x00000000
kfdhdb.ub4spare[5]: 0 ; 0x100: 0x00000000
kfdhdb.ub4spare[6]: 0 ; 0x104: 0x00000000
kfdhdb.ub4spare[7]: 0 ; 0x108: 0x00000000
kfdhdb.ub4spare[8]: 0 ; 0x10c: 0x00000000
kfdhdb.ub4spare[9]: 0 ; 0x110: 0x00000000
kfdhdb.ub4spare[10]: 0 ; 0x114: 0x00000000
kfdhdb.ub4spare[11]: 0 ; 0x118: 0x00000000
kfdhdb.ub4spare[12]: 0 ; 0x11c: 0x00000000
kfdhdb.ub4spare[13]: 0 ; 0x120: 0x00000000
kfdhdb.ub4spare[14]: 0 ; 0x124: 0x00000000
kfdhdb.ub4spare[15]: 0 ; 0x128: 0x00000000
kfdhdb.ub4spare[16]: 0 ; 0x12c: 0x00000000
kfdhdb.ub4spare[17]: 0 ; 0x130: 0x00000000
kfdhdb.ub4spare[18]: 0 ; 0x134: 0x00000000
kfdhdb.ub4spare[19]: 0 ; 0x138: 0x00000000
kfdhdb.ub4spare[20]: 0 ; 0x13c: 0x00000000
kfdhdb.ub4spare[21]: 0 ; 0x140: 0x00000000
kfdhdb.ub4spare[22]: 0 ; 0x144: 0x00000000
kfdhdb.ub4spare[23]: 0 ; 0x148: 0x00000000
kfdhdb.ub4spare[24]: 0 ; 0x14c: 0x00000000
kfdhdb.ub4spare[25]: 0 ; 0x150: 0x00000000
kfdhdb.ub4spare[26]: 0 ; 0x154: 0x00000000
kfdhdb.ub4spare[27]: 0 ; 0x158: 0x00000000
kfdhdb.ub4spare[28]: 0 ; 0x15c: 0x00000000
kfdhdb.ub4spare[29]: 0 ; 0x160: 0x00000000
kfdhdb.ub4spare[30]: 0 ; 0x164: 0x00000000
kfdhdb.ub4spare[31]: 0 ; 0x168: 0x00000000
kfdhdb.ub4spare[32]: 0 ; 0x16c: 0x00000000
kfdhdb.ub4spare[33]: 0 ; 0x170: 0x00000000
kfdhdb.ub4spare[34]: 0 ; 0x174: 0x00000000
kfdhdb.ub4spare[35]: 0 ; 0x178: 0x00000000
kfdhdb.ub4spare[36]: 0 ; 0x17c: 0x00000000
kfdhdb.ub4spare[37]: 0 ; 0x180: 0x00000000
kfdhdb.ub4spare[38]: 0 ; 0x184: 0x00000000
kfdhdb.ub4spare[39]: 0 ; 0x188: 0x00000000
kfdhdb.ub4spare[40]: 0 ; 0x18c: 0x00000000
kfdhdb.ub4spare[41]: 0 ; 0x190: 0x00000000
kfdhdb.ub4spare[42]: 0 ; 0x194: 0x00000000
kfdhdb.ub4spare[43]: 0 ; 0x198: 0x00000000
kfdhdb.ub4spare[44]: 0 ; 0x19c: 0x00000000
kfdhdb.ub4spare[45]: 0 ; 0x1a0: 0x00000000
kfdhdb.ub4spare[46]: 0 ; 0x1a4: 0x00000000
kfdhdb.ub4spare[47]: 0 ; 0x1a8: 0x00000000
kfdhdb.ub4spare[48]: 0 ; 0x1ac: 0x00000000
kfdhdb.ub4spare[49]: 0 ; 0x1b0: 0x00000000
kfdhdb.ub4spare[50]: 0 ; 0x1b4: 0x00000000
kfdhdb.ub4spare[51]: 0 ; 0x1b8: 0x00000000
kfdhdb.ub4spare[52]: 0 ; 0x1bc: 0x00000000
kfdhdb.ub4spare[53]: 0 ; 0x1c0: 0x00000000
kfdhdb.ub4spare[54]: 0 ; 0x1c4: 0x00000000
kfdhdb.ub4spare[55]: 0 ; 0x1c8: 0x00000000
kfdhdb.ub4spare[56]: 0 ; 0x1cc: 0x00000000
kfdhdb.ub4spare[57]: 0 ; 0x1d0: 0x00000000
kfdhdb.acdb.aba.seq: 0 ; 0x1d4: 0x00000000
kfdhdb.acdb.aba.blk: 0 ; 0x1d8: 0x00000000
kfdhdb.acdb.ents: 0 ; 0x1dc: 0x0000
kfdhdb.acdb.ub2spare: 0 ; 0x1de: 0x0000
错误的磁盘头
$ kfed read /dev/oracleasm/disks/VOL2
kfbh.endian: 0 ; 0x000: 0x00
kfbh.hard: 0 ; 0x001: 0x00
kfbh.type: 0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt: 0 ; 0x003: 0x00
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 0 ; 0x008: TYPE=0x0 NUMB=0x0
kfbh.check: 843861846 ; 0x00c: 0x324c4f56
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
2、查看磁盘组的情况,此时磁盘VOL1和VOL2在同一个磁盘组,每个磁盘均有3G左右空间被使用
SQL> select group_number g#,disk_number d#,name,mount_status,header_status,total_mb,free_mb,path from v$asm_disk;
G# D# NAME MOUNT_STATUS HEADER_STATUS TOTAL_MB FREE_MB PATH
---------- ---------- ------------------------------ ------------ ------------- ---------- ---------- --------------------------------------------------------------------------------
0 3 CLOSED PROVISIONED 95378 0 ORCL:VOL4
0 4 CLOSED PROVISIONED 95425 0 ORCL:VOL5
1 0 VOL1 CACHED MEMBER 95378 92669 ORCL:VOL1
1 1 VOL2 CACHED MEMBER 95378 92674 ORCL:VOL2
2 1 VOL3 CACHED MEMBER 95378 95327 ORCL:VOL3
3、删除磁盘组1中的磁盘VOL1
SQL> alter diskgroup DG1 drop disk 'VOL1';
Diskgroup altered.
SQL>
查看报警日志中的信息,此时会启动一个ARB进程来将VOL1中的datafile移到VOL2中
SQL> alter diskgroup DG1 drop disk 'VOL1'
Wed Jul 1 16:26:33 2009
NOTE: PST update: grp = 1
NOTE: requesting all-instance membership refresh for group=1
Wed Jul 1 16:26:33 2009
NOTE: membership refresh pending for group 1/0xd439fd22 (DG1)
SUCCESS: refreshed membership for 1/0xd439fd22 (DG1)
Wed Jul 1 16:26:36 2009
NOTE: starting rebalance of group 1/0xd439fd22 (DG1) at power 1
Starting background process ARB0
ARB0 started with pid=19, OS id=21052
Wed Jul 1 16:26:36 2009
NOTE: assigning ARB0 to group 1/0xd439fd22 (DG1)
Wed Jul 1 16:26:36 2009
NOTE: F1X0 copy 1 relocating from 0:2 to 1:1636
Wed Jul 1 16:29:27 2009
NOTE: stopping process ARB0
Wed Jul 1 16:29:30 2009
SUCCESS: rebalance completed for group 1/0xd439fd22 (DG1)
Wed Jul 1 16:29:30 2009
SUCCESS: rebalance completed for group 1/0xd439fd22 (DG1)
NOTE: PST update: grp = 1
SUCCESS: grp 1 disk VOL1 emptied
WARNING: offlining disk 0.3975744978 (VOL1) with mask 0x1
NOTE: PST update: grp = 1, dsk = 0, mode = 0x6
Wed Jul 1 16:29:30 2009
NOTE: group DG1: relocated PST to: disk 0001 (PST copy 0)
NOTE: cache closing disk 0 of grp 1: VOL1
Wed Jul 1 16:29:30 2009
NOTE: PST update: grp = 1
NOTE: erasing header on grp 1 disk VOL1
NOTE: cache closing disk 0 of grp 1: VOL1
此时发现VOL2中的剩余空间变少
SQL> /
G# D# NAME MOUNT_STATUS HEADER_STATUS TOTAL_MB FREE_MB PATH
---------- ---------- ------------------------------ ------------ ------------- ---------- ---------- --------------------------------------------------------------------------------
0 0 CLOSED FORMER 95378 0 ORCL:VOL1
0 3 CLOSED PROVISIONED 95378 0 ORCL:VOL4
0 4 CLOSED PROVISIONED 95425 0 ORCL:VOL5
1 1 VOL2 CACHED MEMBER 95378 89967 ORCL:VOL2
2 1 VOL3 CACHED MEMBER 95378 95327 ORCL:VOL3
SQL>
3、再次查看VOL1的磁盘头
通过对比前后的header发现
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
由 MEMBER变为FORMER
kfdhdb.hdrsts: 4 ; 0x027: KFDHDR_FORMER
这个信息与v$asm_disk的HEADER_STATUS一致
$ kfed read /dev/oracleasm/disks/VOL1
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check: 2976323372 ; 0x00c: 0xb167172c
kfbh.fcn.base: 20258 ; 0x010: 0x00004f22
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKVOL1 ; 0x000: length=12
kfdhdb.driver.reserved[0]: 827084630 ; 0x008: 0x314c4f56
kfdhdb.driver.reserved[1]: 0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 168820736 ; 0x020: 0x0a100000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 4 ; 0x027: KFDHDR_FORMER
kfdhdb.dskname: VOL1 ; 0x028: length=4
kfdhdb.grpname: DG1 ; 0x048: length=3
kfdhdb.fgname: VOL1 ; 0x068: length=4
kfdhdb.capname: ; 0x088: length=0
kfdhdb.crestmp.hi: 32922539 ; 0x0a8: HOUR=0xb DAYS=0x1d MNTH=0x6 YEAR=0x7d9
kfdhdb.crestmp.lo: 2155521024 ; 0x0ac: USEC=0x0 MSEC=0x2a9 SECS=0x7 MINS=0x20
kfdhdb.mntstmp.hi: 32922551 ; 0x0b0: HOUR=0x17 DAYS=0x1d MNTH=0x6 YEAR=0x7d9
kfdhdb.mntstmp.lo: 712183808 ; 0x0b4: USEC=0x0 MSEC=0xc4 SECS=0x27 MINS=0xa
kfdhdb.secsize: 512 ; 0x0b8: 0x0200
kfdhdb.blksize: 4096 ; 0x0ba: 0x1000
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80
kfdhdb.dsksize: 95378 ; 0x0c4: 0x00017492
kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002
kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001
kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002
kfdhdb.f1b1locn: 0 ; 0x0d4: 0x00000000
kfdhdb.redomirrors[0]: 0 ; 0x0d8: 0x0000
kfdhdb.redomirrors[1]: 65535 ; 0x0da: 0xffff
kfdhdb.redomirrors[2]: 65535 ; 0x0dc: 0xffff
kfdhdb.redomirrors[3]: 65535 ; 0x0de: 0xffff
kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000
kfdhdb.grpstmp.hi: 32922539 ; 0x0e4: HOUR=0xb DAYS=0x1d MNTH=0x6 YEAR=0x7d9
kfdhdb.grpstmp.lo: 2155424768 ; 0x0e8: USEC=0x0 MSEC=0x24b SECS=0x7 MINS=0x20
kfdhdb.ub4spare[0]: 0 ; 0x0ec: 0x00000000
kfdhdb.ub4spare[1]: 0 ; 0x0f0: 0x00000000
kfdhdb.ub4spare[2]: 0 ; 0x0f4: 0x00000000
kfdhdb.ub4spare[3]: 0 ; 0x0f8: 0x00000000
kfdhdb.ub4spare[4]: 0 ; 0x0fc: 0x00000000
kfdhdb.ub4spare[5]: 0 ; 0x100: 0x00000000
kfdhdb.ub4spare[6]: 0 ; 0x104: 0x00000000
kfdhdb.ub4spare[7]: 0 ; 0x108: 0x00000000
kfdhdb.ub4spare[8]: 0 ; 0x10c: 0x00000000
kfdhdb.ub4spare[9]: 0 ; 0x110: 0x00000000
kfdhdb.ub4spare[10]: 0 ; 0x114: 0x00000000
kfdhdb.ub4spare[11]: 0 ; 0x118: 0x00000000
kfdhdb.ub4spare[12]: 0 ; 0x11c: 0x00000000
kfdhdb.ub4spare[13]: 0 ; 0x120: 0x00000000
kfdhdb.ub4spare[14]: 0 ; 0x124: 0x00000000
kfdhdb.ub4spare[15]: 0 ; 0x128: 0x00000000
kfdhdb.ub4spare[16]: 0 ; 0x12c: 0x00000000
kfdhdb.ub4spare[17]: 0 ; 0x130: 0x00000000
kfdhdb.ub4spare[18]: 0 ; 0x134: 0x00000000
kfdhdb.ub4spare[19]: 0 ; 0x138: 0x00000000
kfdhdb.ub4spare[20]: 0 ; 0x13c: 0x00000000
kfdhdb.ub4spare[21]: 0 ; 0x140: 0x00000000
kfdhdb.ub4spare[22]: 0 ; 0x144: 0x00000000
kfdhdb.ub4spare[23]: 0 ; 0x148: 0x00000000
kfdhdb.ub4spare[24]: 0 ; 0x14c: 0x00000000
kfdhdb.ub4spare[25]: 0 ; 0x150: 0x00000000
kfdhdb.ub4spare[26]: 0 ; 0x154: 0x00000000
kfdhdb.ub4spare[27]: 0 ; 0x158: 0x00000000
kfdhdb.ub4spare[28]: 0 ; 0x15c: 0x00000000
kfdhdb.ub4spare[29]: 0 ; 0x160: 0x00000000
kfdhdb.ub4spare[30]: 0 ; 0x164: 0x00000000
kfdhdb.ub4spare[31]: 0 ; 0x168: 0x00000000
kfdhdb.ub4spare[32]: 0 ; 0x16c: 0x00000000
kfdhdb.ub4spare[33]: 0 ; 0x170: 0x00000000
kfdhdb.ub4spare[34]: 0 ; 0x174: 0x00000000
kfdhdb.ub4spare[35]: 0 ; 0x178: 0x00000000
kfdhdb.ub4spare[36]: 0 ; 0x17c: 0x00000000
kfdhdb.ub4spare[37]: 0 ; 0x180: 0x00000000
kfdhdb.ub4spare[38]: 0 ; 0x184: 0x00000000
kfdhdb.ub4spare[39]: 0 ; 0x188: 0x00000000
kfdhdb.ub4spare[40]: 0 ; 0x18c: 0x00000000
kfdhdb.ub4spare[41]: 0 ; 0x190: 0x00000000
kfdhdb.ub4spare[42]: 0 ; 0x194: 0x00000000
kfdhdb.ub4spare[43]: 0 ; 0x198: 0x00000000
kfdhdb.ub4spare[44]: 0 ; 0x19c: 0x00000000
kfdhdb.ub4spare[45]: 0 ; 0x1a0: 0x00000000
kfdhdb.ub4spare[46]: 0 ; 0x1a4: 0x00000000
kfdhdb.ub4spare[47]: 0 ; 0x1a8: 0x00000000
kfdhdb.ub4spare[48]: 0 ; 0x1ac: 0x00000000
kfdhdb.ub4spare[49]: 0 ; 0x1b0: 0x00000000
kfdhdb.ub4spare[50]: 0 ; 0x1b4: 0x00000000
kfdhdb.ub4spare[51]: 0 ; 0x1b8: 0x00000000
kfdhdb.ub4spare[52]: 0 ; 0x1bc: 0x00000000
kfdhdb.ub4spare[53]: 0 ; 0x1c0: 0x00000000
kfdhdb.ub4spare[54]: 0 ; 0x1c4: 0x00000000
kfdhdb.ub4spare[55]: 0 ; 0x1c8: 0x00000000
kfdhdb.ub4spare[56]: 0 ; 0x1cc: 0x00000000
kfdhdb.ub4spare[57]: 0 ; 0x1d0: 0x00000000
kfdhdb.acdb.aba.seq: 0 ; 0x1d4: 0x00000000
kfdhdb.acdb.aba.blk: 0 ; 0x1d8: 0x00000000
kfdhdb.acdb.ents: 0 ; 0x1dc: 0x0000
kfdhdb.acdb.ub2spare: 0 ; 0x1de: 0x0000
4、通过kfed merge恢复磁盘头
kfed merge /dev/oracleasm/disks/VOL1 text=a.txt
结论:当通过 alter diskgroup DG1 drop disk 'VOL1'; drop disk后无法通过恢复磁盘头来使磁盘加入到卷组中,
其实这样做也没有意义,因为drop disk会自动将 VOL1的datafile等REBALANCE到另外的磁盘组,而VOL1便会清空
5、手动BALANCE磁盘组命令
ALTER DISKGROUP dg1 REBALANCE
参数asm_power_limit 决定磁盘auto rebalance速度快慢
SQL> show parameter asm_power_limit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_power_limit integer 1
asm_power_limit(1-11),值越小,则Asm 利用来rebalance(asm 配置改变时)的i/o带宽越小,当然越慢,对系统的性能影响越小。
磁盘组中添加磁盘
SQL> alter diskgroup DG1 add disk 'ORCL:VOL1';
Diskgroup altered.
常用SQL:
查看ASM disk信息
select group_number g#,disk_number d#,name,mount_status,header_status,total_mb,free_mb,path from v$asm_disk;
查看Disk group
select group_number gno,name,block_size,state,type,total_mb,free_mb,usable_file_mb,unbalanced from v$asm_diskgroup;
查看ASM正在执行的操作
select group_number,operation,state,est_work,sofar,est_rate,est_minutes from v$asm_operation;
参考:
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_20.shtml
http://hi.baidu.com/todayboy/blog/item/b8d7e92ffd0e3a3c1f3089d0.html