Oracle提供了一个手工查询ASM磁盘信息的工具----kfod,首先我们来看下帮助信息:
db1-> kfod -help
_asm_a/llow_only_raw_disks KFOD allow only raw devices [_asm_allow_only_raw_disks=TRUE/(FALSE)]
_asm_l/ibraries ASM Libraries[_asm_libraries=lib1,lib2,...]
_asms/id ASM Instance[_asmsid=sid]
a/sm_diskstring ASM Diskstring [asm_diskstring=discoverystring, discoverystring ...]
d/isks Disks to discover [disks=raw,asm,all]
g/roup Group discover [group=controlfile]
n/ohdr KFOD header suppression [nohdr=TRUE/(FALSE)]
o/p KFOD options type [OP=DISKS/GROUPS/ALL]
p/file ASM parameter file [pfile=parameterfile]
s/tatus Include disk header status [status=TRUE/(FALSE)]
v/erbose KFOD verbose errors [verbose=TRUE/(FALSE)]
根据上面的帮助信息不难看出来,查看磁盘所用到的参数--disk(kfod使用方法也非常的简单)
db1-> kfod disk=all
--------------------------------------------------------------------------------
Disk Size Path
================================================================================
1: 379567 Mb /dev/raw/raw1
2: 379567 Mb /dev/raw/raw2
3: 379818 Mb /dev/raw/raw3
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
+ASM1 /opt/oracle/product/10.2.0/db_1
+ASM2 /opt/oracle/product/10.2.0/db_1
注:详细列出了目前所有的ASM磁盘组以及磁盘组的大小.
有人就会问,我知道ASM磁盘的总共大小我怎么查看目前ASM磁盘的空闲空间呢 这个也很容易.
db1-> sqlplus / as sysdba
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DG1 759134 381088
RECOVERYDEST 379818 289055