We check whether the ASM disk space passes through the following routine:
Export Oracle_SID = + ASM1
By checking the v $ asm_diskgoup view, you can check the usage of the disk space as follows:
SQL> select group_number, name, total_mb, free_mb from v $ asm_diskgroup;
GROUP_NUMBER NAME TOTAL_MB FREE_MB
--------------------------------------------------------------
1 DATA 8032 2626
Today we found that through asmcmd, we can also achieve a lot of functions, a very bad one:
ASMCMD> ls
DATA/
As shown above, we can see the disk groups in the ASM instance, such as the connection usage between the database of the ASM instance disk group and the instance:
ASMCMD> lsct data
DB_Name Status Software_Version Compatible_version Instance_Name
Rac CONNECTED 10.2.0.4.0 10.2.0.1.0 rac1
After the-H parameter is added, the following information is displayed:
ASMCMD> lsct-H data
Rac CONNECTED 10.2.0.4.0 10.2.0.1.0 rac1
We can see that the-H parameter is removed from some of the above column information.
Lsdg can also be used to check the space usage of the disk groups in the ASM instance:
ASMCMD> lsdg data
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
Mounted extern n 512 4096 1048576 8032 0 2626 0 DATA/
There are also the following methods:
ASMCMD> du data
Used_MB pai_used_mb
5312 5312
ASMCMD> ls-s
Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
512 4096 1048576 8032 2626 0 2626 0 DATA/
There are also the following common commands:
ASMCMD>?
Commands:
--------
Cd
Du
Find
Help
Ls
Lsct
Lsdg
Mkalias
Mkdir
Pwd
Rm
Rmalias
Of course, I will not list them one by one. When ORACLE 11g is reached, there are obviously many Parameter options in asmcmd:
ASMCMD>?
Commands:
--------
Md_backup, md_restore
Lsattr, setattr
Cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
Mkdir, pwd, rm, rmalias
Chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
Offline, online, rebal, remap, umount
Dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
Spmove, spset, startup
Chtmpl, lstmpl, mktmpl, rmtmpl
Chgrp, chmod, chown, groups, kgmod, lsgrp, lspwusr, lsusr
Mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr
Volcreate, voldelete, voldisable, volenable, volinfo
Volresize, volset, volstat
The rest will not be listed one by one.
For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12