Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

failgroups in ASM

User_8E9DZFeb 12 2016 — edited Feb 16 2016

Hi all,

I have created an ASM setup with two diskgroups.

DATA - it has 4 disks (Disk number 0,1,2,3,4)

FRA - It has two disks( Disk Number 0,1)

While creating I didn't specify any failgroups. But when I query ASM now it is showing the failgroup type as NORMAL.

SQL> select disk_number,redundancy,total_mb,free_mb,failgroup_type from v$asm_disk;

DISK_NUMBER REDUNDA   TOTAL_MB    FREE_MB FAILGRO

----------- ------- ---------- ---------- -------

          0 UNKNOWN      30720      28962           REGULAR

          1 UNKNOWN      30720      28959           REGULAR

          2 UNKNOWN      30720      28970           REGULAR

          3 UNKNOWN      30720      28957           REGULAR

          0 UNKNOWN      14336      14308           REGULAR

          1 UNKNOWN      14336      14310           REGULAR

And also its showing the failgroup name as below.

SQL> select disk_number, group_number, failgroup from v$asm_disk;

DISK_NUMBER GROUP_NUMBER FAILGROUP

----------- ------------ ------------------------------

          0            1           DATA_0000

          1            1           DATA_0001

          2            1           DATA_0002

          3            1           DATA_0003

          0            2           FRA_0000

          1            2           FRA_0001

Can u please explain about the failgroups assigned and its size?

Should I recreate the disks with failgroups?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2016
Added on Feb 12 2016
12 comments
2,890 views