Sunday, October 4, 2020

Add new disks to ASM DISKSPACE PROD

 ASMCMD>

ASMCMD> lsdsk -t -g FRA

ASMCMD> lsdsk -t -G FRA

Create_Date  Mount_Date  Repair_Timer  Path

10-JAN-19    26-FEB-20   0             /dev/dm-8

09-MAR-17    26-FEB-20   0             /dev/dm-9

ASMCMD> lsdsk -t -G FRA

Create_Date  Mount_Date  Repair_Timer  Path

10-JAN-19    26-FEB-20   0             /dev/dm-8

09-MAR-17    26-FEB-20   0             /dev/dm-9

ASMCMD> lsdsk -t -G DATA

Create_Date  Mount_Date  Repair_Timer  Path

02-MAR-19    26-FEB-20   0             /dev/dm-10

25-SEP-19    26-FEB-20   0             /dev/dm-12

09-MAR-17    26-FEB-20   0             /dev/dm-5

16-SEP-18    26-FEB-20   0             /dev/dm-6

09-MAR-17    26-FEB-20   0             /dev/dm-7

ASMCMD>


Add below lines in 20asm-devices.rules


KERNEL=="dm-*", PROGRAM="scsi_id --page=0x83 --whitelisted --device=/dev/%k",RESULT=="360002ac0000000000b007ba3000157e7",Name="FRA9", OWNER:="oraprod", GROUP:="oinstall"

KERNEL=="dm-*", PROGRAM="scsi_id --page=0x83 --whitelisted --device=/dev/%k",RESULT=="360002ac0000000000b007ba1000157e7",Name="DATA9", OWNER:="oraprod", GROUP:="oinstall"


Final contents of 20asm-devices.rules 

Make sure 20asm-devices.rules file backup is taken before modifying.


After modifying asm rules file complete below steps:
=======================================================


/sbin/udevadm control --reload-rules
/sbin/udevadm trigger --type=devices --action=change
ll /dev/dm-*

pract:
======
-bash-4.1#
-bash-4.1# /sbin/udevadm control --reload-rules
-bash-4.1# ll /dev/dm-*
brw-rw----. 1 root    disk     253,  0 Feb 26 17:24 /dev/dm-0
brw-rw----. 1 root    disk     253,  1 Feb 26 17:24 /dev/dm-1
brw-rw----. 1 oraprod oinstall 253, 10 Apr 19 15:09 /dev/dm-10
brw-rw----. 1 root    disk     253, 11 Feb 26 17:26 /dev/dm-11
brw-rw----. 1 oraprod oinstall 253, 12 Apr 19 15:09 /dev/dm-12
brw-rw----. 1 root    disk     253, 13 Feb 26 17:26 /dev/dm-13
brw-rw----. 1 root    disk     253, 14 Feb 26 17:26 /dev/dm-14
brw-rw----. 1 root    disk     253, 15 Feb 26 17:25 /dev/dm-15
brw-rw----. 1 root    disk     253, 16 Feb 26 17:24 /dev/dm-16
brw-rw----. 1 root    disk     253, 17 Feb 26 17:24 /dev/dm-17
brw-rw----. 1 root    disk     253, 18 Feb 26 17:24 /dev/dm-18
brw-rw----. 1 root    disk     253, 19 Feb 26 17:24 /dev/dm-19
brw-rw----. 1 oragrid oinstall 253,  2 Apr 19 15:09 /dev/dm-2
brw-rw----. 1 root    disk     253, 20 Feb 26 17:24 /dev/dm-20
brw-rw----. 1 root    disk     253, 21 Feb 26 17:24 /dev/dm-21
brw-rw----. 1 root    disk     253, 22 Feb 26 17:24 /dev/dm-22
brw-rw----. 1 root    disk     253, 23 Apr 19 13:46 /dev/dm-23
brw-rw----. 1 root    disk     253, 24 Apr 19 13:46 /dev/dm-24
brw-rw----. 1 oragrid oinstall 253,  3 Apr 19 14:01 /dev/dm-3
brw-rw----. 1 oragrid oinstall 253,  4 Apr 19 14:01 /dev/dm-4
brw-rw----. 1 oragrid oinstall 253,  5 Apr 19 15:09 /dev/dm-5
brw-rw----. 1 oragrid oinstall 253,  6 Apr 19 15:09 /dev/dm-6
brw-rw----. 1 oragrid oinstall 253,  7 Apr 19 15:09 /dev/dm-7
brw-rw----. 1 oraprod oinstall 253,  8 Apr 19 15:09 /dev/dm-8
brw-rw----. 1 oragrid oinstall 253,  9 Apr 19 15:09 /dev/dm-9
-bash-4.1# /sbin/udevadm trigger --type=devices --action=change
-bash-4.1# ll /dev/dm-*
brw-rw----. 1 root    disk     253,  0 Apr 19 15:10 /dev/dm-0
brw-rw----. 1 root    disk     253,  1 Apr 19 15:10 /dev/dm-1
brw-rw----. 1 oraprod oinstall 253, 10 Apr 19 15:10 /dev/dm-10
brw-rw----. 1 root    disk     253, 11 Apr 19 15:10 /dev/dm-11
brw-rw----. 1 oraprod oinstall 253, 12 Apr 19 15:10 /dev/dm-12
brw-rw----. 1 root    disk     253, 13 Apr 19 15:10 /dev/dm-13
brw-rw----. 1 root    disk     253, 14 Apr 19 15:10 /dev/dm-14
brw-rw----. 1 root    disk     253, 15 Apr 19 15:10 /dev/dm-15
brw-rw----. 1 root    disk     253, 16 Apr 19 15:10 /dev/dm-16
brw-rw----. 1 root    disk     253, 17 Apr 19 15:10 /dev/dm-17
brw-rw----. 1 root    disk     253, 18 Apr 19 15:10 /dev/dm-18
brw-rw----. 1 root    disk     253, 19 Apr 19 15:10 /dev/dm-19
brw-rw----. 1 oragrid oinstall 253,  2 Apr 19 15:10 /dev/dm-2
brw-rw----. 1 root    disk     253, 20 Apr 19 15:10 /dev/dm-20
brw-rw----. 1 root    disk     253, 21 Apr 19 15:10 /dev/dm-21
brw-rw----. 1 root    disk     253, 22 Apr 19 15:10 /dev/dm-22
brw-rw----. 1 oraprod oinstall 253, 23 Apr 19 15:10 /dev/dm-23
brw-rw----. 1 oraprod oinstall 253, 24 Apr 19 15:10 /dev/dm-24
brw-rw----. 1 oragrid oinstall 253,  3 Apr 19 15:10 /dev/dm-3
brw-rw----. 1 oragrid oinstall 253,  4 Apr 19 15:10 /dev/dm-4
brw-rw----. 1 oragrid oinstall 253,  5 Apr 19 15:10 /dev/dm-5
brw-rw----. 1 oragrid oinstall 253,  6 Apr 19 15:10 /dev/dm-6
brw-rw----. 1 oragrid oinstall 253,  7 Apr 19 15:10 /dev/dm-7
brw-rw----. 1 oraprod oinstall 253,  8 Apr 19 15:10 /dev/dm-8
brw-rw----. 1 oragrid oinstall 253,  9 Apr 19 15:10 /dev/dm-9
-bash-4.1# pwd



