Solaris 11.3环境下12.2c RAC环境添加asm磁盘
--节点1
-bash-4.4# format
AVAILABLE DISK SELECTIONS:
0. c0t6A4C64F1001DB6537ABB17F600000058d0 <HUAWEI-XSG1-4303-200.00GB> boot /scsi_vhci/ssd@g6a4c64f1001db6537abb17f600000058 --系统盘
1. c0t6A4C64F1001DB6537ACFAFB60000004Fd0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db6537acfafb60000004f
2. c0t6A4C64F1001DB6537ACFB02A00000056d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db6537acfb02a00000056
3. c0t6A4C64F1001DB6537ACFB09800000057d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db6537acfb09800000057
4. c0t6A4C64F1001DB65367B0FDAD00000050d0 <HUAWEI-XSG1-4303 cyl 7550 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65367b0fdad00000050
5. c0t6A4C64F1001DB65367B0FE8A00000052d0 <HUAWEI-XSG1-4303 cyl 7550 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65367b0fe8a00000052
6. c0t6A4C64F1001DB65367B0FE2100000051d0 <HUAWEI-XSG1-4303 cyl 7550 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65367b0fe2100000051
7. c0t6A4C64F1001DB65379F2920E00000054d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65379f2920e00000054
8. c0t6A4C64F1001DB65379F2929100000055d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65379f2929100000055
9. c0t6A4C64F1001DB65379F2919500000053d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65379f2919500000053
10. c0t6CCD73C10030689C6D47E40700000007d0 <HUAWEI-XSG1-6000 cyl 17050 alt 2 hd 224 sec 56> /scsi_vhci/ssd@g6ccd73c10030689c6d47e40700000007 --新分磁盘
11. c1d0 <Unknown-Unknown-0001-49.00GB> /virtual-devices@100/channel-devices@200/disk@0
--节点2
-bash-4.4# format
AVAILABLE DISK SELECTIONS:
0. c0t6A4C64F1001DB6537AC6A7A80000004Cd0 <HUAWEI-XSG1-4303-200.00GB> boot /scsi_vhci/ssd@g6a4c64f1001db6537ac6a7a80000004c --系统盘
1. c0t6A4C64F1001DB6537ACFAFB60000004Fd0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db6537acfafb60000004f
2. c0t6A4C64F1001DB6537ACFB02A00000056d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db6537acfb02a00000056
3. c0t6A4C64F1001DB6537ACFB09800000057d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db6537acfb09800000057
4. c0t6A4C64F1001DB65367B0FDAD00000050d0 <HUAWEI-XSG1-4303 cyl 7550 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65367b0fdad00000050
5. c0t6A4C64F1001DB65367B0FE8A00000052d0 <HUAWEI-XSG1-4303 cyl 7550 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65367b0fe8a00000052
6. c0t6A4C64F1001DB65367B0FE2100000051d0 <HUAWEI-XSG1-4303 cyl 7550 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65367b0fe2100000051
7. c0t6A4C64F1001DB65379F2920E00000054d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65379f2920e00000054
8. c0t6A4C64F1001DB65379F2929100000055d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65379f2929100000055
9. c0t6A4C64F1001DB65379F2919500000053d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256> /scsi_vhci/ssd@g6a4c64f1001db65379f2919500000053
10. c0t6CCD73C10030689C6D47E40700000007d0 <HUAWEI-XSG1-6000 cyl 17050 alt 2 hd 224 sec 56> /scsi_vhci/ssd@g6ccd73c10030689c6d47e40700000007 --新分磁盘
11. c1d0 <Unknown-Unknown-0001-49.00GB> /virtual-devices@100/channel-devices@200/disk@0
select group_number g_id,disk_number d_id,state,name,path,os_mb/1024 os_gb,total_mb/1024 total_gb,free_mb/1024 free_gb from v$asm_disk order by 1,2;
select name,total_mb/1024,free_mb/1024 from v$asm_diskgroup;
--node1
GROUP_NUMBER DISK_NUMBER STATE NAME PATH OS_MB TOTAL_MB FREE_MB
------------ ----------- -------- ------------ -------------------------------------------------- ---------- ---------- ----------
0 0 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFB02A00000056d0s6 104176 0 0
0 1 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2919500000053d0s6 104176 0 0
0 2 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2929100000055d0s6 104176 0 0
0 3 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FDAD00000050d0s6 60144 0 0
0 4 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FE8A00000052d0s6 60144 0 0
0 5 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFB09800000057d0s6 104176 0 0
0 6 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2920E00000054d0s6 104176 0 0
0 7 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FE2100000051d0s6 60144 0 0
0 8 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFAFB60000004Fd0s6 104176 0 0
1 0 NORMAL DATA1 AFD:DATA1 104176 104176 14164
1 1 NORMAL DATA2 AFD:DATA2 104176 104176 14176
1 2 NORMAL DATA3 AFD:DATA3 104176 104176 14168
2 0 NORMAL FRA1 AFD:FRA1 60144 60144 38768
2 1 NORMAL FRA2 AFD:FRA2 60144 60144 38868
3 0 NORMAL MGMT1 AFD:MGMT1 104176 104176 86048
3 1 NORMAL MGMT2 AFD:MGMT2 104176 104176 86036
3 2 NORMAL MGMT3 AFD:MGMT3 104176 104176 86052
4 0 NORMAL OCR_VOTE1 AFD:OCR_VOTE1 60144 60144 59804
18 rows selected.
GROUP_NUMBER DISK_NUMBER STATE NAME PATH OS_MB TOTAL_MB FREE_MB
------------ ----------- -------- ------------ -------------------------------------------------- ---------- ---------- ----------
0 0 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFB02A00000056d0s6 104176 0 0
0 1 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2919500000053d0s6 104176 0 0
0 2 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2929100000055d0s6 104176 0 0
0 3 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FDAD00000050d0s6 60144 0 0
0 4 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FE8A00000052d0s6 60144 0 0
0 5 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFB09800000057d0s6 104176 0 0
0 6 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2920E00000054d0s6 104176 0 0
0 7 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FE2100000051d0s6 60144 0 0
0 8 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFAFB60000004Fd0s6 104176 0 0
1 0 NORMAL DATA1 AFD:DATA1 104176 104176 14164
1 1 NORMAL DATA2 AFD:DATA2 104176 104176 14176
1 2 NORMAL DATA3 AFD:DATA3 104176 104176 14168
2 0 NORMAL FRA1 AFD:FRA1 60144 60144 38768
2 1 NORMAL FRA2 AFD:FRA2 60144 60144 38868
3 0 NORMAL MGMT1 AFD:MGMT1 104176 104176 86048
3 1 NORMAL MGMT2 AFD:MGMT2 104176 104176 86036
3 2 NORMAL MGMT3 AFD:MGMT3 104176 104176 86052
4 0 NORMAL OCR_VOTE1 AFD:OCR_VOTE1 60144 60144 59804
18 rows selected.
######################################################################################################################################
-bash-4.4# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
0. c0t6A4C64F1001DB6537ABB17F600000058d0 <HUAWEI-XSG1-4303-200.00GB> boot
/scsi_vhci/ssd@g6a4c64f1001db6537abb17f600000058
1. c0t6A4C64F1001DB6537ACFAFB60000004Fd0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g6a4c64f1001db6537acfafb60000004f
2. c0t6A4C64F1001DB6537ACFB02A00000056d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g6a4c64f1001db6537acfb02a00000056
3. c0t6A4C64F1001DB6537ACFB09800000057d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g6a4c64f1001db6537acfb09800000057
4. c0t6A4C64F1001DB65367B0FDAD00000050d0 <HUAWEI-XSG1-4303 cyl 7550 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g6a4c64f1001db65367b0fdad00000050
5. c0t6A4C64F1001DB65367B0FE8A00000052d0 <HUAWEI-XSG1-4303 cyl 7550 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g6a4c64f1001db65367b0fe8a00000052
6. c0t6A4C64F1001DB65367B0FE2100000051d0 <HUAWEI-XSG1-4303 cyl 7550 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g6a4c64f1001db65367b0fe2100000051
7. c0t6A4C64F1001DB65379F2920E00000054d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g6a4c64f1001db65379f2920e00000054
8. c0t6A4C64F1001DB65379F2929100000055d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g6a4c64f1001db65379f2929100000055
9. c0t6A4C64F1001DB65379F2919500000053d0 <HUAWEI-XSG1-4303 cyl 13054 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g6a4c64f1001db65379f2919500000053
10. c0t6CCD73C10030689C6D47E40700000007d0 <HUAWEI-XSG1-6000 cyl 17050 alt 2 hd 224 sec 56>
/scsi_vhci/ssd@g6ccd73c10030689c6d47e40700000007
11. c1d0 <Unknown-Unknown-0001-49.00GB>
/virtual-devices@100/channel-devices@200/disk@0
Specify disk (enter its number): 10
selecting c0t6CCD73C10030689C6D47E40700000007d0
[disk formatted]
FORMAT MENU:
disk - select a disk
type - select (define) a disk type
partition - select (define) a partition table
current - describe the current disk
format - format and analyze the disk
repair - repair a defective sector
label - write label to the disk
analyze - surface analysis
defect - defect list management
backup - search for backup labels
verify - read and display labels
save - save new disk/partition definitions
inquiry - show disk ID
volname - set 8-character volume name
!<cmd> - execute <cmd>, then return
quit
format> ver
Primary label contents:
Volume name = < >
ascii name = <HUAWEI-XSG1-6000 cyl 17050 alt 2 hd 224 sec 56>
pcyl = 17052
ncyl = 17050
acyl = 2
nhead = 224
nsect = 56
Part Tag Flag Cylinders Size Blocks
0 root wm 0 - 20 128.62MB (21/0/0) 263424
1 swap wu 21 - 41 128.62MB (21/0/0) 263424
2 backup wu 0 - 17049 101.98GB (17050/0/0) 213875200
3 unassigned wm 0 0 (0/0/0) 0
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 0 0 (0/0/0) 0
6 usr wm 42 - 17049 101.73GB (17008/0/0) 213348352
7 unassigned wm 0 0 (0/0/0) 0
format> q
--节点1
-bash-4.4# pwd
/devices/scsi_vhci
-bash-4.4#
-bash-4.4# ls -lrth |grep g,raw
crw-rw---- 1 grid asmadmin 246, 190 Jul 5 2018 ssd@g6a4c64f1001db65367b0fdad00000050:g,raw
crw-rw---- 1 grid asmadmin 246, 6 Jul 5 2018 ssd@g6a4c64f1001db65367b0fe8a00000052:g,raw
crw-rw---- 1 grid asmadmin 246, 70 Jul 5 2018 ssd@g6a4c64f1001db65367b0fe2100000051:g,raw
crw-rw---- 1 grid asmadmin 246, 22 Jul 10 2018 ssd@g6a4c64f1001db6537acfb09800000057:g,raw
crw-rw---- 1 grid asmadmin 246, 30 Jul 10 2018 ssd@g6a4c64f1001db6537acfb02a00000056:g,raw
crw-rw---- 1 grid asmadmin 246, 62 Jul 10 2018 ssd@g6a4c64f1001db6537acfafb60000004f:g,raw
crw-rw---- 1 grid asmadmin 246, 38 Jul 10 2018 ssd@g6a4c64f1001db65379f2929100000055:g,raw
crw-rw---- 1 grid asmadmin 246, 46 Jul 10 2018 ssd@g6a4c64f1001db65379f2920e00000054:g,raw
crw-rw---- 1 grid asmadmin 246, 54 Jul 10 2018 ssd@g6a4c64f1001db65379f2919500000053:g,raw
crw-r----- 1 root sys 246, 14 Mar 4 18:26 ssd@g6a4c64f1001db6537abb17f600000058:g,raw --操作系统盘分区
crw-r----- 1 root sys 246, 78 Mar 7 16:03 ssd@g6ccd73c10030689c6d47e40700000007:g,raw
chown grid:asmadmin /devices/scsi_vhci/ssd@g6ccd73c10030689c6d47e40700000007:g,raw
chmod 0660 /devices/scsi_vhci/ssd@g6ccd73c10030689c6d47e40700000007:g,raw
-bash-4.4# ls -lrth |grep g,raw
crw-rw---- 1 grid asmadmin 246, 190 Jul 5 2018 ssd@g6a4c64f1001db65367b0fdad00000050:g,raw
crw-rw---- 1 grid asmadmin 246, 6 Jul 5 2018 ssd@g6a4c64f1001db65367b0fe8a00000052:g,raw
crw-rw---- 1 grid asmadmin 246, 70 Jul 5 2018 ssd@g6a4c64f1001db65367b0fe2100000051:g,raw
crw-rw---- 1 grid asmadmin 246, 22 Jul 10 2018 ssd@g6a4c64f1001db6537acfb09800000057:g,raw
crw-rw---- 1 grid asmadmin 246, 30 Jul 10 2018 ssd@g6a4c64f1001db6537acfb02a00000056:g,raw
crw-rw---- 1 grid asmadmin 246, 62 Jul 10 2018 ssd@g6a4c64f1001db6537acfafb60000004f:g,raw
crw-rw---- 1 grid asmadmin 246, 38 Jul 10 2018 ssd@g6a4c64f1001db65379f2929100000055:g,raw
crw-rw---- 1 grid asmadmin 246, 46 Jul 10 2018 ssd@g6a4c64f1001db65379f2920e00000054:g,raw
crw-rw---- 1 grid asmadmin 246, 54 Jul 10 2018 ssd@g6a4c64f1001db65379f2919500000053:g,raw
crw-r----- 1 root sys 246, 14 Mar 4 18:26 ssd@g6a4c64f1001db6537abb17f600000058:g,raw
crw-rw---- 1 grid asmadmin 246, 78 Apr 6 14:19 ssd@g6ccd73c10030689c6d47e40700000007:g,raw
--节点2
-bash-4.4# cd /devices/scsi_vhci
-bash-4.4# ls -lrth |grep g,raw
crw-rw---- 1 grid asmadmin 246, 278 Jul 10 2018 ssd@g6a4c64f1001db6537acfafb60000004f:g,raw
crw-rw---- 1 grid asmadmin 246, 246 Jul 10 2018 ssd@g6a4c64f1001db6537acfb09800000057:g,raw
crw-rw---- 1 grid asmadmin 246, 286 Jul 10 2018 ssd@g6a4c64f1001db6537acfb02a00000056:g,raw
crw-rw---- 1 grid asmadmin 246, 254 Jul 10 2018 ssd@g6a4c64f1001db65379f2929100000055:g,raw
crw-rw---- 1 grid asmadmin 246, 262 Jul 10 2018 ssd@g6a4c64f1001db65379f2920e00000054:g,raw
crw-rw---- 1 grid asmadmin 246, 270 Jul 10 2018 ssd@g6a4c64f1001db65379f2919500000053:g,raw
crw-rw---- 1 grid asmadmin 246, 6 Jul 10 2018 ssd@g6a4c64f1001db65367b0fe8a00000052:g,raw
crw-rw---- 1 grid asmadmin 246, 14 Jul 10 2018 ssd@g6a4c64f1001db65367b0fe2100000051:g,raw
crw-rw---- 1 grid asmadmin 246, 190 Jul 10 2018 ssd@g6a4c64f1001db65367b0fdad00000050:g,raw
crw-r----- 1 root sys 246, 22 Mar 7 16:13 ssd@g6ccd73c10030689c6d47e40700000007:g,raw
crw-r----- 1 root sys 246, 238 Mar 7 16:13 ssd@g6a4c64f1001db6537ac6a7a80000004c:g,raw --操作系统盘分区
chown grid:asmadmin /devices/scsi_vhci/ssd@g6ccd73c10030689c6d47e40700000007:g,raw
chmod 0660 /devices/scsi_vhci/ssd@g6ccd73c10030689c6d47e40700000007:g,raw
-bash-4.4# ls -lrth |grep g,raw
crw-rw---- 1 grid asmadmin 246, 278 Jul 10 2018 ssd@g6a4c64f1001db6537acfafb60000004f:g,raw
crw-rw---- 1 grid asmadmin 246, 246 Jul 10 2018 ssd@g6a4c64f1001db6537acfb09800000057:g,raw
crw-rw---- 1 grid asmadmin 246, 286 Jul 10 2018 ssd@g6a4c64f1001db6537acfb02a00000056:g,raw
crw-rw---- 1 grid asmadmin 246, 254 Jul 10 2018 ssd@g6a4c64f1001db65379f2929100000055:g,raw
crw-rw---- 1 grid asmadmin 246, 262 Jul 10 2018 ssd@g6a4c64f1001db65379f2920e00000054:g,raw
crw-rw---- 1 grid asmadmin 246, 270 Jul 10 2018 ssd@g6a4c64f1001db65379f2919500000053:g,raw
crw-rw---- 1 grid asmadmin 246, 6 Jul 10 2018 ssd@g6a4c64f1001db65367b0fe8a00000052:g,raw
crw-rw---- 1 grid asmadmin 246, 14 Jul 10 2018 ssd@g6a4c64f1001db65367b0fe2100000051:g,raw
crw-rw---- 1 grid asmadmin 246, 190 Jul 10 2018 ssd@g6a4c64f1001db65367b0fdad00000050:g,raw
crw-r----- 1 root sys 246, 238 Mar 7 16:13 ssd@g6a4c64f1001db6537ac6a7a80000004c:g,raw
crw-rw---- 1 grid asmadmin 246, 22 Apr 6 14:21 ssd@g6ccd73c10030689c6d47e40700000007:g,raw
--ASM磁盘组添加磁盘
查看磁盘状态
sqlplus / as sysasm;
set line 200
col path for a50
select name,path,state,mount_status,header_status from v$asm_disk;
https://blog.csdn.net/qq_40687433/article/details/80624992
清理磁盘
dd if=/dev/zero of=/dev/rhdiskpower84 bs=1k count=1
添加磁盘
sqlplus / as sysasm
alter diskgroup DATA add disk '/dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6' rebalance power 4;
因为磁盘要做rebalance，最好在rebalance完后再使用磁盘组
select name,path,state,mount_status,header_status from v$asm_disk;
select * from v$asm_operation;
原文链接：https://blog.csdn.net/qq_40687433/article/details/80624992
ASMFD (ASM Filter Driver) Support on OS Platforms (Certification Matrix). (Doc ID 2034681.1)
--AFD讲解：
http://atoracle.cn/index.php?m=Article&a=show&id=81
###################################################################################################################
-bash-4.4# su - grid
Oracle Corporation SunOS 5.11 11.3 March 2018
-bash-4.4$ sqlplus / as sysasm;
SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 6 14:34:18 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /oracle/12.2.0/grid/rdbms/log
core_dump_dest string /oracle/grid/diag/asm/+asm/+ASM1/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /oracle/12.2.0/grid/rdbms/log
--未使用AFD特性后，添加存储：
SQL> alter diskgroup DATA add disk '/dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6' rebalance power 4;
Diskgroup altered.
alter diskgroup DATA drop disk DATA_0003 rebalance power 10;
--Oracle ASM Rebalance执行过程
http://blog.itpub.net/26015009/viewspace-2132215/
--对应日志输出：
-bash-4.4$ cd /oracle/grid/diag/asm/+asm/+ASM1/trace/
-bash-4.4$ pwd
/oracle/grid/diag/asm/+asm/+ASM1/trace
2022-04-06T14:39:30.344814+08:00
SQL> alter diskgroup DATA add disk '/dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6' rebalance power 4
2022-04-06T14:39:30.347491+08:00
NOTE: GroupBlock outside rolling migration privileged region
2022-04-06T14:39:30.350090+08:00
NOTE: client +ASM1:+ASM:rac-uat no longer has group 3 (MGMT) mounted
NOTE: client +ASM1:+ASM:rac-uat no longer has group 1 (DATA) mounted
2022-04-06T14:39:34.862015+08:00
NOTE: Assigning number (1,3) to disk (/dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6)
NOTE: requesting all-instance membership refresh for group=1
2022-04-06T14:39:37.213529+08:00
NOTE: Disk 3 in group 1 is assigned fgnum=4
NOTE: discarding redo for group 1 disk 3
2022-04-06T14:39:42.392590+08:00
NOTE: initializing header (replicated) on grp 1 disk DATA_0003
NOTE: initializing header on grp 1 disk DATA_0003
NOTE: requesting all-instance disk validation for group=1
2022-04-06T14:39:42.703091+08:00
NOTE: skipping rediscovery for group 1/0x94139783 (DATA) on local instance.
2022-04-06T14:39:42.873017+08:00
NOTE: running client discovery for group 1 (reqid:10670038531067422464)
2022-04-06T14:39:42.901942+08:00
NOTE: initiating client [fcdbuat1:fcdbuat:rac-uat] discovery for group 1 (reqid:10670038531067422464)
2022-04-06T14:39:47.423600+08:00
NOTE: client [fcdbuat1:fcdbuat:rac-uat] completed disk validation (reqid:10670038531067422464 KFNPDRFLG=1)
2022-04-06T14:39:48.121688+08:00
NOTE: requesting all-instance disk validation for group=1
2022-04-06T14:39:48.122109+08:00
NOTE: skipping rediscovery for group 1/0x94139783 (DATA) on local instance.
2022-04-06T14:39:48.291729+08:00
NOTE: running client discovery for group 1 (reqid:10670038531067420270)
2022-04-06T14:39:48.315219+08:00
NOTE: initiating client [fcdbuat1:fcdbuat:rac-uat] discovery for group 1 (reqid:10670038531067420270)
2022-04-06T14:39:52.832820+08:00
NOTE: client [fcdbuat1:fcdbuat:rac-uat] completed disk validation (reqid:10670038531067420270 KFNPDRFLG=1)
2022-04-06T14:39:53.341187+08:00
GMON updating for reconfiguration, group 1 at 3909 for pid 37, osid 27970
2022-04-06T14:39:53.348275+08:00
NOTE: group 1 PST updated.
2022-04-06T14:39:53.354188+08:00
NOTE: membership refresh pending for group 1/0x94139783 (DATA)
2022-04-06T14:39:53.356443+08:00
GMON querying group 1 at 3910 for pid 25, osid 3205
2022-04-06T14:39:53.384442+08:00
NOTE: client fcdbuat1:fcdbuat:rac-uat mounted group 1 (DATA)
NOTE: cache opening disk 3 of grp 1: DATA_0003 path:/dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6
2022-04-06T14:39:53.481969+08:00
GMON querying group 1 at 3911 for pid 25, osid 3205
2022-04-06T14:39:53.495185+08:00
SUCCESS: refreshed membership for 1/0x94139783 (DATA)
2022-04-06T14:39:54.518182+08:00
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA. No voting file found.
2022-04-06T14:39:55.842797+08:00
SUCCESS: alter diskgroup DATA add disk '/dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6' rebalance power 4
2022-04-06T14:39:57.626166+08:00
NOTE: starting rebalance of group 1/0x94139783 (DATA) at power 4
NOTE: starting process ARBA
Starting background process ARBA
2022-04-06T14:39:57.685757+08:00
ARBA started with pid=49, OS id=29000
NOTE: starting process ARB0
Starting background process ARB0
2022-04-06T14:39:57.736551+08:00
ARB0 started with pid=51, OS id=29001
NOTE: assigning ARBA to group 1/0x94139783 (DATA) to compute estimates
NOTE: assigning ARB0 to group 1/0x94139783 (DATA) with 4 parallel I/Os
2022-04-06T14:39:58.135213+08:00
NOTE: header on disk 0 advanced to format #2 using fcn 0.0
2022-04-06T15:36:39.595471+08:00
NOTE: Starting expel slave for group 1/0x94139783 (DATA)
2022-04-06T15:36:39.602708+08:00
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=1
2022-04-06T15:36:39.614779+08:00
NOTE: membership refresh pending for group 1/0x94139783 (DATA)
2022-04-06T15:36:39.737063+08:00
GMON querying group 1 at 3912 for pid 25, osid 3205
2022-04-06T15:36:39.739980+08:00
SUCCESS: refreshed membership for 1/0x94139783 (DATA)
2022-04-06T19:21:30.377927+08:00
SQL> alter diskgroup DATA drop disk DATA_0003 rebalance power 4
2022-04-06T19:21:30.379090+08:00
NOTE: GroupBlock outside rolling migration privileged region
2022-04-06T19:21:30.381359+08:00
NOTE: client +ASM1:+ASM:rac-uat no longer has group 3 (MGMT) mounted
2022-04-06T19:21:30.388550+08:00
NOTE: requesting all-instance membership refresh for group=1
2022-04-06T19:21:30.396551+08:00
NOTE: membership refresh pending for group 1/0x94139783 (DATA)
2022-04-06T19:21:30.491987+08:00
GMON querying group 1 at 3945 for pid 25, osid 3205
2022-04-06T19:21:30.494938+08:00
SUCCESS: refreshed membership for 1/0x94139783 (DATA)
2022-04-06T19:21:30.495653+08:00
SUCCESS: alter diskgroup DATA drop disk DATA_0003 rebalance power 4
2022-04-06T19:21:30.498373+08:00
NOTE: starting rebalance of group 1/0x94139783 (DATA) at power 4
NOTE: starting process ARBA
Starting background process ARBA
2022-04-06T19:21:30.559996+08:00
ARBA started with pid=37, OS id=23057
NOTE: starting process ARB0
Starting background process ARB0
2022-04-06T19:21:30.623366+08:00
ARB0 started with pid=49, OS id=23058
NOTE: assigning ARBA to group 1/0x94139783 (DATA) to compute estimates
NOTE: assigning ARB0 to group 1/0x94139783 (DATA) with 4 parallel I/Os
2022-04-06T19:21:33.127765+08:00
NOTE: Attempting voting file refresh on diskgroup DATA
2022-04-06T19:21:48.723712+08:00
NOTE: Refresh completed on diskgroup DATA. No voting file found.
-bash-4.4$ pwd
/oracle/grid/diag/asm/+asm/+ASM1/trace
-bash-4.4$ cd
-bash-4.4$ adrci
ADRCI: Release 12.2.0.1.0 - Production on Wed Apr 6 14:36:19 2022
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
ADR base = "/oracle/grid"
adrci> show homes
ADR Homes:
diag/apx/+apx/+APX1
diag/asmtool/user_root/host_2980307194_107
diag/asmtool/user_grid/host_2980307194_107
diag/tnslsnr/szdrxd35cbdb/asmnet1lsnr_asm
diag/tnslsnr/szdrxd35cbdb/listener_scan1
diag/tnslsnr/szdrxd35cbdb/mgmtlsnr
diag/tnslsnr/szdrxd35cbdb/listener
diag/asm/user_grid/host_2980307194_107
diag/asm/+asm/+ASM1
diag/asm/user_root/host_2980307194_107
diag/crs/szdrxd35cbdb/crs
diag/clients/user_root/host_2980307194_107
diag/clients/user_oracle/host_2980307194_107
diag/clients/user_grid/host_2980307194_107
diag/afdboot/user_root/host_2980307194_107
diag/ios/+ios/+IOS1
diag/rdbms/_mgmtdb/-MGMTDB
https://blog.csdn.net/mutisme/article/details/100191422?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7ERate-1.pc_relevant_paycolumn_v3&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7ERate-1.pc_relevant_paycolumn_v3&utm_relevant_index=2
[orgrid@db1 bin]$ $ORACLE_HOME/bin/asmcmd afd_label DATA4 /dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6
Connected to an idle instance.
[orgrid@db1 bin]$ $ORACLE_HOME/bin/asmcmd afd_lsdsk
-bash-4.4# su - grid
Oracle Corporation SunOS 5.11 11.3 March 2018
-bash-4.4$ $ORACLE_HOME/bin/asmcmd afd_lsdsk
--------------------------------------------------------------------------------
Label Filtering Path
================================================================================
DATA1 ENABLED /dev/rdsk/c0t6A4C64F1001DB6537ACFB02A00000056d0s6
DATA2 ENABLED /dev/rdsk/c0t6A4C64F1001DB6537ACFAFB60000004Fd0s6
DATA3 ENABLED /dev/rdsk/c0t6A4C64F1001DB6537ACFB09800000057d0s6
FRA1 ENABLED /dev/rdsk/c0t6A4C64F1001DB65367B0FE2100000051d0s6
FRA2 ENABLED /dev/rdsk/c0t6A4C64F1001DB65367B0FE8A00000052d0s6
MGMT1 ENABLED /dev/rdsk/c0t6A4C64F1001DB65379F2929100000055d0s6
MGMT2 ENABLED /dev/rdsk/c0t6A4C64F1001DB65379F2919500000053d0s6
MGMT3 ENABLED /dev/rdsk/c0t6A4C64F1001DB65379F2920E00000054d0s6
OCR_VOTE1 ENABLED /dev/rdsk/c0t6A4C64F1001DB65367B0FDAD00000050d0s6
-bash-4.4$ $ORACLE_HOME/bin/asmcmd afd_lsdsk
--------------------------------------------------------------------------------
Label Filtering Path
================================================================================
DATA1 ENABLED /dev/rdsk/c0t6A4C64F1001DB6537ACFB02A00000056d0s6
DATA2 ENABLED /dev/rdsk/c0t6A4C64F1001DB6537ACFAFB60000004Fd0s6
DATA3 ENABLED /dev/rdsk/c0t6A4C64F1001DB6537ACFB09800000057d0s6
FRA1 ENABLED /dev/rdsk/c0t6A4C64F1001DB65367B0FE2100000051d0s6
FRA2 ENABLED /dev/rdsk/c0t6A4C64F1001DB65367B0FE8A00000052d0s6
MGMT1 ENABLED /dev/rdsk/c0t6A4C64F1001DB65379F2929100000055d0s6
MGMT2 ENABLED /dev/rdsk/c0t6A4C64F1001DB65379F2919500000053d0s6
MGMT3 ENABLED /dev/rdsk/c0t6A4C64F1001DB65379F2920E00000054d0s6
OCR_VOTE1 ENABLED /dev/rdsk/c0t6A4C64F1001DB65367B0FDAD00000050d0s6
-bash-4.4$ $ORACLE_HOME/bin/asmcmd afd_label DATA4 /dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6
-bash-4.4$ $ORACLE_HOME/bin/asmcmd afd_refresh
-bash-4.4$ $ORACLE_HOME/bin/asmcmd afd_lsdsk
--------------------------------------------------------------------------------
Label Filtering Path
================================================================================
DATA1 ENABLED /dev/rdsk/c0t6A4C64F1001DB6537ACFB02A00000056d0s6
DATA2 ENABLED /dev/rdsk/c0t6A4C64F1001DB6537ACFAFB60000004Fd0s6
DATA3 ENABLED /dev/rdsk/c0t6A4C64F1001DB6537ACFB09800000057d0s6
DATA4 ENABLED /dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6
FRA1 ENABLED /dev/rdsk/c0t6A4C64F1001DB65367B0FE2100000051d0s6
FRA2 ENABLED /dev/rdsk/c0t6A4C64F1001DB65367B0FE8A00000052d0s6
MGMT1 ENABLED /dev/rdsk/c0t6A4C64F1001DB65379F2929100000055d0s6
MGMT2 ENABLED /dev/rdsk/c0t6A4C64F1001DB65379F2919500000053d0s6
MGMT3 ENABLED /dev/rdsk/c0t6A4C64F1001DB65379F2920E00000054d0s6
OCR_VOTE1 ENABLED /dev/rdsk/c0t6A4C64F1001DB65367B0FDAD00000050d0s6
--添加AFD磁盘前：
set linesize 180 pagesize 1000
col name for a12
col path for a60
select group_number g_id,disk_number d_id,state,name,path,os_mb/1024 os_gb,total_mb/1024 total_gb,free_mb/1024 free_gb from v$asm_disk order by 1,2;
G_ID D_ID STATE NAME PATH OS_GB TOTAL_GB FREE_GB
---------- ---------- -------- --------------- ------------------------------------------------------------ ---------- ---------- ----------
0 0 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFB02A00000056d0s6 101.734375 0 0
0 1 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2919500000053d0s6 101.734375 0 0
0 2 NORMAL /dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6 101.732422 0 0
0 3 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2929100000055d0s6 101.734375 0 0
0 4 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FDAD00000050d0s6 58.734375 0 0
0 5 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FE8A00000052d0s6 58.734375 0 0
0 6 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFB09800000057d0s6 101.734375 0 0
0 7 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2920E00000054d0s6 101.734375 0 0
0 8 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FE2100000051d0s6 58.734375 0 0
0 9 NORMAL AFD:DATA4 101.732422 0 0
0 10 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFAFB60000004Fd0s6 101.734375 0 0
1 0 NORMAL DATA1 AFD:DATA1 101.734375 101.734375 13.8398438
1 1 NORMAL DATA2 AFD:DATA2 101.734375 101.734375 13.8320313
1 2 NORMAL DATA3 AFD:DATA3 101.734375 101.734375 13.8398438
2 0 NORMAL FRA1 AFD:FRA1 58.734375 58.734375 37.859375
2 1 NORMAL FRA2 AFD:FRA2 58.734375 58.734375 37.9570313
3 0 NORMAL MGMT1 AFD:MGMT1 101.734375 101.734375 84.0273438
3 1 NORMAL MGMT2 AFD:MGMT2 101.734375 101.734375 84.0234375
3 2 NORMAL MGMT3 AFD:MGMT3 101.734375 101.734375 84.0351563
4 0 NORMAL OCR_VOTE1 AFD:OCR_VOTE1 58.734375 58.734375 58.4023438
20 rows selected.
alter diskgroup DATA add disk 'AFD:DATA4' rebalance power 10;
SQL> !id
uid=1100(grid) gid=1000(oinstall)
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
-bash-4.4$ sqlplus / as sysasm;
SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 6 20:36:05 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show parameter asm_diskstring
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string /dev/rdsk/*, AFD:*
SQL> alter diskgroup DATA add disk 'AFD:DATA4' rebalance power 10;
Diskgroup altered.
SQL> list
1* select group_number g_id,disk_number d_id,state,name,path,os_mb/1024 os_gb,total_mb/1024 total_gb,free_mb/1024 free_gb from v$asm_disk order by 1,2
SQL> /
G_ID D_ID STATE NAME PATH OS_GB TOTAL_GB FREE_GB
---------- ---------- -------- --------------- ------------------------------------------------------------ ---------- ---------- ----------
0 0 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFB02A00000056d0s6 101.734375 0 0
0 1 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2919500000053d0s6 101.734375 0 0
0 2 NORMAL /dev/rdsk/c0t6CCD73C10030689C6D47E40700000007d0s6 101.732422 0 0
0 3 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2929100000055d0s6 101.734375 0 0
0 4 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FDAD00000050d0s6 58.734375 0 0
0 5 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FE8A00000052d0s6 58.734375 0 0
0 6 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFB09800000057d0s6 101.734375 0 0
0 7 NORMAL /dev/rdsk/c0t6A4C64F1001DB65379F2920E00000054d0s6 101.734375 0 0
0 8 NORMAL /dev/rdsk/c0t6A4C64F1001DB65367B0FE2100000051d0s6 58.734375 0 0
0 9 NORMAL /dev/rdsk/c0t6A4C64F1001DB6537ACFAFB60000004Fd0s6 101.734375 0 0
1 0 NORMAL DATA1 AFD:DATA1 101.734375 101.734375 13.8476563
1 1 NORMAL DATA2 AFD:DATA2 101.734375 101.734375 13.8359375
1 2 NORMAL DATA3 AFD:DATA3 101.734375 101.734375 13.8398438
1 3 NORMAL DATA4 AFD:DATA4 101.732422 101.730469 101.707031
2 0 NORMAL FRA1 AFD:FRA1 58.734375 58.734375 37.859375
2 1 NORMAL FRA2 AFD:FRA2 58.734375 58.734375 37.9570313
3 0 NORMAL MGMT1 AFD:MGMT1 101.734375 101.734375 84.0273438
3 1 NORMAL MGMT2 AFD:MGMT2 101.734375 101.734375 84.0234375
3 2 NORMAL MGMT3 AFD:MGMT3 101.734375 101.734375 84.0351563
4 0 NORMAL OCR_VOTE1 AFD:OCR_VOTE1 58.734375 58.734375 58.4023438
20 rows selected.
2022-04-06T20:36:22.631074+08:00
SQL> alter diskgroup DATA add disk 'AFD:DATA4' rebalance power 10
2022-04-06T20:36:22.639397+08:00
NOTE: GroupBlock outside rolling migration privileged region
2022-04-06T20:36:24.950810+08:00
NOTE: Assigning number (1,3) to disk (AFD:DATA4)
NOTE: requesting all-instance membership refresh for group=1
2022-04-06T20:36:26.715191+08:00
NOTE: Disk 3 in group 1 is assigned fgnum=4
NOTE: discarding redo for group 1 disk 3
2022-04-06T20:36:32.291635+08:00
NOTE: initializing header (replicated) on grp 1 disk DATA4
NOTE: initializing header on grp 1 disk DATA4
NOTE: requesting all-instance disk validation for group=1
2022-04-06T20:36:32.603024+08:00
NOTE: skipping rediscovery for group 1/0x94139783 (DATA) on local instance.
2022-04-06T20:36:32.789806+08:00
NOTE: running client discovery for group 1 (reqid:10670038531067428943)
2022-04-06T20:36:32.820000+08:00
NOTE: initiating client [fcdbuat1:fcdbuat:rac-uat] discovery for group 1 (reqid:10670038531067428943)
2022-04-06T20:36:37.334413+08:00
NOTE: client [fcdbuat1:fcdbuat:rac-uat] completed disk validation (reqid:10670038531067428943 KFNPDRFLG=1)
2022-04-06T20:36:38.032066+08:00
NOTE: requesting all-instance disk validation for group=1
2022-04-06T20:36:38.032440+08:00
NOTE: skipping rediscovery for group 1/0x94139783 (DATA) on local instance.
2022-04-06T20:36:38.207645+08:00
NOTE: running client discovery for group 1 (reqid:10670038531067476440)
2022-04-06T20:36:38.233574+08:00
NOTE: initiating client [fcdbuat1:fcdbuat:rac-uat] discovery for group 1 (reqid:10670038531067476440)
2022-04-06T20:36:42.750156+08:00
NOTE: client [fcdbuat1:fcdbuat:rac-uat] completed disk validation (reqid:10670038531067476440 KFNPDRFLG=1)
2022-04-06T20:36:43.257907+08:00
GMON updating for reconfiguration, group 1 at 3952 for pid 46, osid 38327
2022-04-06T20:36:43.264001+08:00
NOTE: group 1 PST updated.
2022-04-06T20:36:43.268337+08:00
NOTE: membership refresh pending for group 1/0x94139783 (DATA)
2022-04-06T20:36:43.361811+08:00
GMON querying group 1 at 3953 for pid 25, osid 3205
2022-04-06T20:36:43.394810+08:00
NOTE: client fcdbuat1:fcdbuat:rac-uat mounted group 1 (DATA)
NOTE: cache opening disk 3 of grp 1: DATA4 label:DATA4
2022-04-06T20:36:43.396465+08:00
GMON querying group 1 at 3954 for pid 25, osid 3205
2022-04-06T20:36:43.491781+08:00
SUCCESS: refreshed membership for 1/0x94139783 (DATA)
2022-04-06T20:36:45.358808+08:00
SUCCESS: alter diskgroup DATA add disk 'AFD:DATA4' rebalance power 10
2022-04-06T20:36:45.959547+08:00
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA. No voting file found.
2022-04-06T20:36:45.972825+08:00
NOTE: starting rebalance of group 1/0x94139783 (DATA) at power 10
NOTE: starting process ARBA
Starting background process ARBA
2022-04-06T20:36:46.047631+08:00
ARBA started with pid=49, OS id=38450
NOTE: starting process ARB0
Starting background process ARB0
2022-04-06T20:36:46.108774+08:00
ARB0 started with pid=51, OS id=38451
NOTE: assigning ARBA to group 1/0x94139783 (DATA) to compute estimates
NOTE: assigning ARB0 to group 1/0x94139783 (DATA) with 10 parallel I/Os
2022-04-06T21:33:13.734247+08:00
NOTE: Starting expel slave for group 1/0x94139783 (DATA)
2022-04-06T21:33:13.744319+08:00
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=1
2022-04-06T21:33:13.753817+08:00
NOTE: membership refresh pending for group 1/0x94139783 (DATA)
2022-04-06T21:33:13.942241+08:00
GMON querying group 1 at 3955 for pid 25, osid 3205
2022-04-06T21:33:13.945033+08:00
SUCCESS: refreshed membership for 1/0x94139783 (DATA)
2022-04-06T21:33:15.882271+08:00
NOTE: stopping process ARB0
NOTE: stopping process ARBA
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA. No voting file found.
2022-04-06T21:33:16.735728+08:00
SUCCESS: rebalance completed for group 1/0x94139783 (DATA)
