環(huán)境:linux6.5 Oracle RAC集群兩節(jié)點,Oracle版本11.2.0.4
創(chuàng)新互聯(lián)建站-專業(yè)網(wǎng)站定制、快速模板網(wǎng)站建設(shè)、高性價比石棉網(wǎng)站開發(fā)、企業(yè)建站全套包干低至880元,成熟完善的模板庫,直接使用。一站式石棉網(wǎng)站制作公司更省心,省錢,快速模板網(wǎng)站建設(shè)找我們,業(yè)務(wù)覆蓋石棉地區(qū)。費用合理售后完善,10年實體公司更值得信賴。
(1 )磁盤情況:
[root@db1 ~]# fdisk -l
Disk /dev/sda: 85.9 GB, 85899345920 bytes 255 heads, 63 sectors/track, 10443 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: 0x000d2f26 Device Boot Start End Blocks Id System /dev/sda1 * 1 64 512000 83 Linux Partition 1 does not end on cylinder boundary. /dev/sda2 64 10444 83373056 8e Linux LVM Disk /dev/sdb: 53.7 GB, 53687091200 bytes 255 heads, 63 sectors/track, 6527 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 Disk /dev/sdd: 1073 MB, 1073741824 bytes 255 heads, 63 sectors/track, 130 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 Disk /dev/sdc: 53.7 GB, 53687091200 bytes 255 heads, 63 sectors/track, 6527 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 Disk /dev/sde: 1073 MB, 1073741824 bytes 255 heads, 63 sectors/track, 130 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 Disk /dev/sdf: 1073 MB, 1073741824 bytes 255 heads, 63 sectors/track, 130 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 Disk /dev/sdg: 21.5 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 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 Disk /dev/sdh: 21.5 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 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 Disk /dev/mapper/vg_db1-lv_root: 53.7 GB, 53687091200 bytes 255 heads, 63 sectors/track, 6527 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 Disk /dev/mapper/vg_db1-lv_swap: 8405 MB, 8405385216 bytes 255 heads, 63 sectors/track, 1021 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 Disk /dev/mapper/vg_db1-lv_home: 23.3 GB, 23278387200 bytes 255 heads, 63 sectors/track, 2830 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
(2 )ASM 磁盤情況:
SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,STATE,TOTAL_MB,PATH,NAME from v$asm_disk order by GROUP_NUMBER,DISK_NUMBER;
GROUP_NUMBER DISK_NUMBER MOUNT_S STATE TOTAL_MB PATH NAME ------------ ----------- ------- -------- ---------- -------------------- -------------------- 1 0 CACHED NORMAL 51200 /dev/asmdiske DATA_0000 1 1 CACHED NORMAL 51200 /dev/asmdiskf DATA_0001 2 0 CACHED NORMAL 20480 /dev/asmdiskg ARCH_0000 3 0 CACHED NORMAL 1024 /dev/asmdiskb OCR_0000 3 1 CACHED NORMAL 1024 /dev/asmdiskc OCR_0001 3 2 CACHED NORMAL 1024 /dev/asmdiskd OCR_0002 6 rows selected.
結(jié)論:ASM 掛了6 塊磁盤,通過容量可能看到有一塊21.5G 的未掛載進來,也新盤還未使用,查看21.5G 的磁盤,我們發(fā)現(xiàn)有 /dev/sdg 和 /dev/sdh 。
(3 )ASM 磁盤對應(yīng)物理盤:
[root@db1 rules.d]# pwd
/etc/udev/rules.d
[root@db1 rules.d]# more 99-x-asmdisk_new.rules
KERNEL=="sd?", ENV{ID_SERIAL}=="36000c29c5362298e7a9898225a9f8ed6", SYMLINK+="asmdiskb", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c2963776a39f75310d2f2bd98287", SYMLINK+="asmdiskc", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c29dd4c14aa6a5e4f77f40427565", SYMLINK+="asmdiskd", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c292b56645878eb55e7811673ae2", SYMLINK+="asmdiske", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c29ec780367d4c1f845c880f7f0e", SYMLINK+="asmdiskf", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c297777b8958d4d4dd5cd7ddbc47", SYMLINK+="asmdiskg", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@db1 rules.d]#
(4 )確認下是哪塊磁盤未使用,查看磁盤ID ,與上面99-x-asmdisk_new.rules 內(nèi)容對比后發(fā)現(xiàn):
[root@db1 rules.d]# /lib/udev/scsi_id -g -u /dev/sdg --- 該塊磁盤是新盤,未使用
36000c293ef0d560ff854306446331b79
[root@db1 rules.d]# /lib/udev/scsi_id -g -u /dev/sdh
36000c297777b8958d4d4dd5cd7ddbc47
目標(biāo):/dev/sdg 到ASM 磁盤組2 即ARCH 當(dāng)中
(1 )首先修改文件99-x-asmdisk_new.rules ,修改完后如下內(nèi)容:
[root@db1 rules.d]# more 99-x-asmdisk_new.rules
KERNEL=="sd?", ENV{ID_SERIAL}=="36000c29c5362298e7a9898225a9f8ed6", SYMLINK+="asmdiskb", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c2963776a39f75310d2f2bd98287", SYMLINK+="asmdiskc", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c29dd4c14aa6a5e4f77f40427565", SYMLINK+="asmdiskd", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c292b56645878eb55e7811673ae2", SYMLINK+="asmdiske", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c29ec780367d4c1f845c880f7f0e", SYMLINK+="asmdiskf", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c297777b8958d4d4dd5cd7ddbc47", SYMLINK+="asmdiskg", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd?", ENV{ID_SERIAL}=="36000c293ef0d560ff854306446331b79", SYMLINK+="asmdiskh", OWNER="grid", GROUP="asmadmin", MODE="0660" ----增加新行
(2 )重新載入udev 文件內(nèi)容并啟動
[root@db1 rules.d]# udevadm control --reload-rules
[root@db1 rules.d]# start_udev
Starting udev: [ OK ]
啟動完之后可看到新加的磁盤 /dev/asmdiskh -> sdg
[root@db1 rules.d]# ls -l /dev/asm
total 0
[root@db1 rules.d]# ls -l /dev/asm*
lrwxrwxrwx 1 root root 3 May 19 15:13 /dev/asmdiskb -> sdf
lrwxrwxrwx 1 root root 3 May 19 15:13 /dev/asmdiskc -> sde
lrwxrwxrwx 1 root root 3 May 19 15:13 /dev/asmdiskd -> sdd
lrwxrwxrwx 1 root root 3 May 19 15:13 /dev/asmdiske -> sdb
lrwxrwxrwx 1 root root 3 May 19 15:13 /dev/asmdiskf -> sdc
lrwxrwxrwx 1 root root 3 May 19 15:13 /dev/asmdiskg -> sdh
lrwxrwxrwx 1 root root 3 May 19 15:13 /dev/asmdiskh -> sdg
(3 )另一個節(jié)點做同樣的處理
[root@db2 rules.d]# vi 99-x-asmdisk_new.rules
[root@db2 rules.d]# udevadm control --reload-rules
[root@db2 rules.d]# start udev
start: Unknown job: udev
[root@db2 rules.d]# start_udev
Starting udev: [ OK ]
[root@db2 rules.d]# ls -l /dev/asm*
lrwxrwxrwx 1 root root 3 May 19 15:17 /dev/asmdiskb -> sdf
lrwxrwxrwx 1 root root 3 May 19 15:17 /dev/asmdiskc -> sde
lrwxrwxrwx 1 root root 3 May 19 15:17 /dev/asmdiskd -> sdd
lrwxrwxrwx 1 root root 3 May 19 15:17 /dev/asmdiske -> sdb
lrwxrwxrwx 1 root root 3 May 19 15:17 /dev/asmdiskf -> sdc
lrwxrwxrwx 1 root root 3 May 19 15:17 /dev/asmdiskg -> sdh
lrwxrwxrwx 1 root root 3 May 19 15:17 /dev/asmdiskh -> sdg
/dev/asm:
total 0
(1 )使用GRID 用戶進入ASM 實例中,查詢ASM 磁盤已經(jīng)能看到該磁盤情況:
SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,STATE,TOTAL_MB,PATH,NAME from v$asm_disk order by GROUP_NUMBER,DISK_NUMBER; GROUP_NUMBER DISK_NUMBER MOUNT_S STATE TOTAL_MB PATH NAME ------------ ----------- ------- -------- ---------- -------------------- -------------------- 0 0 CLOSED NORMAL 0 /dev/asmdiskh 1 0 CACHED NORMAL 51200 /dev/asmdiske DATA_0000 1 1 CACHED NORMAL 51200 /dev/asmdiskf DATA_0001 2 0 CACHED NORMAL 20480 /dev/asmdiskg ARCH_0000 3 0 CACHED NORMAL 1024 /dev/asmdiskb OCR_0000 3 1 CACHED NORMAL 1024 /dev/asmdiskc OCR_0001 3 2 CACHED NORMAL 1024 /dev/asmdiskd OCR_0002 7 rows selected.
(2 )使用命令將磁盤加入到組ARCH 中。
使用 sqlplus ‘/as sysasm’ 登錄
SQL> alter diskgroup ARCH ADD DISK '/dev/asmdiskh';
查看磁盤組容量已經(jīng)增加
SQL> select NAME,FREE_MB,TOTAL_MB FROM V$ASM_DISKGROUP; NAME FREE_MB TOTAL_MB ------------------------------ ---------- ---------- DATA 99315 102400 ARCH 39294 40960 OCR 2787 3072
確認另一個節(jié)點情況:
SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,STATE,TOTAL_MB,PATH,NAME from v$asm_disk order by GROUP_NUMBER,DISK_NUMBER; GROUP_NUMBER DISK_NUMBER MOUNT_S STATE TOTAL_MB PATH NAME ------------ ----------- ------- -------- ---------- -------------------- -------------------- 1 0 CACHED NORMAL 51200 /dev/asmdiske DATA_0000 1 1 CACHED NORMAL 51200 /dev/asmdiskf DATA_0001 2 0 CACHED NORMAL 20480 /dev/asmdiskg ARCH_0000 2 1 CACHED NORMAL 20480 /dev/asmdiskh ARCH_0001 3 0 CACHED NORMAL 1024 /dev/asmdiskb OCR_0000 3 1 CACHED NORMAL 1024 /dev/asmdiskc OCR_0001 3 2 CACHED NORMAL 1024 /dev/asmdiskd OCR_0002 7 rows selected.
至此,磁盤ASM 擴展完畢。
分享名稱:使用udev擴展ASM磁盤組
標(biāo)題來源:http://muchs.cn/article32/ghjdsc.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供自適應(yīng)網(wǎng)站、云服務(wù)器、外貿(mào)建站、網(wǎng)站營銷、營銷型網(wǎng)站建設(shè)、電子商務(wù)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)