Sunday, October 4, 2020

How to add space in existing disk group ASM


[root@pansoftrules.d]# rescan-scsi-bus.sh -s

 Scanning SCSI subsystem for new devices
Searching for resized LUNs
0 new or changed device(s) found.
0 remapped or resized device(s) found.
0 device(s) removed.
[root@pansoftrules.d]# multipath -ll
crs4 (360002ac00000000009002625000157e7) dm-6 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:6 sdi               8:128  active ready running
  |- 3:0:0:6 sdaa              65:160 active ready running
  |- 2:0:1:6 sdr               65:16  active ready running
  `- 3:0:1:6 sdaj              66:48  active ready running
crs3 (360002ac00000000009002626000157e7) dm-9 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:7 sdj               8:144  active ready running
  |- 3:0:0:7 sdab              65:176 active ready running
  |- 2:0:1:7 sds               65:32  active ready running
  `- 3:0:1:7 sdak              66:64  active ready running
crs2 (360002ac00000000009002627000157e7) dm-8 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:8 sdk               8:160  active ready running
  |- 3:0:0:8 sdac              65:192 active ready running
  |- 2:0:1:8 sdt               65:48  active ready running
  `- 3:0:1:8 sdal              66:80  active ready running
crs1 (360002ac00000000009002622000157e7) dm-3 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:2 sde               8:64   active ready running
  |- 3:0:0:2 sdw               65:96  active ready running
  |- 2:0:1:2 sdn               8:208  active ready running
  `- 3:0:1:2 sdaf              65:240 active ready running
mpathk (360002ac0000000000900d2cf000157e7) dm-5 3PARdata,VV
size=300G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:1:3 sdo               8:224  active ready running
  |- 3:0:0:3 sdx               65:112 active ready running
  |- 2:0:0:3 sdf               8:80   active ready running
  `- 3:0:1:3 sdag              66:0   active ready running
fra (360002ac000000000090025b3000157e7) dm-4 3PARdata,VV
size=300G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:1 sdd               8:48   active ready running
  |- 3:0:0:1 sdv               65:80  active ready running
  |- 2:0:1:1 sdm               8:192  active ready running
  `- 3:0:1:1 sdae              65:224 active ready running
data (360002ac000000000090025b2000157e7) dm-2 3PARdata,VV
size=900G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:0 sdc               8:32   active ready running
  |- 3:0:0:0 sdu               65:64  active ready running
  |- 2:0:1:0 sdl               8:176  active ready running
  `- 3:0:1:0 sdad              65:208 active ready running
crs5 (360002ac00000000009002623000157e7) dm-7 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:4 sdg               8:96   active ready running
  |- 3:0:0:4 sdy               65:128 active ready running
  |- 2:0:1:4 sdp               8:240  active ready running
  `- 3:0:1:4 sdah              66:16  active ready running
mpathf (360002ac00000000009002624000157e7) dm-10 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:5 sdh               8:112  active ready running
  |- 3:0:0:5 sdz               65:144 active ready running
  |- 2:0:1:5 sdq               65:0   active ready running
  `- 3:0:1:5 sdai              66:32  active ready running

[root@pansoftrules.d]# systemctl status multipathd

 multipathd.service - Device-Mapper Multipath Device Controller
   Loaded: loaded (/usr/lib/systemd/system/multipathd.service; enabled; vendor preset: enabled)
   Active: active (running) since Sun 2020-01-12 13:26:23 +03; 3 months 6 days ago
  Process: 6287 ExecStart=/sbin/multipathd (code=exited, status=0/SUCCESS)
  Process: 6230 ExecStartPre=/sbin/multipath -A (code=exited, status=0/SUCCESS)
  Process: 6183 ExecStartPre=/sbin/modprobe dm-multipath (code=exited, status=0/SUCCESS)
 Main PID: 6353 (multipathd)
   CGroup: /system.slice/multipathd.service
Jan 12 13:27:16 pansoft.dba.com multipathd[6353]: ofsctl: add path (uevent)
Jan 12 13:27:16 pansoft.dba.com multipathd[6353]: ofsctl: spurious uevent, path already in pathvec
Jan 12 13:27:16 pansoft.dba.com multipathd[6353]: ofsctl: HDIO_GETGEO failed with 25
Jan 12 13:27:16 pansoft.dba.com multipathd[6353]: ofsctl: failed to get path uid
Jan 12 13:27:16 pansoft.dba.com multipathd[6353]: uevent trigger error
Jan 12 13:27:26 pansoft.dba.com multipathd[6353]: ofsctl: add path (uevent)
Jan 12 13:27:26 pansoft.dba.com multipathd[6353]: ofsctl: spurious uevent, path already in pathvec
Jan 12 13:27:26 pansoft.dba.com multipathd[6353]: ofsctl: HDIO_GETGEO failed with 25
Jan 12 13:27:26 pansoft.dba.com multipathd[6353]: ofsctl: failed to get path uid
Jan 12 13:27:26 pansoft.dba.com multipathd[6353]: uevent trigger error
[root@pansoftrules.d]# systemctl restart multipathd
[root@pansoftrules.d]# systemctl status multipathd
multipathd.service - Device-Mapper Multipath Device Controller
   Loaded: loaded (/usr/lib/systemd/system/multipathd.service; enabled; vendor preset: enabled)
   Active: active (running) since Sun 2020-04-19 12:06:59 +03; 2s ago
  Process: 4134 ExecStart=/sbin/multipathd (code=exited, status=0/SUCCESS)
  Process: 4131 ExecStartPre=/sbin/multipath -A (code=exited, status=0/SUCCESS)
  Process: 4129 ExecStartPre=/sbin/modprobe dm-multipath (code=exited, status=0/SUCCESS)
 Main PID: 4137 (multipathd)
   CGroup: /system.slice/multipathd.service
           


Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: data: event checker started
Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: fra: event checker started
Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: crs1: event checker started
Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: mpathk: event checker started
Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: crs5: event checker started
Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: mpathf: event checker started
Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: crs4: event checker started
Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: crs3: event checker started
Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: crs2: event checker started
Apr 19 12:07:00 pansoft.dba.com multipathd[4137]: path checkers start up
[root@pansoftrules.d]#

[root@pansoftrules.d]# multipath -ll

crs4 (360002ac00000000009002625000157e7) dm-6 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:6 sdi               8:128  active ready running
  |- 3:0:0:6 sdaa              65:160 active ready running
  |- 2:0:1:6 sdr               65:16  active ready running
  `- 3:0:1:6 sdaj              66:48  active ready running
