Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ASM question
Hi Folks,
I have a 10.2.0.2 ASM instance running on Solaris 9 with the following
scenario:
When I run the sql statement, as shown below, I see the following
output:
SQL> select GROUP_NUMBER GROUP#, NAME, STATE, TOTAL_MB, FREE_MB,
REQUIRED_MIRROR_FREE_MB REQ_MIRR_FREE_MB, USABLE_FILE_MB
from V$ASM_DISKGROUP;
GROUP# NAME STATE TOTAL_MB FREE_MB
REQ_MIRR_FREE_MB USABLE_FILE_MB
---------- -------------- --------------- ---------- ----------
---------------- -------------- 1 DATA MOUNTED 10240 10138 0 5069
So, the total size of the DG is 10GB with Usable space of 5GB. Because the group is mirrored 1:1, the REQ_MIRR_FREE_MB is zero.
3. When I create the same group with two disks in each failover group, I
see an output that I am not able to comprehend:
SQL> create diskgroup data
failgroup failgroup_1
disk
'/dev/vx/rdsk/ux016_RAW/volraw_01',
'/dev/vx/rdsk/ux016_RAW/volraw_02'
failgroup failgroup_2
disk
'/dev/vx/rdsk/ux016_RAW/volraw_03',
'/dev/vx/rdsk/ux016_RAW/volraw_04'
/
SQL> select GROUP_NUMBER GROUP#, NAME, STATE, TOTAL_MB, FREE_MB, REQUIRED_MIRROR_FREE_MB REQ_MIRR_FREE_MB, USABLE_FILE_MB from V$ASM_DISKGROUP;
GROUP# NAME STATE TOTAL_MB FREE_MB
REQ_MIRR_FREE_MB USABLE_FILE_MB
---------- -------------- --------------- ---------- ----------
---------------- -------------- 1 DATA MOUNTED 20480 20374 5120 7627
I was hoping to see REQ_MIRR_FREE_MB of zero because I have a DG that contains two failure groups with each group contains two disks. I was also expecting to see 10GB for the USABLE_FILE_MB.
Can someone please clarify how two interpret these stats.
Thanks
Amir
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 23 2007 - 12:13:42 CST
![]() |
![]() |