Adding diskgroup to DB 

Ø  Step 1 : Connect to the server and to set the asm env and then -->>> sqlplus '/as sysasm'

Ø  step 2 : Run the below query to check what are the diskgroups and what are the details for it.

set pages 234 lines 234

SELECT

    name                                     group_name

  , sector_size                              sector_size

  , block_size                               block_size

  , allocation_unit_size                     allocation_unit_size

  , state                                    state

  , type                                     type

  , total_mb                                 total_mb

  , (total_mb - free_mb)                     used_mb

  , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used

FROM

    v$asm_diskgroup

ORDER BY

    name

/

Example :--

GROUP_NAME                     SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE       TYPE     TOTAL_MB    USED_MB   PCT_USED

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

CRS                                    512       4096              4194304 MOUNTED     EXTERN      16408        432       2.63

DB2CP_DATA                             512       4096              1048576 MOUNTED     EXTERN      32822      21675      66.04

DB2CP_RECO                             512       4096              1048576 MOUNTED     EXTERN      16411        370       2.25

DB_DATA01                            512       4096              4194304 MOUNTED     EXTERN    1083104    1036820      95.73

DB_RECO                              512       4096              4194304 MOUNTED     EXTERN     196932       9016       4.58

Ø  Step 3 : Shows present diskmembers in diskgroups

set pagesize 10000

set lin 400

col header_status format a30

col path format a30

col name format a30

select d.path,

g.name,

d.header_status,

d.total_mb

from

v$asm_diskgroup g,

v$asm_disk d

where

d.group_number=g.group_number

order by g.name,d.path,d.header_status;

Example :--

PATH                           NAME                           HEADER_STATUS                    TOTAL_MB

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

/dev/mapper/ASM_DB_VOTE01    CRS                            MEMBER                              16408

/dev/mapper/ASM_DB2CP_DATA00   DB2CP_DATA                     MEMBER                              16411

/dev/mapper/ASM_DB2CP_DATA01   DB2CP_DATA                     MEMBER                              16411

/dev/mapper/ASM_DB2CP_RECO00   DB2CP_RECO                     MEMBER                              16411

/dev/mapper/ASM_DB_DATA01    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA02    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA03    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA04    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA05    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA06    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA07    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA08    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA09    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA10    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_DATA11    DB_DATA01                    MEMBER                              98464

/dev/mapper/ASM_DB_RECO01    DB_RECO                      MEMBER                             196932

16 rows selected.

SQL>

Ø  Step 4 : Shows available disk memebers status   -à It is always recommended to add the exiting diskgroup with same name in ASM .

col header_status format a30

col path format a30

col name format a30

select

path,

header_status,

os_mb,

total_mb,

free_mb

from

v$asm_disk

order by path,header_status;

PATH                                   HEADER_STATUS                       OS_MB   TOTAL_MB    FREE_MB

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

/dev/mapper/ASM_DB2CP_DATA00           MEMBER                              16411      16411       5573

/dev/mapper/ASM_DB2CP_DATA01           MEMBER                              16411      16411       5574

/dev/mapper/ASM_DB2CP_RECO00           MEMBER                              16411      16411      16041

/dev/mapper/ASM_OIDPRDHA_DATA01        CANDIDATE                           16411          0          0

/dev/mapper/ASM_OIDPRDHA_DATA02        CANDIDATE                           16411          0          0

/dev/mapper/ASM_OIDPRDHA_RECO00        CANDIDATE                           16411          0          0

/dev/mapper/ASM_DB_DATA01            MEMBER                              98466      98464       4208

/dev/mapper/ASM_DB_DATA02            MEMBER                              98466      98464       4212

/dev/mapper/ASM_DB_DATA03            MEMBER                              98466      98464       4208

/dev/mapper/ASM_DB_DATA04            MEMBER                              98466      98464       4212

/dev/mapper/ASM_DB_DATA05            MEMBER                              98466      98464       4204

/dev/mapper/ASM_DB_DATA06            MEMBER                              98466      98464       4216

/dev/mapper/ASM_DB_DATA07            MEMBER                              98466      98464       4204

/dev/mapper/ASM_DB_DATA08            MEMBER                              98466      98464       4204

/dev/mapper/ASM_DB_DATA09            MEMBER                              98466      98464       4192

/dev/mapper/ASM_DB_DATA10            MEMBER                              98466      98464       4200

/dev/mapper/ASM_DB_DATA11            MEMBER                              98466      98464       4224

/dev/mapper/ASM_DB_DATA12            CANDIDATE                           98466          0          0

/dev/mapper/ASM_DB_DATA13            CANDIDATE                           98466          0          0

/dev/mapper/ASM_DB_DATA14            CANDIDATE                           98466          0          0

/dev/mapper/ASM_DB_RECO01            MEMBER                             196932     196932     187916

/dev/mapper/ASM_DB_VOTE01            MEMBER                              16411      16408      15976

/dev/mapper/ASM_DB_VOTE02            CANDIDATE                           16411          0          0

/dev/mapper/ASM_DB_VOTE03            CANDIDATE                           16411          0          0

24 rows selected.

SQL>

Ø Step 5 : Steps to add the disks to disk group

1.SQL> create DISKGROUP DUMMY EXTERNAL REDUNDANCY DISK  '/dev/mapper/ASM_DB_DATA12','/dev/mapper/ASM_DB_DATA13','/dev/mapper/ASM_DB_DATA14';

Diskgroup created.

2.SQL> alter diskgroup DUMMY rebalance power 11;   ----- > Rebalancing is mandatory to do so that if there is any issues it hampers the DUMMY disk group ,so get this done at DUMMY diskgroup level

Diskgroup altered.

3. SQL> select * from gv$asm_operation;   -à Check this till it becomes 0

4 .SQL> drop diskgroup DUMMY;    ------ >>>> Always once the output for Step 3 is 0, then drop the DUMMY diskgroup and check by running the query for Step 3 mentioned above to check that the mentioned diskgroups are MEMBER now in HEADER_STATUS                       

5.SQL> alter diskgroup DB_DATA01 add disk  '/dev/mapper/ASM_DB_DATA12','/dev/mapper/ASM_DB_DATA13','/dev/mapper/ASM_DB_DATA14';

Diskgroup altered.

6.SQL> select * from gv$asm_operation;