这个工具可以用于手工查询ASM磁盘的信息。其帮助信息如下:
[oracle@localhost ~]$ which kfod
/u01/oracle/product/10.2.0.1/db_1/bin/kfod
[oracle@localhost ~]$ kfod -h
_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)]
[oracle@localhost ~]$ kfod d=all
--------------------------------------------------------------------------------
Disk Size Path
================================================================================
1: 10236 Mb ORCL:VOL1
2: 4094 Mb ORCL:VOL2
3: 12284 Mb ORCL:VOL3
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
+ASM /u01/oracle/product/10.2.0.1/db_1
[oracle@localhost ~]$ which kfod
/u01/oracle/product/10.2.0.1/db_1/bin/kfod
[oracle@localhost ~]$ kfod -h
_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)]
[oracle@localhost ~]$ kfod d=all
--------------------------------------------------------------------------------
Disk Size Path
================================================================================
1: 10236 Mb ORCL:VOL1
2: 4094 Mb ORCL:VOL2
3: 12284 Mb ORCL:VOL3
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
+ASM /u01/oracle/product/10.2.0.1/db_1
select name,total_mb,free_mb, (total_mb-free_mb) used from v$asm_diskgroup;
SQL> select name,total_mb,free_mb, (total_mb-free_mb) used from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB USED
------------------------------ ---------- ---------- ----------
ORADATA 26614 24595 2019
SQL> select name,total_mb,free_mb, (total_mb-free_mb) used from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB USED
------------------------------ ---------- ---------- ----------
ORADATA 26614 24595 2019