1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
| 节点1:
for i in y z aa ab ac ad;
do
echo "KERNEL==\"sd*[!0-9]\", ENV{DEVTYPE}==\"disk\", SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id -g -u -d \$devnode\", RESULT==\"`/usr/lib/udev/scsi_id
done
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36888603000000021fa1660f531274223", SYMLINK+="asmdisk024", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="368886030000001b7fa1660f531274223", SYMLINK+="asmdisk025", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36888603000000050fa1660f531274223", SYMLINK+="asmdisk026", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="368886030000007dcfa1660f531274223", SYMLINK+="asmdisk027", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36888603000000890fa1660f531274223", SYMLINK+="asmdisk028", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="368886030000005dcfa1660f531274223", SYMLINK+="asmdisk029", OWNER="grid", GROUP="asmadmin", MODE="0660"
节点2:
for i in y z aa ab ac ad;
do
echo "KERNEL==\"sd*[!0-9]\", ENV{DEVTYPE}==\"disk\", SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id -g -u -d \$devnode\", RESULT==\"`/usr/lib/udev/scsi_id
done
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36888603000000021fa1660f531274223", SYMLINK+="asmdisk024", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="368886030000001b7fa1660f531274223", SYMLINK+="asmdisk025", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36888603000000050fa1660f531274223", SYMLINK+="asmdisk026", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="368886030000007dcfa1660f531274223", SYMLINK+="asmdisk027", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36888603000000890fa1660f531274223", SYMLINK+="asmdisk028", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="368886030000005dcfa1660f531274223", SYMLINK+="asmdisk029", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@crmbackup01 ~]# udevadm trigger
[root@crmbackup01 ~]# udevadm control
[grid@crm-oracle-01 ~]$ sqlplus / as sysasm
SQL*Plus: Release 18.0.0.0.0 - Production on Sat Jan 7 11:39:39 2023
Version 18.5.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.5.0.0.0
SQL> set linesize 200 pagesize 200
SQL> col name for a15
SQL> col path for a50
SQL> select name,path,state,mount_status,header_status from v$asm_disk order by name;
NAME PATH STATE MOUNT_S HEADER_STATU
ARCHDG_0000 /dev/asmdisk022 NORMAL CACHED MEMBER
ARCHDG_0001 /dev/asmdisk023 NORMAL CACHED MEMBER
CRSDG_0000 /dev/asmdisk001 NORMAL CACHED MEMBER
CRSDG_0001 /dev/asmdisk002 NORMAL CACHED MEMBER
CRSDG_0002 /dev/asmdisk003 NORMAL CACHED MEMBER
DATADG_0000 /dev/asmdisk007 NORMAL CACHED MEMBER
DATADG_0001 /dev/asmdisk008 NORMAL CACHED MEMBER
DATADG_0002 /dev/asmdisk009 NORMAL CACHED MEMBER
DATADG_0003 /dev/asmdisk010 NORMAL CACHED MEMBER
DATADG_0004 /dev/asmdisk011 NORMAL CACHED MEMBER
DATADG_0005 /dev/asmdisk012 NORMAL CACHED MEMBER
DATADG_0006 /dev/asmdisk013 NORMAL CACHED MEMBER
DATADG_0007 /dev/asmdisk014 NORMAL CACHED MEMBER
DATADG_0008 /dev/asmdisk015 NORMAL CACHED MEMBER
DATADG_0009 /dev/asmdisk016 NORMAL CACHED MEMBER
DATADG_0010 /dev/asmdisk017 NORMAL CACHED MEMBER
DATADG_0011 /dev/asmdisk018 NORMAL CACHED MEMBER
DATADG_0012 /dev/asmdisk019 NORMAL CACHED MEMBER
DATADG_0013 /dev/asmdisk020 NORMAL CACHED MEMBER
DATADG_0014 /dev/asmdisk021 NORMAL CACHED MEMBER
MGMT_0000 /dev/asmdisk004 NORMAL CACHED MEMBER
MGMT_0001 /dev/asmdisk005 NORMAL CACHED MEMBER
MGMT_0002 /dev/asmdisk006 NORMAL CACHED MEMBER
/dev/asmdisk029 NORMAL CLOSED CANDIDATE
/dev/asmdisk024 NORMAL CLOSED CANDIDATE
/dev/asmdisk028 NORMAL CLOSED CANDIDATE
/dev/asmdisk025 NORMAL CLOSED CANDIDATE
/dev/asmdisk027 NORMAL CLOSED CANDIDATE
/dev/asmdisk026 NORMAL CLOSED CANDIDATE
29 rows selected.
SQL> alter diskgroup ARCHDG add disk
2 '/dev/asmdisk024' name ARCHDG_0002,
3 '/dev/asmdisk025' name ARCHDG_0003,
4 '/dev/asmdisk026' name ARCHDG_0004,
5 '/dev/asmdisk027' name ARCHDG_0005,
6 '/dev/asmdisk028' name ARCHDG_0006,
7 '/dev/asmdisk029' name ARCHDG_0007
8 rebalance power 8;
Diskgroup altered.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA PASS STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE CON_ID
1 REBAL COMPACT WAIT 8 8 0 0 0 0 0
1 REBAL REBALANCE RUN 8 8 12128 134800 25866 4 0
1 REBAL REBUILD DONE 8 8 0 0 0 0 0
|
