ODA X7-2HA - Disks and how those are used in ASM
Hi
This is related to our production X7-2HA-ODA
select group_number,name,type,total_mb,FREE_MB,HOT_USED_MB,COLD_USED_MB,REQUIRED_MIRROR_FREE_MB,usable_file_mb from v$asm_diskgroup
GROUP# NAME TYPE TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB REQUIRED FREE_MB
MIRROR
FREE_MB
================================================================================================================
1 DATA NORMAL 10684160 10506364 0 177796 2136832 4184766
2 RECO NORMAL 4577280 4305260 0 272020 915456 1694902
3 REDO HIGH 3051520 3001684 0 49836 762880 746268
select group_number,disk_number,os_mb,total_mb,free_mb,hot_used_mb,cold_used_mb,name,failgroup
from v$asm_disk order by group_number,disk_number
Group# Disk# OS_MB TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB NAME FAILURE_GROUP