ORACLE RAC 扩容ASM磁盘组空间详细步骤.txt

szrsu

236

7页

4次

2024-05-15

10墨值下载

一、需求

由于 ORAARCH 和 ORADATA 这两个 ASM 磁盘组空间紧张，从存储上划分出了两块盘分别为 600G 和 2T，需

要将这两块盘分别添加到这两个 ASM 磁盘组，从而对这两个磁盘组的空间进行扩容。

二、在线扫盘

--在线扫盘，识别新增磁盘，扫盘不用担心，不会影响集群和数据库，所有的 rac 的节点都要做

# for host in /sys/class/scsi_host/host*;do echo "- - -" > $host/scan;done

三、修改磁盘配置

3.1 磁盘配置说明

• 在 ORACLE RAC 中一般有四层磁盘

• 第一层：裸盘（由存储划分过来的）

• 第二层：使用多路径绑定后的磁盘

• 第三层：UDEV 绑定多路径 ID 后的盘

• 第四层：ASM 磁盘

3.2 查看裸盘

• 这里重点要看扫盘后的磁盘哪些是跟客户给的 ID 一致的磁盘

• 这里的 sdai、sdaw、sdg 是同一个 WWN，说明是同一个磁盘的三条路径

# for i in `cat /proc/partitions | awk {'print $4'} |grep sd`; do echo "### $i:

`/usr/lib/udev/scsi_id --whitelist /dev/$i`"; done

### sda: 3600508e000000000399f1f6da560e00d

### sda1: 3600508e000000000399f1f6da560e00d

### sda2: 3600508e000000000399f1f6da560e00d

### sdai: 3600b3424ad60e33def22d24ead0000d9

### sdak: 3600b34287abddc4dad20d9d56d2900d6

### sdam: 3600b3428a8d6156d1e7cddfb3dd900d9

### sdao: 3600b342225bddbed42a3d27c2d5900d6

### sdar: 3600b34242a9fee6de689d7731d5900d9

### sdat: 3600b34293c07bbdd3d02d2b24dcc00d6

### sdau: 3600b342fdd3354dde1d4dd132d4800d9

### sdaw: 3600b3424ad60e33def22d24ead0000d9

### sday: 3600b34287abddc4dad20d9d56d2900d6

### sdba: 3600b3428a8d6156d1e7cddfb3dd900d9

### sdbd: 3600b342225bddbed42a3d27c2d5900d6

### sdbf: 3600b34242a9fee6de689d7731d5900d9

### sdbh: 3600b34293c07bbdd3d02d2b24dcc00d6

### sdbi: 3600b342fdd3354dde1d4dd132d4800d9

### sdg: 3600b3424ad60e33def22d24ead0000d9

### sdh: 3600b34287abddc4dad20d9d56d2900d6

### sdi: 3600b3428a8d6156d1e7cddfb3dd900d9

### sdj: 3600b342225bddbed42a3d27c2d5900d6

### sdk: 3600b34242a9fee6de689d7731d5900d9

### sdl: 3600b34293c07bbdd3d02d2b24dcc00d6

### sdm: 3600b342fdd3354dde1d4dd132d4800d9

### sdn: 3600b3424c37e15cda19ede154d7100d6

### sdo: 3600b342df65ee3adaf40d84ffd9d00d6

### sdp: 3600b3424c37e15cda19ede154d7100d6

### sdq: 3600b342df65ee3adaf40d84ffd9d00d6

### sdr: 3600b3424c37e15cda19ede154d7100d6

### sds: 3600b342df65ee3adaf40d84ffd9d00d6

### sdt: 3600b3424c37e15cda19ede154d7100d6

### sdu: 3600b342df65ee3adaf40d84ffd9d00d6

3.3 修改多路径配置（所有的 rac 的节点都要修改）

--查看当前多路径情况

# multipath -ll

ora-archive-0002 (3600b342df65ee3adaf40d84ffd9d00d6) dm-11 Sugon ,LU

size=600G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| |- 15:0:3:8 sdq 65:0 active ready running

| `- 20:0:1:8 sds 65:32 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:2:8 sdo 8:224 active ready running

`- 20:0:2:8 sdu 65:64 active ready running

ora-archive-0001 (3600b3424ad60e33def22d24ead0000d9) dm-4 Sugon ,LU

