添加删除ASM磁盘 – 简艾

添加删除ASM磁盘

2022-7-30 8:51

|

381

|

0

|

Oracle

293 字

|

9 分钟

ASM磁盘组添加删除磁盘

一、查看磁盘

1.查看本地磁盘

[root@oadb1 ~]# ll /dev/sd*
brw-rw---- 1 root disk     8,   0 Jul 29 18:26 /dev/sda
brw-rw---- 1 root disk     8,   1 Jul 29 18:26 /dev/sda1
brw-rw---- 1 root disk     8,   2 Jul 29 18:26 /dev/sda2
brw-rw---- 1 root disk     8,   3 Jul 29 18:26 /dev/sda3
brw-rw---- 1 root disk     8,   4 Jul 29 18:26 /dev/sda4
brw-rw---- 1 grid asmadmin 8,  16 Jul 30 08:10 /dev/sdb
brw-rw---- 1 grid asmadmin 8,  32 Jul 30 08:10 /dev/sdc
brw-rw---- 1 grid asmadmin 8,  48 Jul 30 08:10 /dev/sdd
brw-rw---- 1 grid asmadmin 8,  64 Jul 30 08:10 /dev/sde
brw-rw---- 1 grid asmadmin 8,  80 Jul 30 08:10 /dev/sdf
brw-rw---- 1 grid asmadmin 8,  96 Jul 30 08:10 /dev/sdg
brw-rw---- 1 grid asmadmin 8, 112 Jul 30 08:10 /dev/sdh
brw-rw---- 1 grid asmadmin 8, 128 Jul 30 08:10 /dev/sdi
brw-rw---- 1 grid asmadmin 8, 144 Jul 30 08:10 /dev/sdj
brw-rw---- 1 grid asmadmin 8, 160 Jul 30 08:10 /dev/sdk
brw-rw---- 1 grid asmadmin 8, 176 Jul 30 08:10 /dev/sdl
brw-rw---- 1 grid asmadmin 8, 192 Jul 30 08:10 /dev/sdm
brw-rw---- 1 grid asmadmin 8, 208 Jul 30 08:10 /dev/sdn

[root@oadb1 ~]# fdisk -l

2.确认需添加的磁盘

/dev/sdk
/dev/sdl
/dev/sdm
/dev/sdn

3.查看当前ASM磁盘

set linesize 200 pagesize 200
col name for a15
col path for a50
select name,path,state,mount_status,header_status from v$asm_disk order by  name;

NAME            PATH                                               STATE    MOUNT_S HEADER_STATU
--------------- -------------------------------------------------- -------- ------- ------------
DATA_0000       /dev/asm-data01                                    NORMAL   CACHED  MEMBER
DATA_0001       /dev/asm-data02                                    NORMAL   CACHED  MEMBER
DATA_0002       /dev/asm-data03                                    NORMAL   CACHED  MEMBER
DATA_0003       /dev/asm-data04                                    NORMAL   CACHED  MEMBER
FRA_0000        /dev/asm-fra1                                      NORMAL   CACHED  MEMBER
FRA_0001        /dev/asm-fra2                                      NORMAL   CACHED  MEMBER
OCR_0000        /dev/asm-ocr1                                      NORMAL   CACHED  MEMBER
OCR_0001        /dev/asm-ocr2                                      NORMAL   CACHED  MEMBER
OCR_0002        /dev/asm-ocr3                                      NORMAL   CACHED  MEMBER

二、配置 UDEV 绑定 SCSI ID

RAC两节点都需要配置99-oracle-asmdevices.rules

for i in k l m n;
do
echo "KERNEL==\"sd?\",SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\",RESULT==\"`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", SYMLINK+=\"asmdisk$i\",OWNER=\"grid\", GROUP=\"asmadmin\",MODE=\"0660\""
done

[root@oadb1 ~]# vim /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36888603000001713fa1660
f531274223", SYMLINK+="asm-data01",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36888603000001714fa1660
f531274223", SYMLINK+="asm-data02",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36888603000001717fa1660
f531274223", SYMLINK+="asm-data03",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36888603000001715fa1660
f531274223", SYMLINK+="asm-data04",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36888603000000a33fa166
0f531274223", SYMLINK+="asm-data05",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36888603000000179fa166
0f531274223", SYMLINK+="asm-data06",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="3688860300000203dfa166
0f531274223", SYMLINK+="asm-data07",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36888603000001007fa166
0f531274223", SYMLINK+="asm-data08",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36888603000001718fa1660
f531274223", SYMLINK+="asm-fra1",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36888603000001716fa1660
f531274223", SYMLINK+="asm-fra2",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36888603000001832fa1660
f531274223", SYMLINK+="asm-ocr1",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000182ffa1660
f531274223", SYMLINK+="asm-ocr2",OWNER="grid", GROUP="asmadmin",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000182efa1660
f531274223", SYMLINK+="asm-ocr3",OWNER="grid", GROUP="asmadmin",MODE="0660"

三、重新启动UDEV

[root@server01 ~]# udevadm trigger --type=devices --action=change
[root@server01 ~]# udevadm control --reload

四、确认ASM磁盘信息

