Skip to Main Content

Oracle Database Discussions

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!

Oracle ASM failgroup confused....

646155Sep 18 2010 — edited Sep 19 2010
hello,

iam pretty much confused with the fail groups here. see i have three 4 disks configured for asM
/dev/sdc1
/dev/sdd1
/dev/sde1
/dev/sdf1

i create a asm diskgroup using two disks with normal redundancy as follows:

create diskgroup asdf nomal redundancy
failgroup fail1 DISK
'/dev/sdc1' name disk01
failgroup fail2 DISK
'/dev/sdd1' name disk02
attribute 'au_size'='4M','compatible.asm'='11.1','compatible.rdbms'='11.1';


sorry for not including this statement before...
alter diskgroup asdf add disk '/dev/sdd1';

after creating the diskgroup the views the shows the information as
select name,group_number,total_mb from V$ASM_DISKGROUP;

NAME GROUP_NUMBER TOTAL_MB
------------------------------ ------------ ----------
ASDF 1 12276

select group_number,disk_number from v$asm_disk;

GROUP_NUMBER DISK_NUMBER
------------ -----------
0 3
0 4
1 0
1 1
1 2

can any one please explain what is going on here... what is the group with group number 0

and as far as the oracle documentation is considered if we dont specify the failgroup during the datagroup creation time then each disk we specify in the CREATE DISKGROUP STATEMENT will be assigned one fail group.. if it is this case then how are the data being distributed and is the existing data in the diskgroup evenly distributed amoung all the disks in the diskgroup...

help please....

Edited by: vishnusivathej on Sep 18, 2010 7:35 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2010
Added on Sep 18 2010
9 comments
2,253 views