size=600G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| `- 15:0:2:0 sdai 66:32 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:0 sdaw 67:0 active ready running

`- 20:0:1:0 sdg 8:96 active ready running

ora-vote-0003 (3600b342fdd3354dde1d4dd132d4800d9) dm-2 Sugon ,LU

size=10G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| `- 15:0:2:6 sdau 66:224 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:6 sdbi 67:192 active ready running

`- 20:0:1:6 sdm 8:192 active ready running

ora-vote-0002 (3600b34293c07bbdd3d02d2b24dcc00d6) dm-8 Sugon ,LU

size=10G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| |- 15:0:3:5 sdbh 67:176 active ready running

| `- 20:0:1:5 sdl 8:176 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

`- 15:0:2:5 sdat 66:208 active ready running

ora-vote-0001 (3600b34242a9fee6de689d7731d5900d9) dm-7 Sugon ,LU

size=10G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| `- 15:0:2:4 sdar 66:176 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:4 sdbf 67:144 active ready running

`- 20:0:1:4 sdk 8:160 active ready running

ora-data-0004 (3600b3424c37e15cda19ede154d7100d6) dm-10 Sugon ,LU

size=2.0T features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| |- 15:0:2:7 sdn 8:208 active ready running

| `- 20:0:2:7 sdt 65:48 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:7 sdp 8:240 active ready running

`- 20:0:1:7 sdr 65:16 active ready running

ora-data-0003 (3600b342225bddbed42a3d27c2d5900d6) dm-5 Sugon ,LU

size=2.0T features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| |- 15:0:3:3 sdbd 67:112 active ready running

| `- 20:0:1:3 sdj 8:144 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

`- 15:0:2:3 sdao 66:128 active ready running

ora-data-0002 (3600b3428a8d6156d1e7cddfb3dd900d9) dm-6 Sugon ,LU

size=2.0T features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| `- 15:0:2:2 sdam 66:96 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:2 sdba 67:64 active ready running

`- 20:0:1:2 sdi 8:128 active ready running

一、需求

由于 ORAARCH 和 ORADATA 这两个 ASM 磁盘组空间紧张，从存储上划分出了两块盘分别为 600G 和 2T，需

要将这两块盘分别添加到这两个 ASM 磁盘组，从而对这两个磁盘组的空间进行扩容。

二、在线扫盘

--在线扫盘，识别新增磁盘，扫盘不用担心，不会影响集群和数据库，所有的 rac 的节点都要做

# for host in /sys/class/scsi_host/host*;do echo "- - -" > $host/scan;done

三、修改磁盘配置

3.1 磁盘配置说明

• 在 ORACLE RAC 中一般有四层磁盘

• 第一层：裸盘（由存储划分过来的）

• 第二层：使用多路径绑定后的磁盘

• 第三层：UDEV 绑定多路径 ID 后的盘

• 第四层：ASM 磁盘

3.2 查看裸盘

• 这里重点要看扫盘后的磁盘哪些是跟客户给的 ID 一致的磁盘

• 这里的 sdai、sdaw、sdg 是同一个 WWN，说明是同一个磁盘的三条路径

# for i in `cat /proc/partitions | awk {'print $4'} |grep sd`; do echo "### $i:

`/usr/lib/udev/scsi_id --whitelist /dev/$i`"; done

### sda: 3600508e000000000399f1f6da560e00d

### sda1: 3600508e000000000399f1f6da560e00d

### sda2: 3600508e000000000399f1f6da560e00d

### sdai: 3600b3424ad60e33def22d24ead0000d9

### sdak: 3600b34287abddc4dad20d9d56d2900d6

### sdam: 3600b3428a8d6156d1e7cddfb3dd900d9

### sdao: 3600b342225bddbed42a3d27c2d5900d6

### sdar: 3600b34242a9fee6de689d7731d5900d9

### sdat: 3600b34293c07bbdd3d02d2b24dcc00d6

### sdau: 3600b342fdd3354dde1d4dd132d4800d9

### sdaw: 3600b3424ad60e33def22d24ead0000d9

### sday: 3600b34287abddc4dad20d9d56d2900d6

### sdba: 3600b3428a8d6156d1e7cddfb3dd900d9

