Linux （rhel6.8）下将sdx 是新划的盘，加入到 fdata 磁盘组.
OS 系统信息
cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago)
数据库信息：
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 30 21:45:26 2023
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 Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
asm 磁盘信息
[oracle@oradg ~]$ ./ora asmdisk
Disk Group Name Path File Name Fail Group File Size (MB) Used Size (MB) Pct. Used
-------------------- ---------------------------------------- -------------------- -------------------- -------------- -------------- ---------
FDATA /dev/asm-data1 FDATA_0000 FDATA_0000 409,594 385,700 94.17
/dev/asm-data2 FDATA_0001 FDATA_0001 409,594 385,863 94.21
/dev/asm-data3 FDATA_0002 FDATA_0002 409,594 385,741 94.18
/dev/asm-data4 FDATA_0003 FDATA_0003 409,594 386,023 94.25
/dev/asm-data5 FDATA_0004 FDATA_0004 409,594 385,938 94.22
/dev/asm-data6 FDATA_0005 FDATA_0005 409,594 386,059 94.25
/dev/asm-data7 FDATA_0006 FDATA_0006 409,594 385,755 94.18
/dev/asm-data8 FDATA_0007 FDATA_0007 409,594 385,830 94.20
/dev/asm-data9 FDATA_0008 FDATA_0008 409,594 373,230 91.12
/dev/asm-data10 FDATA_0009 FDATA_0009 409,594 384,811 93.95
/dev/asm-data11 FDATA_0010 FDATA_0010 409,594 366,216 89.41
******************** -------------- --------------
4,505,534 4,211,166
FRA /dev/asm-fra1 FRA_0000 FRA_0000 512,000 1,842 .36
******************** -------------- --------------
512,000 1,842
-------------- --------------
Grand Total: 5,017,534 4,213,008
sdx 磁盘信息：
[root@oradg ~]# upadmin show vlun ---------------------------------------------------------------------------------------------------------------------------------------------------------------- Vlun ID Disk Name Lun WWN Status Capacity Ctrl(Own/Work) Array Name Dev Lun ID No. of Paths(Available/Total) 0 sdb oradg_data1 xxxxxxxxxxxxxxxx4008f15900000002 Normal 400.00GB 0B/0B HVS.Storage 2 4/4 1 sdc oradg_data2 xxxxxxxxxxxxxxxx40094bae0000003e Normal 400.00GB 0B/0B HVS.Storage 62 4/4 2 sdd oradg_data3 xxxxxxxxxxxxxxxx4009af560000003f Normal 400.00GB 0A/0A HVS.Storage 63 4/4 3 sde oradg_data4 xxxxxxxxxxxxxxxx400a10a200000040 Normal 400.00GB 0B/0B HVS.Storage 64 4/4 4 sdf oradg_arch1 xxxxxxxxxxxxxxxx400b09c800000041 Normal 500.00GB 0A/0A HVS.Storage 65 4/4 5 sdg oradg_file1 xxxxxxxxxxxxxxxx4828a71600000097 Normal 1.00TB 0B/0B HVS.Storage 151 4/4 6 sdh oradg_data5 xxxxxxxxxxxxxxxx5c5088ee0000006a Normal 400.00GB 0B/0B HVS.Storage 106 4/4 7 sdi oradg_data6 xxxxxxxxxxxxxxxx5c519a9b00000073 Normal 400.00GB 0A/0A HVS.Storage 115 4/4 8 sdj oradg_data7 xxxxxxxxxxxxxxxx5c51aadd0000007d Normal 400.00GB 0B/0B HVS.Storage 125 4/4 9 sdk oradg_data8 xxxxxxxxxxxxxxxx5c51b89e00000096 Normal 400.00GB 0A/0A HVS.Storage 150 4/4 10 sdl oradg_data9 xxxxxxxxxxxxxxxx79a091150000001d Normal 400.00GB 0A/0A HVS.Storage 29 4/4 11 sdm oradg_data10 xxxxxxxxxxxxxxxx0082eedc00000026 Normal 400.00GB 0A/0A HVS.Storage 38 4/4 12 sdn oradg_data11 xxxxxxxxxxxxxxxxfa56f87f00000029 Normal 400.00GB 0B/0B HVS.Storage 41 4/4 13 sdx oradg_data12 xxxxxxxxxxxxxxxxda40035c0000001e Normal 400.00GB 0A/0A HVS.Storage 30 4/4 ----------------------------------------------------------------------------------------------------------------------------------------------------------------
fdisk -l 确认磁盘
fdisk -l Disk /dev/sdn: 429.5 GB, 429496729600 bytes 255 heads, 63 sectors/track, 52216 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x69a0fecb Device Boot Start End Blocks Id System /dev/sdn1 1 52216 419424988+ 83 Linux Disk /dev/sdx: 429.5 GB, 429496729600 bytes 255 heads, 63 sectors/track, 52216 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00000000 ---
检查 udev 配置
[root@oradg ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx4008f15900000002", NAME="asm-data1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx40094bae0000003e", NAME="asm-data2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx4009af560000003f", NAME="asm-data3", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx400a10a200000040", NAME="asm-data4", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx5c5088ee0000006a", NAME="asm-data5", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx5c519a9b00000073", NAME="asm-data6", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx5c51aadd0000007d", NAME="asm-data7", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx5c51b89e00000096", NAME="asm-data8", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx79a091150000001d", NAME="asm-data9", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxx0082eedc00000026", NAME="asm-data10", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxxfa56f87f00000029", NAME="asm-data11", OWNER="grid", GROUP="asmadmin", MODE="0660"
可以看到，KERNEL==“sd*1”，此处都带了数字1，是通过fdisk 进行了分区。
获取 scsi_id
[root@oradg ~]# /sbin/scsi_id -g -u /dev/sdn
3xxxxxxxxxxxxxxxxfa56f87f00000029
对 sdx 磁盘进行分区
[root@oradg ~]# fdisk /dev/sdx
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0x50f8c57e.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4):
Value out of range.
Partition number (1-4): 1
First cylinder (1-52216, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-52216, default 52216):
Using default value 52216
Command (m for help):
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
修改 udev 配置文件
vi /etc/udev/rules.d/99-oracle-asmdevices.rules
新增：
KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="3xxxxxxxxxxxxxxxxda40035c0000001e", NAME="asm-data12", OWNER="grid", GROUP="asmadmin", MODE="0660"
⚠️注意： RESULT 和 name 都需要修改，尤其是 name。
udev 生效
#udevadm control --reload-rules
[18:29:04:934]KERNEL=="sd*1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$parent", RESULT=="364846fb10092751cda40035c0000001e", NAME="asm-data12", OWNER="grid", GROUP="asmadmin", MODE="0660"
[18:29:04:935]KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u /dev/$name", RESULT=="364846fb10092751c400b09c800000041", NAME="asm-fra1", OWNER="grid", GROUP="asmadmin", MODE="0660"
[18:29:04:935]
[18:31:52:213][root@oradg ~]# udevadm control --reload-rules
[18:34:26:746][root@oradg ~]# ll /dev/asm*
[18:34:26:749]brw-rw---- 1 grid asmadmin 8, 17 Jan 30 17:24 /dev/asm-data1
[18:34:26:749]brw-rw---- 1 grid asmadmin 8, 193 Jan 30 17:24 /dev/asm-data10
[18:34:26:749]brw-rw---- 1 grid asmadmin 8, 209 Jan 30 17:24 /dev/asm-data11
[18:34:26:749]brw-rw---- 1 grid asmadmin 65, 1 Jan 30 17:24 /dev/asm-data12
[18:34:26:749]brw-rw---- 1 grid asmadmin 8, 33 Jan 30 17:24 /dev/asm-data2
[18:34:26:749]brw-rw---- 1 grid asmadmin 8, 49 Jan 30 17:24 /dev/asm-data3
[18:34:26:750]brw-rw---- 1 grid asmadmin 8, 65 Jan 30 17:24 /dev/asm-data4
[18:34:26:750]brw-rw---- 1 grid asmadmin 8, 113 Jan 30 17:24 /dev/asm-data5
[18:34:26:750]brw-rw---- 1 grid asmadmin 8, 129 Jan 30 17:24 /dev/asm-data6
[18:34:26:750]brw-rw---- 1 grid asmadmin 8, 145 Jan 30 17:24 /dev/asm-data7
[18:34:26:750]brw-rw---- 1 grid asmadmin 8, 161 Jan 30 17:24 /dev/asm-data8
[18:34:26:750]brw-rw---- 1 grid asmadmin 8, 177 Jan 30 17:24 /dev/asm-data9
确认udev 生效
可以看到 /dev/asm-data12 已经生效。
asm 磁盘扩容
su - grid
sqlplus / as sysasm
ALTER DISKGROUP FDATA ADD DISK '/dev/asm-data12';
alter diskgroup FDATA rebalance power 6;
最后修改时间：2023-01-31 07:16:51
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
