[root@rac1 桌面]# su - grid
上一次登录：二 6月 14 09:46:51 CST 2016pts/0 上
[grid@rac1 ~]$ asmcmd
ASMCMD> du 显示指定的ASM目录下ASM文件占用的所有磁盘空间
Used_MB Mirror_used_MB
2434 2434
ASMCMD> ls -ls 列出ASM目录下的内容及其属性、磁盘空间占用
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 5119 3074 0 3074 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 5119 4494 0 4494 0 N FRA/
ASMCMD> pwd 查看当前路径
+
ASMCMD> cd ../DATA 切换目录
ASMCMD> lsct 列出当前ASM客户端的信息
DB_Name Status Software_Version Compatible_version Instance_Name Disk_Group
+ASM CONNECTED 11.2.0.1.0 11.2.0.1.0 +ASM1 FRA
+ASM CONNECTED 11.2.0.1.0 11.2.0.1.0 +ASM1 DATA
prod CONNECTED 11.2.0.1.0 11.2.0.0.0 prod1 DATA
prod CONNECTED 11.2.0.1.0 11.2.0.0.0 prod1 FRA
ASMCMD> lsdg 列出所有磁盘组及其属性
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 5119 3074 0 3074 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 5119 4494 0 4494 0 N FRA/
ASMCMD> lsof 列出数据文件信息
DB_Name Instance_Name Path
+ASM +ASM1 +fra.255.4294967295
prod prod1 +data/prod/controlfile/current.260.914409633
prod prod1 +data/prod/datafile/example.264.914409727
prod prod1 +data/prod/datafile/sysaux.257.914409307
prod prod1 +data/prod/datafile/system.256.914409305
prod prod1 +data/prod/datafile/undotbs1.258.914409309
prod prod1 +data/prod/datafile/undotbs2.265.914410765
prod prod1 +data/prod/datafile/users.259.914409309
prod prod1 +data/prod/onlinelog/group_1.261.914409645
prod prod1 +data/prod/onlinelog/group_2.262.914409659
prod prod1 +data/prod/onlinelog/group_3.266.914410907
prod prod1 +data/prod/onlinelog/group_4.267.914410911
prod prod1 +data/prod/tempfile/temp.263.914409695
prod prod1 +fra/prod/controlfile/current.256.914409635
prod prod1 +fra/prod/onlinelog/group_1.257.914409655
prod prod1 +fra/prod/onlinelog/group_2.258.914409659
prod prod1 +fra/prod/onlinelog/group_3.259.914410909
prod prod1 +fra/prod/onlinelog/group_4.260.914410913
ASMCMD> lsdsk 列出盘的信息
Path
ORCL:DATA
ORCL:FRA
ASMCMD>
ASMCMD> rm -f *.dbf //删除当前所有扩展名为 .dbf 文件
ASMCMD> rm -fr orcldemo //删除当前 orcldemo 目录
ASMCMD> cd + //切换到ASM磁盘根路径
ASMCMD> pwd
+
ASMCMD> exit
[grid@rac1 ~]$ asmcmd ls -ls
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 5119 3074 0 3074 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 5119 4494 0 4494 0 N FRA/
[grid@rac1 ~]$ exit
登出
[root@rac1 桌面]# export DISPLAY=:0.0
[root@rac1 桌面]# xhost +
access control disabled, clients can connect from any host
[root@rac1 桌面]# su - grid
上一次登录：二 6月 14 13:36:44 CST 2016pts/2 上
[grid@rac1 ~]$ export DISPLAY=:0.0
[grid@rac1 ~]$ xhost +
access control disabled, clients can connect from any host
[grid@rac1 ~]$ export LC_ALL=en_US.UTF-8
[grid@rac1 ~]$ asmca
若要使用图形界面，可以使用ASM助手命令：asmca 如上图所示
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 14 14:10:36 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
--查看磁盘组信息
SQL> select name,state,type,total_mb ,free_mb from v$asm_diskgroup;
NAME
------------------------------------------------------------
STATE TYPE TOTAL_MB FREE_MB
---------------------- ------------ ---------- ----------
FRA
MOUNTED EXTERN 5119 4494
DATA
MOUNTED EXTERN 5119 3074
OCR_VOTE
DISMOUNTED 0 0
-查看磁盘信息
SQL> select group_number,path,state,total_mb,free_mb from v$asm_disk;
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
STATE TOTAL_MB FREE_MB
---------------- ---------- ----------
0
ORCL:OCR_VOTE
NORMAL 0 0
2
ORCL:DATA
NORMAL 5119 3074
GROUP_NUMBER
------------
PATH
--------------------------------------------------------------------------------
STATE TOTAL_MB FREE_MB
---------------- ---------- ----------
1
ORCL:FRA
NORMAL 5119 4494
SQL> exir
注意：本文归作者所有，未经作者允许，不得转载
