oracle asm 磁盘组信息查询相关sql

查询磁盘空间情况：

COL NAME FORMAT a20; col path format a50; select name,path,STATE,free_mb,total_mb from v$asm_disk; NAME PATH STATE FREE_MB TOTAL_MB -------------------- -------------------------------------------------- -------- ---------- ---------- /dev/rhdisk22 NORMAL 0 0 /dev/rhdisk23 NORMAL 0 0 /dev/rhdisk24 NORMAL 0 0 /dev/rhdisk19 NORMAL 0 0 /dev/rhdisk20 NORMAL 0 0 /dev/rhdisk21 NORMAL 0 0 /dev/rhdisk26 NORMAL 0 0 /dev/rhdisk25 NORMAL 0 0 OCRVOTE_0002 /dev/rhdisk10 NORMAL 4870 5120 OCRVOTE_0003 /dev/rhdisk11 NORMAL 4870 5120 OCRVOTE_0004 /dev/rhdisk12 NORMAL 4868 5120 ARCH_0000 /dev/rhdisk13 NORMAL 392072 614400 REDO01_0000 /dev/rhdisk2 NORMAL 102305 102400 REDO02_0000 /dev/rhdisk3 NORMAL 102305 102400 DATA_0000 /dev/rhdisk4 NORMAL 466740 614400 DATA_0001 /dev/rhdisk5 NORMAL 466741 614400 DATA_0002 /dev/rhdisk6 NORMAL 466741 614400 DATA_0003 /dev/rhdisk7 NORMAL 466741 614400 OCRVOTE_0000 /dev/rhdisk8 NORMAL 4868 5120 OCRVOTE_0001 /dev/rhdisk9 NORMAL 4868 5120 DATA_0008 /dev/rhdisk15 DROPPING 502091 614400 DATA_0009 /dev/rhdisk16 DROPPING 502089 614400 DATA_0010 /dev/rhdisk17 DROPPING 502090 614400 DATA_0011 /dev/rhdisk18 DROPPING 502088 614400

查看磁盘组相关信息：

set linesize 1000; set pagesize 5000; col name format a15; col path format a30; col failgroup format a20; select dg.name,d.STATE,d.path, d.failgroup, d.failgroup_type from v$asm_diskgroup dg, v$asm_disk d where dg.group_number = d.group_number order by dg.name, d.path, d.failgroup; NAME STATE PATH FAILGROUP FAILGRO --------------- -------- ------------------------------ -------------------- ------- ARCH NORMAL /dev/rhdisk13 ARCH_0000 REGULAR DATA DROPPING /dev/rhdisk15 DATA_0008 REGULAR DATA DROPPING /dev/rhdisk16 DATA_0009 REGULAR DATA DROPPING /dev/rhdisk17 DATA_0010 REGULAR DATA DROPPING /dev/rhdisk18 DATA_0011 REGULAR DATA NORMAL /dev/rhdisk4 DATA_0000 REGULAR DATA NORMAL /dev/rhdisk5 DATA_0001 REGULAR DATA NORMAL /dev/rhdisk6 DATA_0002 REGULAR DATA NORMAL /dev/rhdisk7 DATA_0003 REGULAR OCRVOTE NORMAL /dev/rhdisk10 OCRVOTE_0002 REGULAR OCRVOTE NORMAL /dev/rhdisk11 OCRVOTE_0003 REGULAR OCRVOTE NORMAL /dev/rhdisk12 OCRVOTE_0004 REGULAR OCRVOTE NORMAL /dev/rhdisk8 OCRVOTE_0000 REGULAR OCRVOTE NORMAL /dev/rhdisk9 OCRVOTE_0001 REGULAR REDO01 NORMAL /dev/rhdisk2 REDO01_0000 REGULAR REDO02 NORMAL /dev/rhdisk3 REDO02_0000 REGULAR

Oracle SQL

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。