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
|
[grid@vm2db1 ~]$ asmcmd
ASMCMD> lsdsk -p
Group_Num Disk_Num Incarn Mount_Stat Header_Stat Mode_Stat State Path
1 1 4042302369 MISSING UNKNOWN OFFLINE NORMAL
2 36 4042302407 MISSING UNKNOWN OFFLINE NORMAL
2 37 4042302406 MISSING UNKNOWN OFFLINE NORMAL
1 6 4042302368 CACHED MEMBER ONLINE NORMAL /dev/exadata_quorum/QD_DATAC1_VM2DB2
1 4 4042302366 CACHED MEMBER ONLINE NORMAL o/100.107.0.11;100.107.0.12/DATAC1_CD_00_icn170737exdcl02
1 29 4042302365 CACHED MEMBER ONLINE NORMAL o/100.107.0.11;100.107.0.12/DATAC1_CD_01_icn170737exdcl02
[grid@vm2db1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 22 20:46:53 2023
Version 19.15.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
SQL> set linesize 200 pagesize 300
SQL> col name for a25
SQL> col path for a45
SQL> select name,header_status,mount_status,path from v$asm_disk where mount_status<>'CACHED';
NAME HEADER_STATU MOUNT_S PATH
MEMBER CLOSED /dev/exadata_quorum/QD_DATAC1_VM2DB1
MEMBER CLOSED /dev/exadata_quorum/QD_RECOC1_VM2DB1
QD_RECOC1_VM2DB2 UNKNOWN MISSING
QD_DATAC1_VM2DB1 UNKNOWN MISSING
QD_RECOC1_VM2DB1 UNKNOWN MISSING
MEMBER CLOSED /dev/exadata_quorum/QD_RECOC1_VM2DB2
6 rows selected.
节点1登录操作:
SQL> ALTER DISKGROUP DATAC1 ONLINE quorum DISK QD_DATAC1_VM2DB1;
Diskgroup altered.
SQL> ALTER DISKGROUP RECOC1 ONLINE quorum DISK QD_RECOC1_VM2DB1;
Diskgroup altered.
SQL> select name,header_status,mount_status,path from v$asm_disk where mount_status<>'CACHED';
NAME HEADER_STATU MOUNT_S PATH
MEMBER CLOSED /dev/exadata_quorum/QD_RECOC1_VM2DB1
QD_RECOC1_VM2DB2 UNKNOWN MISSING
QD_RECOC1_VM2DB1 UNKNOWN MISSING
MEMBER CLOSED /dev/exadata_quorum/QD_RECOC1_VM2DB2
SQL> select name,header_status,mount_status,path from v$asm_disk where mount_status<>'CACHED';
NAME HEADER_STATU MOUNT_S PATH
QD_RECOC1_VM2DB2 UNKNOWN MISSING
MEMBER CLOSED /dev/exadata_quorum/QD_RECOC1_VM2DB2
节点2登录操作:
[grid@vm2db2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 22 20:48:02 2023
Version 19.15.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
SQL> ALTER DISKGROUP RECOC1 ONLINE quorum DISK QD_RECOC1_VM2DB2;
Diskgroup altered.
SQL> set linesize 200 pagesize 300
SQL> col name for a25
SQL> col path for a45
SQL> select name,header_status,mount_status,path from v$asm_disk where mount_status<>'CACHED';
no rows selected
|