[root@oadb1 ~]# ll /dev/asm*
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data01 -> sdb
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data02 -> sdc
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data03 -> sdd
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data04 -> sde
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data05 -> sdk
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data06 -> sdl
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data07 -> sdm
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data08 -> sdn
lrwxrwxrwx 1 root root 3 Jul 30 06:57 /dev/asm-fra1 -> sdf
lrwxrwxrwx 1 root root 3 Jul 30 08:13 /dev/asm-fra2 -> sdg
lrwxrwxrwx 1 root root 3 Jul 30 06:41 /dev/asm-ocr1 -> sdh
lrwxrwxrwx 1 root root 3 Jul 30 06:46 /dev/asm-ocr2 -> sdi
lrwxrwxrwx 1 root root 3 Jul 29 19:36 /dev/asm-ocr3 -> sdj

[root@oadb2 ~]# ll /dev/asm*
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data01 -> sdb
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data02 -> sdc
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data03 -> sdd
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data04 -> sdf
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data05 -> sdk
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data06 -> sdm
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data07 -> sdl
lrwxrwxrwx 1 root root 3 Jul 30 08:21 /dev/asm-data08 -> sdn
lrwxrwxrwx 1 root root 3 Jul 30 07:17 /dev/asm-fra1 -> sde
lrwxrwxrwx 1 root root 3 Jul 30 08:03 /dev/asm-fra2 -> sdg
lrwxrwxrwx 1 root root 3 Jul 29 19:15 /dev/asm-ocr1 -> sdj
lrwxrwxrwx 1 root root 3 Jul 29 19:15 /dev/asm-ocr2 -> sdh
lrwxrwxrwx 1 root root 3 Jul 29 19:15 /dev/asm-ocr3 -> sdi

set linesize 200 pagesize 200
col name for a15
col path for a50
select name,path,state,mount_status,header_status from v$asm_disk order by  name;

NAME            PATH                                               STATE    MOUNT_S HEADER_STATU
--------------- -------------------------------------------------- -------- ------- ------------
DATA_0000       /dev/asm-data01                                    NORMAL   CACHED  MEMBER
DATA_0001       /dev/asm-data02                                    NORMAL   CACHED  MEMBER
DATA_0002       /dev/asm-data03                                    NORMAL   CACHED  MEMBER
DATA_0003       /dev/asm-data04                                    NORMAL   CACHED  MEMBER
FRA_0000        /dev/asm-fra1                                      NORMAL   CACHED  MEMBER
FRA_0001        /dev/asm-fra2                                      NORMAL   CACHED  MEMBER
OCR_0000        /dev/asm-ocr1                                      NORMAL   CACHED  MEMBER
OCR_0001        /dev/asm-ocr2                                      NORMAL   CACHED  MEMBER
OCR_0002        /dev/asm-ocr3                                      NORMAL   CACHED  MEMBER
                /dev/asm-data05                                    NORMAL   CLOSED  CANDIDATE
                /dev/asm-data08                                    NORMAL   CLOSED  CANDIDATE
                /dev/asm-data07                                    NORMAL   CLOSED  CANDIDATE
                /dev/asm-data06                                    NORMAL   CLOSED  CANDIDATE

五、添加ASM磁盘

添加磁盘只需在一个节点执行即可

SQL> alter diskgroup data add disk
'/dev/asm-data05' name DATA_0004,
'/dev/asm-data06' name DATA_0005,
'/dev/asm-data07' name DATA_0006,
'/dev/asm-data08' name DATA_0007
rebalance power 8;

asm_power_limit该参数在11.2.0.2以下版本中,其取值范围是0~11. 在11.2.0.2以及以上版本取值范围已经扩展为0~1024了.

如果想等待磁盘同步完成后才返回Diskgroup altered的提示，则可以在命令后面加wait
SQL> alter diskgroup data add disk
'/dev/asm-data05' name DATA_0004,
'/dev/asm-data06' name DATA_0005,
'/dev/asm-data07' name DATA_0006,
'/dev/asm-data08' name DATA_0007
rebalance power 8 wait;

六、删除ASM磁盘

set linesize 200 pagesize 200
col name for a15
col path for a50
select name,path,state,mount_status,header_status from v$asm_disk order by  name;

SQL> alter diskgroup data drop disk
DATA_0004,
DATA_0005,
DATA_0006,
DATA_0007
rebalance power 8;

---取消删除磁盘
alter diskgroup data undrop disks;

七、查看ASM磁盘同步

SQL> select * from v$asm_operation;

暂无评论

发送评论编辑评论

Markdown

|´・ω・)ノ

ヾ(≧∇≦*)ゝ

(☆ω☆)

（╯‵□′）╯︵┴─┴

￣﹃￣

(/ω＼)

∠( ᐛ 」∠)＿

(๑•̀ㅁ•́ฅ)

→_→

୧(๑•̀⌄•́๑)૭

٩(ˊᗜˋ*)و

(ノ°ο°)ノ

(´இ皿இ｀)

⌇●﹏●⌇

(ฅ´ω`ฅ)

(╯°A°)╯︵○○○

φ(￣∇￣o)

ヾ(´･･｀｡)ノ"

( ง ᵒ̌皿ᵒ̌)ง⁼³₌₃

(ó﹏ò｡)

Σ(っ °Д °;)っ

( ,,´･ω･)ﾉ"(´っω･｀｡)

╮(╯▽╰)╭

o(*////▽////*)q

＞﹏＜

( ๑´•ω•) "(ㆆᴗㆆ)

颜文字

Emoji

小恐龙

花!