### sdbd: 3600b342225bddbed42a3d27c2d5900d6

### sdbf: 3600b34242a9fee6de689d7731d5900d9

### sdbh: 3600b34293c07bbdd3d02d2b24dcc00d6

### sdbi: 3600b342fdd3354dde1d4dd132d4800d9

### sdg: 3600b3424ad60e33def22d24ead0000d9

### sdh: 3600b34287abddc4dad20d9d56d2900d6

### sdi: 3600b3428a8d6156d1e7cddfb3dd900d9

### sdj: 3600b342225bddbed42a3d27c2d5900d6

### sdk: 3600b34242a9fee6de689d7731d5900d9

### sdl: 3600b34293c07bbdd3d02d2b24dcc00d6

### sdm: 3600b342fdd3354dde1d4dd132d4800d9

### sdn: 3600b3424c37e15cda19ede154d7100d6

### sdo: 3600b342df65ee3adaf40d84ffd9d00d6

### sdp: 3600b3424c37e15cda19ede154d7100d6

### sdq: 3600b342df65ee3adaf40d84ffd9d00d6

### sdr: 3600b3424c37e15cda19ede154d7100d6

### sds: 3600b342df65ee3adaf40d84ffd9d00d6

### sdt: 3600b3424c37e15cda19ede154d7100d6

### sdu: 3600b342df65ee3adaf40d84ffd9d00d6

3.3 修改多路径配置（所有的 rac 的节点都要修改）

--查看当前多路径情况

# multipath -ll

ora-archive-0002 (3600b342df65ee3adaf40d84ffd9d00d6) dm-11 Sugon ,LU

size=600G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| |- 15:0:3:8 sdq 65:0 active ready running

| `- 20:0:1:8 sds 65:32 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:2:8 sdo 8:224 active ready running

`- 20:0:2:8 sdu 65:64 active ready running

ora-archive-0001 (3600b3424ad60e33def22d24ead0000d9) dm-4 Sugon ,LU

size=600G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| `- 15:0:2:0 sdai 66:32 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:0 sdaw 67:0 active ready running

`- 20:0:1:0 sdg 8:96 active ready running

ora-vote-0003 (3600b342fdd3354dde1d4dd132d4800d9) dm-2 Sugon ,LU

size=10G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| `- 15:0:2:6 sdau 66:224 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:6 sdbi 67:192 active ready running

`- 20:0:1:6 sdm 8:192 active ready running

ora-vote-0002 (3600b34293c07bbdd3d02d2b24dcc00d6) dm-8 Sugon ,LU

size=10G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| |- 15:0:3:5 sdbh 67:176 active ready running

| `- 20:0:1:5 sdl 8:176 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

`- 15:0:2:5 sdat 66:208 active ready running

ora-vote-0001 (3600b34242a9fee6de689d7731d5900d9) dm-7 Sugon ,LU

size=10G features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| `- 15:0:2:4 sdar 66:176 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:4 sdbf 67:144 active ready running

`- 20:0:1:4 sdk 8:160 active ready running

ora-data-0004 (3600b3424c37e15cda19ede154d7100d6) dm-10 Sugon ,LU

size=2.0T features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| |- 15:0:2:7 sdn 8:208 active ready running

| `- 20:0:2:7 sdt 65:48 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:7 sdp 8:240 active ready running

`- 20:0:1:7 sdr 65:16 active ready running

ora-data-0003 (3600b342225bddbed42a3d27c2d5900d6) dm-5 Sugon ,LU

size=2.0T features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| |- 15:0:3:3 sdbd 67:112 active ready running

| `- 20:0:1:3 sdj 8:144 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

`- 15:0:2:3 sdao 66:128 active ready running

ora-data-0002 (3600b3428a8d6156d1e7cddfb3dd900d9) dm-6 Sugon ,LU

size=2.0T features='1 queue_if_no_path' hwhandler='0' wp=rw

|-+- policy='round-robin 0' prio=50 status=active

| `- 15:0:2:2 sdam 66:96 active ready running

`-+- policy='round-robin 0' prio=10 status=enabled

|- 15:0:3:2 sdba 67:64 active ready running

`- 20:0:1:2 sdi 8:128 active ready running

of 7

10墨值下载

oracle

关注

评论