crs3 (360002ac00000000009002626000157e7) dm-9 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:7 sdj               8:144  active ready running
  |- 3:0:0:7 sdab              65:176 active ready running
  |- 2:0:1:7 sds               65:32  active ready running
  `- 3:0:1:7 sdak              66:64  active ready running
crs2 (360002ac00000000009002627000157e7) dm-8 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:8 sdk               8:160  active ready running
  |- 3:0:0:8 sdac              65:192 active ready running
  |- 2:0:1:8 sdt               65:48  active ready running
  `- 3:0:1:8 sdal              66:80  active ready running
crs1 (360002ac00000000009002622000157e7) dm-3 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:2 sde               8:64   active ready running
  |- 3:0:0:2 sdw               65:96  active ready running
  |- 2:0:1:2 sdn               8:208  active ready running
  `- 3:0:1:2 sdaf              65:240 active ready running
mpathk (360002ac0000000000900d2cf000157e7) dm-5 3PARdata,VV
size=300G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:1:3 sdo               8:224  active ready running
  |- 3:0:0:3 sdx               65:112 active ready running
  |- 2:0:0:3 sdf               8:80   active ready running
  `- 3:0:1:3 sdag              66:0   active ready running
fra (360002ac000000000090025b3000157e7) dm-4 3PARdata,VV
size=300G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:1 sdd               8:48   active ready running
  |- 3:0:0:1 sdv               65:80  active ready running
  |- 2:0:1:1 sdm               8:192  active ready running
  `- 3:0:1:1 sdae              65:224 active ready running
data (360002ac000000000090025b2000157e7) dm-2 3PARdata,VV
size=900G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:0 sdc               8:32   active ready running
  |- 3:0:0:0 sdu               65:64  active ready running
  |- 2:0:1:0 sdl               8:176  active ready running
  `- 3:0:1:0 sdad              65:208 active ready running
crs5 (360002ac00000000009002623000157e7) dm-7 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:4 sdg               8:96   active ready running
  |- 3:0:0:4 sdy               65:128 active ready running
  |- 2:0:1:4 sdp               8:240  active ready running
  `- 3:0:1:4 sdah              66:16  active ready running
mpathf (360002ac00000000009002624000157e7) dm-10 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:5 sdh               8:112  active ready running
  |- 3:0:0:5 sdz               65:144 active ready running
  |- 2:0:1:5 sdq               65:0   active ready running
  `- 3:0:1:5 sdai              66:32  active ready running

[root@pansoftrules.d]# multipathd resize fra

multipath-tools v0.4.9 (05/33, 2016)
CLI commands reference:
 list|show paths
 list|show paths format $format
 list|show paths raw format $format
 list|show status
 list|show daemon
 list|show maps|multipaths
 list|show maps|multipaths status
 list|show maps|multipaths stats
 list|show maps|multipaths format $format
 list|show maps|multipaths raw format $format
 list|show maps|multipaths topology
 list|show maps|multipaths json
 list|show topology
 list|show map|multipath $map topology
 list|show map|multipath $map json
 list|show config
 list|show blacklist
 list|show devices
 list|show wildcards
 reset maps|multipaths stats
 reset map|multipath $map stats
 add path $path
 remove|del path $path
 add map|multipath $map
 remove|del map|multipath $map
 switch|switchgroup map|multipath $map group $group
 reconfigure
 suspend map|multipath $map
 resume map|multipath $map
 resize map|multipath $map
 reset map|multipath $map
 reload map|multipath $map
 disablequeueing map|multipath $map
 restorequeueing map|multipath $map
 disablequeueing maps|multipaths
 restorequeueing maps|multipaths
 reinstate path $path
 fail path $path
 quit|exit
 shutdown
 map|multipath $map getprstatus
 map|multipath $map setprstatus
 map|multipath $map unsetprstatus
 map|multipath $map getprkey
 map|multipath $map setprkey key $key
 map|multipath $map unsetprkey
 forcequeueing daemon
 restorequeueing daemon

