In V$ASM_DISKGROUP have a column named required_mirror_free_mb.
My question is :
1. what's required mirror ?
2. why asm reserve mirror space ?
3. how Oracle Automatic Storage Management (ASM) calculates the REQUIRED_MIRROR_FREE_MB ?
REQUIRED_MIRROR_FREE_MB indicates the amount of space that must be available in a disk group to restore full redundancy after the worst failure that can be tolerated by the disk group. The amount of space displayed in this column takes the effects of mirroring into account. The value is computed as follows:
For a normal redundancy disk group, the value is the total raw space for all of the disks in the largest failure group. The largest failure group is the one with the largest total raw capacity. For example, if each disk is in its own failure group, then the value would be the size of the largest capacity disk.
For a high redundancy disk group, the value is the total raw space for all of the disks in the two largest failure groups.
Let say i have a storage of 100G and i have insert data of 20G
My ASM diskgroup is external redundancy
then below are my values
For the same if my ASM diskgroup is normal redundancy then below are my values
Let me know if you have any concerns.