ASM查看信息
一 查看有关ASM的视图
SQL> select table_name from dict where table_name like '%ASM%';
ASM相关管理视图
v$ASM_ALIAS:每个disk group的列的别名
V$ASM_ATTRIBUTE:显示每一列属性定义
v$ASM_CLIENT:ASM实例
V$ASM_DISK:显示DISK属性
V$ASM_DISK_IOSTAT:显示DISK IO操作统计
V$ASM_DISK_STAT:与v$ASM_DISK显示一样,但是基于性能考虑不进行扫描硬盘操作
V$ASM_DISKGROUP:显示ASM DISKGROUP信息
V$ASM_FILE:显示基于ASM存储的文件信息
VASM_OPERATION:查看基于ASM大型运行操作信息
二 查看磁盘组信息
SQL> col name for a15
SQL> col state a8
SQL> col type for a10
SQL> select group_number,name,state,type from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TYPE
------------ --------------- -------- ----------
1 DATADG MOUNTED NORMAL
2 SYSTEDG CONNECTE NORMAL
三 查看磁盘组中的成员名称,路径,大小
SQL> select group_number,name,path,os_mb,free_mb from v$asm_disk order by 1 desc;
GROUP_NUMBER NAME PATH OS_MB FREE_MB
2 SYSTEDG_0001 /dev/asm-diskh 2048 207
2 SYSTEDG_0000 /dev/asm-diskg 2048 207
1 DATADG_0001 /dev/asm-diskc 210 175
1 DATADG_0000 /dev/asm-diskb 208 172
1 DATADG_0004 /dev/asm-diskf 200 164
1 DATADG_0002 /dev/asm-diskd 211 173
1 DATADG_0003 /dev/asm-diske 210 172
四 ASMCMD工具
[root@ogg1 ~]# su - grid
[grid@ogg1 ~]$ which asmcmd
/g01/11ggrid/app/11.2.0/grid/bin/asmcmd
[grid@ogg1 ~]$ asmcmd
ASMCMD> help
ASMCMD> ls
DATADG/
SYSTEDG/
ASMCMD> cd systedg
ASMCMD> ls
PROD1/
ASMCMD> cd prod1
ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
spfileprod1.ora
ASMCMD> cd datafile
ASMCMD> ls
EXAMPLE.265.885576627
SYSAUX.257.885576451
SYSTEM.256.885576449
UNDOTBS1.258.885576451
USERS.259.885576451
ASMCMD> lsdsk
Path
/dev/asm-diskb
/dev/asm-diskc
/dev/asm-diskd
/dev/asm-diske
/dev/asm-diskf
/dev/asm-diskg
/dev/asm-diskh
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 NORMAL N 512 4096 1048576 1039 856 211 322 0 N DATADG/
MOUNTED NORMAL N 512 4096 1048576 4096 374 0 187 0 N SYSTEDG/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29785807/viewspace-1744817/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29785807/viewspace-1744817/