[root@pansoftrules.d]# multipath -ll

crs4 (360002ac00000000009002625000157e7) dm-6 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:6 sdi               8:128  active ready running
  |- 3:0:0:6 sdaa              65:160 active ready running
  |- 2:0:1:6 sdr               65:16  active ready running
  `- 3:0:1:6 sdaj              66:48  active ready running
crs3 (360002ac00000000009002626000157e7) dm-9 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:7 sdj               8:144  active ready running
  |- 3:0:0:7 sdab              65:176 active ready running
  |- 2:0:1:7 sds               65:32  active ready running
  `- 3:0:1:7 sdak              66:64  active ready running
crs2 (360002ac00000000009002627000157e7) dm-8 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:8 sdk               8:160  active ready running
  |- 3:0:0:8 sdac              65:192 active ready running
  |- 2:0:1:8 sdt               65:48  active ready running
  `- 3:0:1:8 sdal              66:80  active ready running
crs1 (360002ac00000000009002622000157e7) dm-3 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:2 sde               8:64   active ready running
  |- 3:0:0:2 sdw               65:96  active ready running
  |- 2:0:1:2 sdn               8:208  active ready running
  `- 3:0:1:2 sdaf              65:240 active ready running
mpathk (360002ac0000000000900d2cf000157e7) dm-5 3PARdata,VV
size=300G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:1:3 sdo               8:224  active ready running
  |- 3:0:0:3 sdx               65:112 active ready running
  |- 2:0:0:3 sdf               8:80   active ready running
  `- 3:0:1:3 sdag              66:0   active ready running
fra (360002ac000000000090025b3000157e7) dm-4 3PARdata,VV
size=300G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:1 sdd               8:48   active ready running
  |- 3:0:0:1 sdv               65:80  active ready running
  |- 2:0:1:1 sdm               8:192  active ready running
  `- 3:0:1:1 sdae              65:224 active ready running
data (360002ac000000000090025b2000157e7) dm-2 3PARdata,VV
size=900G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:0 sdc               8:32   active ready running
  |- 3:0:0:0 sdu               65:64  active ready running
  |- 2:0:1:0 sdl               8:176  active ready running
  `- 3:0:1:0 sdad              65:208 active ready running
crs5 (360002ac00000000009002623000157e7) dm-7 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:4 sdg               8:96   active ready running
  |- 3:0:0:4 sdy               65:128 active ready running
  |- 2:0:1:4 sdp               8:240  active ready running
  `- 3:0:1:4 sdah              66:16  active ready running
mpathf (360002ac00000000009002624000157e7) dm-10 3PARdata,VV
size=10G features='1 queue_if_no_path' hwhandler='1 alua' wp=rw
`-+- policy='round-robin 0' prio=50 status=active
  |- 2:0:0:5 sdh               8:112  active ready running
  |- 3:0:0:5 sdz               65:144 active ready running
  |- 2:0:1:5 sdq               65:0   active ready running
  `- 3:0:1:5 sdai              66:32  active ready running

[oragrid@pansoft~]$ . grid.env
[oragrid@pansoft~]$ asmca
[oragrid@pansoft~]$ asmca
[oragrid@pansoft~]$ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 19 11:53:07 2020
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> desc v$asm_diskgroup;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP_NUMBER                                       NUMBER
 NAME                                               VARCHAR2(30)
 SECTOR_SIZE                                        NUMBER
 BLOCK_SIZE                                         NUMBER
 ALLOCATION_UNIT_SIZE                               NUMBER
 STATE                                              VARCHAR2(11)
 TYPE                                               VARCHAR2(6)
 TOTAL_MB                                           NUMBER
 FREE_MB                                            NUMBER
 HOT_USED_MB                                        NUMBER
 COLD_USED_MB                                       NUMBER
 REQUIRED_MIRROR_FREE_MB                            NUMBER
 USABLE_FILE_MB                                     NUMBER
 OFFLINE_DISKS                                      NUMBER
 COMPATIBILITY                                      VARCHAR2(60)
 DATABASE_COMPATIBILITY                             VARCHAR2(60)
 VOTING_FILES                                       VARCHAR2(1)
 CON_ID                                             NUMBER
SQL> select name, total_mb/1024 "Total GiB" from v$asm_diskgroup;
NAME                            Total GiB
------------------------------ ----------
FRA                                   250
DATA                                  900
CRS                                    50
SQL> alter diskgroup FRA resize all;
Diskgroup altered.
NAME                            Total GiB
------------------------------ ----------
FRA                                   300
DATA                                  900
CRS                                    50
SQL>


SQL>  select name, total_mb/1024 "Total GiB" from v$asm_diskgroup;
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