查询磁盘空间情况:
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
本文系外文翻译,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。
本文系外文翻译,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。