ASM DISK “_DROPPED_0001_DATA2” STATE FORCING

Issue: 

After cluster restart , one of the disk corresponding to a normal redundancy diskgroup state shown as FORCING

SQL> select group_number,name,state,HEADER_STATUS,path,label from v$asm_disk;

GROUP_NUMBER NAME STATE HEADER_STATU PATH LABEL
———— —————————— ——– ———— ———–
0 NORMAL MEMBER ORCL:ASMDISK4 ASMDISK4
0 NORMAL FORMER ORCL:ASMDISK5 ASMDISK5
0 NORMAL FORMER ORCL:ASMDISK6 ASMDISK6
0 NORMAL FORMER ORCL:ASMDISK7 ASMDISK7
0 NORMAL PROVISIONED ORCL:ASMDISK8 ASMDISK8
1 _DROPPED_0001_DATA2 FORCING UNKNOWN
2 ASMDISK1 NORMAL MEMBER ORCL:ASMDISK1 ASMDISK1
2 ASMDISK2 NORMAL MEMBER ORCL:ASMDISK2 ASMDISK2
1 ASMDISK3 NORMAL MEMBER ORCL:ASMDISK3 ASMDISK3

9 rows selected.

Solution: 

2) Create diskgroup with DISK with the missing member , in this case ASMDISK4(Status of disk is showing as member but diskgroup number as Zero) . Use Force option

SQL> create diskgroup DATA3 external redundancy DISK ‘ORCL:ASMDISK4’ force;

Diskgroup created.

3) Drop Diskgroup.

SQL> drop diskgroup DATA3;

Diskgroup dropped.

4) Add disk to the diskgroup.

SQL> alter diskgroup DATA2 add failgroup DISK2 DISK ‘ORCL:ASMDISK4’ ;

Diskgroup altered.

5) check the status after sometime..

SQL> select group_number,name,state,HEADER_STATUS,path,label from v$asm_disk;

GROUP_NUMBER NAME STATE HEADER_STATU PATH LABEL
———— —————————— ——– ———— ———–
0 NORMAL FORMER ORCL:ASMDISK5 ASMDISK5
0 NORMAL FORMER ORCL:ASMDISK6 ASMDISK6
0 NORMAL FORMER ORCL:ASMDISK7 ASMDISK7
0 NORMAL PROVISIONED ORCL:ASMDISK8 ASMDISK8
2 ASMDISK1 NORMAL MEMBER ORCL:ASMDISK1 ASMDISK1
2 ASMDISK2 NORMAL MEMBER ORCL:ASMDISK2 ASMDISK2
1 ASMDISK3 NORMAL MEMBER ORCL:ASMDISK3 ASMDISK3
1 ASMDISK4 NORMAL MEMBER ORCL:ASMDISK4 ASMDISK4

8 rows selected.

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s