oragrid@pansoft ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 19 15:26:45 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>  select state, name, type from v$asm_diskgroup;

STATE       NAME                           TYPE
----------- ------------------------------ ------
MOUNTED     CRS                            EXTERN
MOUNTED     DATA                           EXTERN
MOUNTED     FRA                            EXTERN

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[oragrid@pansoft ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576      3072     2672                0            2672              0             Y  CRS/
MOUNTED  EXTERN  N         512   4096  1048576   1536000   290164                0          290164              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576    358400   331470                0          331470              0             N  FRA/
ASMCMD> exit
[oragrid@pansoft ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 19 15:28:27 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select GROUP_NUMBER,MOUNT_STATUS,STATE,REDUNDANCY,NAME,PATH from v$asm_disk;

GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           0 CLOSED  NORMAL   UNKNOWN
/dev/dm-24

           0 CLOSED  NORMAL   UNKNOWN
/dev/dm-23

           2 CACHED  NORMAL   UNKNOWN DATA_0004
/dev/dm-12


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           2 CACHED  NORMAL   UNKNOWN DATA_0003
/dev/dm-10

           3 CACHED  NORMAL   UNKNOWN FRA_0000
/dev/dm-9

           3 CACHED  NORMAL   UNKNOWN FRA_0001
/dev/dm-8


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           2 CACHED  NORMAL   UNKNOWN DATA_0001
/dev/dm-7

           2 CACHED  NORMAL   UNKNOWN DATA_0002
/dev/dm-6

           2 CACHED  NORMAL   UNKNOWN DATA_0000
/dev/dm-5


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           1 CACHED  NORMAL   UNKNOWN CRS_0002
/dev/dm-4

           1 CACHED  NORMAL   UNKNOWN CRS_0001
/dev/dm-3

           1 CACHED  NORMAL   UNKNOWN CRS_0000
/dev/dm-2


12 rows selected.

SQL> Alter diskgroup FRA add disk '/dev/dm-24' NAME FRA9;

Diskgroup altered.

SQL> select GROUP_NUMBER,MOUNT_STATUS,STATE,REDUNDANCY,NAME,PATH from v$asm_disk;

GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           0 CLOSED  NORMAL   UNKNOWN
/dev/dm-23

           2 CACHED  NORMAL   UNKNOWN DATA_0004
/dev/dm-12

           2 CACHED  NORMAL   UNKNOWN DATA_0003
/dev/dm-10


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           3 CACHED  NORMAL   UNKNOWN FRA_0000
/dev/dm-9

           3 CACHED  NORMAL   UNKNOWN FRA_0001
/dev/dm-8

           2 CACHED  NORMAL   UNKNOWN DATA_0001
/dev/dm-7


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           2 CACHED  NORMAL   UNKNOWN DATA_0002
/dev/dm-6

           2 CACHED  NORMAL   UNKNOWN DATA_0000
/dev/dm-5

           1 CACHED  NORMAL   UNKNOWN CRS_0002
/dev/dm-4


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           1 CACHED  NORMAL   UNKNOWN CRS_0001
/dev/dm-3

           1 CACHED  NORMAL   UNKNOWN CRS_0000
/dev/dm-2

           3 CACHED  NORMAL   UNKNOWN FRA9
/dev/dm-24


12 rows selected.

SQL> Alter diskgroup DATA add disk '/dev/dm-23' NAME DATA9;

Diskgroup altered.

SQL> select GROUP_NUMBER,MOUNT_STATUS,STATE,REDUNDANCY,NAME,PATH from v$asm_disk;

GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           2 CACHED  NORMAL   UNKNOWN DATA_0004
/dev/dm-12

           2 CACHED  NORMAL   UNKNOWN DATA_0003
/dev/dm-10

           3 CACHED  NORMAL   UNKNOWN FRA_0000
/dev/dm-9


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           3 CACHED  NORMAL   UNKNOWN FRA_0001
/dev/dm-8

           2 CACHED  NORMAL   UNKNOWN DATA_0001
/dev/dm-7

           2 CACHED  NORMAL   UNKNOWN DATA_0002
/dev/dm-6


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           2 CACHED  NORMAL   UNKNOWN DATA_0000
/dev/dm-5

           1 CACHED  NORMAL   UNKNOWN CRS_0002
/dev/dm-4

           1 CACHED  NORMAL   UNKNOWN CRS_0001
/dev/dm-3


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           1 CACHED  NORMAL   UNKNOWN CRS_0000
/dev/dm-2

           3 CACHED  NORMAL   UNKNOWN FRA9
/dev/dm-24

           2 CACHED  NORMAL   UNKNOWN DATA9
/dev/dm-23


12 rows selected.

SQL> select GROUP_NUMBER,MOUNT_STATUS,STATE,REDUNDANCY,NAME,PATH from v$asm_disk;

GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           2 CACHED  NORMAL   UNKNOWN DATA_0004
/dev/dm-12

           2 CACHED  NORMAL   UNKNOWN DATA_0003
/dev/dm-10

           3 CACHED  NORMAL   UNKNOWN FRA_0000
/dev/dm-9


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           3 CACHED  NORMAL   UNKNOWN FRA_0001
/dev/dm-8

           2 CACHED  NORMAL   UNKNOWN DATA_0001
/dev/dm-7

           2 CACHED  NORMAL   UNKNOWN DATA_0002
/dev/dm-6


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           2 CACHED  NORMAL   UNKNOWN DATA_0000
/dev/dm-5

           1 CACHED  NORMAL   UNKNOWN CRS_0002
/dev/dm-4

           1 CACHED  NORMAL   UNKNOWN CRS_0001
/dev/dm-3


GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME
------------ ------- -------- ------- ------------------------------
PATH
--------------------------------------------------------------------------------
           1 CACHED  NORMAL   UNKNOWN CRS_0000
/dev/dm-2

           3 CACHED  NORMAL   UNKNOWN FRA9
/dev/dm-24

           2 CACHED  NORMAL   UNKNOWN DATA9
/dev/dm-23


12 rows selected.

SQL> select operation, state,power, actual, sofar, est_work, est_minutes
from v$asm_operation where group_number=1;  2

no rows selected

SQL> select state, name, type from v$asm_diskgroup;

STATE       NAME                           TYPE
----------- ------------------------------ ------
MOUNTED     CRS                            EXTERN
MOUNTED     DATA                           EXTERN
MOUNTED     FRA                            EXTERN

SQL> select name, total_mb/1024 "Total GiB" from v$asm_diskgroup;

NAME                            Total GiB
------------------------------ ----------
CRS                                     3
DATA                                 1800
FRA                                   500

SQL>


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts