Management of Oracle ASM (III)

Source: Internet
Author: User

Oracle provides a tool for manual query of ASM disk information-kfod. First, let's look at the help information:


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)]


According to the help information above, it is hard to see the disk parameter-disk (kfod is also very simple to use)

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


Note: This section details all the current ASM disk groups and the size of the disk groups.

Someone will ask, I know the total size of the ASM disk. How can I view the free space of the current ASM disk? This is also very easy.


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

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.