ASM磁盘组信息查看常用命令

1.1 获取磁盘组管理信息
1.1.1 查看磁盘路径
SQL> selectname, path, group_number from v$asm_disk_stat ；
1.1.2 查看磁盘组信息
SQL> selectstate,name,type,total_mb, free_mb from v$asm_diskgroup_stat ;
磁盘组状态为Mounted说明磁盘组状态正常;磁盘组的total_mb,free_mb为非0说明可以读取磁盘信息,获取磁盘大小。1.1.3 查看磁盘组操作
select * fromv$asm_operationOPERA STATPOWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES----- -------------- ---------- ---------- ---------- ---------- -----------1 REBAL WAIT11 0 0 0 0 01 DSCV WAIT 110 0 0 0 0（timepasses…………..）OPERA STATPOWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES----------------- ---- ---------- ---------- ---------- ---------- ----------1 REBAL REAP11 2 25 219 485 01.1.4 查看磁盘组属性
查询V$ASM_ATTRIBUTE视图查看磁盘组属性SQL> SELECT dg.name AS diskgroup,SUBSTR（a.name,1,18） AS name,SUBSTR（a.value,1,24） AS value, read_only FROM V$ASM_DISKGROUP_STAT dg,V$ASM_ATTRIBUTE a WHERE dg.name = "DATA"AND dg.group_number = a.group_number;
1.1.5 查看磁盘组兼容属性
SQL> SELECT name,COMPATIBILITY,DATABASE_COMPATIBILITY FROM V$ASM_DISKGROUP_STAT;
1.1.6 查看磁盘状态
SQL> SELECT SUBSTR（d.name,1,16） AS asmdisk,d.mount_status,HEADER_STATUS, d.state,dg.name AS diskgroup FROM V$ASM_DISKGROUP_STAT dg, V$ASM_DISK_STAT dWHERE dg.group_number = d.group_number;
1.1.7 查看磁盘客户端信息
SQL> SELECT dg.name AS diskgroup,SUBSTR（c.instance_name,1,12） AS instance,SUBSTR（c.db_name,1,12） AS dbname,SUBSTR（c.SOFTWARE_VERSION,1,12） AS software,SUBSTR（c.COMPATIBLE_VERSION,1,12） AS compatibleFROM V$ASM_DISKGROUP_STAT dg, V$ASM_CLIENT cWHERE dg.group_number = c.group_number;
1.1.8 查看磁盘访问控制用户信息
SQL> SELECT dg.name AS diskgroup, u.group_number,u.user_number, u.os_id, u.os_nameFROM V$ASM_DISKGROUP_STAT dg, V$ASM_USER uWHERE dg.group_number = u.group_number AND dg.name ="DATA";
1.1.9 查看磁盘访问控制组信息
SQL> SELECT dg.name AS diskgroup, ug.group_number,ug.owner_number, u.os_name,ug.usergroup_number, ug.name FROM V$ASM_DISKGROUP_STAT dg, V$ASM_USER u, V$ASM_USERGROUP ugWHERE dg.group_number = ug.group_number AND dg.name ="DATA"AND ug.owner_number = u.user_number;
1.1.10 查看智能数据分布信息
SQL> SELECT dg.name AS diskgroup, f.file_number, f.primary_region,f.mirror_region, f.hot_reads,f.hot_writes, f.cold_reads, f.cold_writesFROM V$ASM_DISKGROUP_STAT dg, V$ASM_FILE fWHERE dg.group_number = f.group_number and dg.name ="DATA";如何修改ASM的sys密码 http://www.linuxidc.com/Linux/2013-09/89744.htm如何将ASM中的数据文件复制到操作系统中 http://www.linuxidc.com/Linux/2013-08/88418.htmOracle 11g RAC ASM磁盘全部丢失后的恢复 http://www.linuxidc.com/Linux/2013-07/87000.htmOracle 11g从入门到精通 PDF+光盘源代码 http://www.linuxidc.com/Linux/2013-06/85670.htmRHEL6 ASM方式安装Oracle 11g R2 http://www.linuxidc.com/Linux/2013-06/86002.htmOracle 10g 手工创建ASM数据库 http://www.linuxidc.com/Linux/2013-01/78229.htmUbuntu 12.04（amd64）安装完Oracle 11gR2后各种问题解决方法 http://www.linuxidc.com/Linux/2013-06/86155.htm如何修改Oracle 10g ASM的sys密码 http://www.linuxidc.com/Linux/2012-11/75163.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址