OS 환경 : Oracle Linux 8.4 (64bit)
DB 환경 : Oracle Database 19.27.0.0
방법 : 오라클 19c RAC 노드 제거 방법(gui)
이전글에서 이어지는 글임
참고 : 오라클 19c RAC 노드 추가 방법(gui)( https://positivemh.tistory.com/1245 )
본문에서는 오라클 19c 3노드 rac 환경에서 3번 노드를 제거하는 방법을 설명함
기존 노드 정보 :
hostname, public ip, private ip
노드1 : ora19rac1, 192.168.137.61, 10.10.10.110
노드2 : ora19rac2, 192.168.137.62, 10.10.10.120
노드3 : ora19rac3, 192.168.137.63, 10.10.10.130
제거될 노드 정보 : ora19rac3, 192.168.137.63, 10.10.10.130
현재 grid 및 db는 온라인 상태임
crs 상태 확인
|
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
|
# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.chad
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.net1.network
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.ons
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.proxy_advm
OFFLINE OFFLINE ora19rac1 STABLE
OFFLINE OFFLINE ora19rac2 STABLE
OFFLINE OFFLINE ora19rac3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ora19rac1 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.VOTE.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 Started,STABLE
2 ONLINE ONLINE ora19rac2 Started,STABLE
3 ONLINE ONLINE ora19rac3 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.cvu
1 ONLINE ONLINE ora19rac1 STABLE
ora.ora11db.db
1 ONLINE ONLINE ora19rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE ora19rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.ora19db.db
1 ONLINE ONLINE ora19rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE ora19rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
3 ONLINE ONLINE ora19rac3 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.ora19rac1.vip
1 ONLINE ONLINE ora19rac1 STABLE
ora.ora19rac2.vip
1 ONLINE ONLINE ora19rac2 STABLE
ora.ora19rac3.vip
1 ONLINE ONLINE ora19rac3 STABLE
ora.qosmserver
1 ONLINE ONLINE ora19rac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE ora19rac1 STABLE
--------------------------------------------------------------------------------
|
ora19db에 3번 인스턴스를 제거 예정임, 업그레이드 테스트시 사용한 ora11db도 존재하지만 본문에서는 무시해도됨
grid에서 3번 인스턴스 제거(1번 노드에서 수행)
dbca로 제거시 undo, redo가 자동으로 제거되고 3번 thread disable도 자동으로 수행됨
|
1
2
|
$ cd $ORACLE_HOME/bin/
$ ./dbca
|
Oracle RAC database instance management 선택
Delete an instance 선택
ORA19DB 선택 후 유저 및 패스워드 입력
ORA19DB3 선택
Finish 선택
Yes 선택
제거중
언두 3번 삭제시 에러가 발생하지만 Continue 선택
Close 선택
UNDOTBS3가 없다는 에러 메세지가 발생했지만 제거는 정상적으로 완료됨
이전에 UNDOTBS3를 수동으로 지운뒤 다시 노드 추가를 해서 인스턴스 생성시 3번 인스턴스에 대한 언두가 UNDOTBS4로 생성되었는데 이부분 때문에 에러가 난듯함
3번 노드 undo 삭제
|
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
|
SQL>
set lines 200 pages 1000
col tablespace_name for a20
col file_name for a70
select tablespace_name, file_id, file_name, round(bytes/1024/1024/1024, 2) gb,
round(maxbytes/1024/1024/1024, 2) max_gb, autoextensible, status, online_status from dba_data_files
union all
select tablespace_name, file_id, file_name, round(bytes/1024/1024/1024, 2) gb,
round(maxbytes/1024/1024/1024, 2) max_gb, autoextensible, status, null from dba_temp_files order by 2;
TABLESPACE_NAME FILE_ID FILE_NAME GB MAX_GB AUT STATUS ONLINE_
-------------------- ---------- ---------------------------------------------------------------------- ---------- ---------- --- --------- -------
SYSTEM 1 +DATA/ORA19DB/DATAFILE/system.274.1201188459 1.46 0 NO AVAILABLE SYSTEM
TEMP 1 +DATA/ORA19DB/TEMPFILE/temp.277.1201188465 1 32 YES ONLINE
SYSAUX 2 +DATA/ORA19DB/DATAFILE/sysaux.275.1201188461 1 0 NO AVAILABLE ONLINE
UNDOTBS1 3 +DATA/ORA19DB/DATAFILE/undotbs1.276.1201188463 1 0 NO AVAILABLE ONLINE
UNDOTBS2 4 +DATA/ORA19DB/DATAFILE/undotbs2.278.1201188471 1 0 NO AVAILABLE ONLINE
USERS 5 +DATA/ORA19DB/DATAFILE/users.279.1201188471 0 0 NO AVAILABLE ONLINE
UNDOTBS4 6 +DATA/ORA19DB/DATAFILE/undotbs4.305.1206386611 1 0 NO AVAILABLE ONLINE
7 rows selected.
SQL> drop tablespace undotbs4 including contents and datafiles;
Tablespace dropped.
|
redo 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
SQL>
set lines 200
set pages 1000
col member for a60
select thread#, l.group#, member, archived, l.status, (bytes/1024/1024) MB, sequence#
from v$log l, v$logfile f
where f.group# = l.group#
order by 1, 2;
THREAD# GROUP# MEMBER ARC STATUS MB SEQUENCE#
---------- ---------- ------------------------------------------------------------ --- ---------------- ---------- ----------
1 1 +DATA/ORA19DB/ONLINELOG/group_1.272.1201188457 NO CURRENT 200 67
1 2 +DATA/ORA19DB/ONLINELOG/group_2.273.1201188459 YES INACTIVE 200 66
2 3 +DATA/ORA19DB/ONLINELOG/group_3.280.1201189697 YES INACTIVE 200 45
2 4 +DATA/ORA19DB/ONLINELOG/group_4.281.1201189697 NO CURRENT 200 46
|
thread 상태 확인
|
1
2
3
4
5
6
|
SQL> select thread#, enabled from v$thread;
THREAD# ENABLED
---------- --------
1 PUBLIC
2 PUBLIC
|
crs 상태 확인
|
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
|
$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.chad
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.net1.network
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.ons
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.proxy_advm
OFFLINE OFFLINE ora19rac1 STABLE
OFFLINE OFFLINE ora19rac2 STABLE
OFFLINE OFFLINE ora19rac3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ora19rac1 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.VOTE.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 Started,STABLE
2 ONLINE ONLINE ora19rac2 Started,STABLE
3 ONLINE ONLINE ora19rac3 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.cvu
1 ONLINE ONLINE ora19rac1 STABLE
ora.ora11db.db
1 ONLINE ONLINE ora19rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE ora19rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.ora19db.db
1 ONLINE ONLINE ora19rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE ora19rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.ora19rac1.vip
1 ONLINE ONLINE ora19rac1 STABLE
ora.ora19rac2.vip
1 ONLINE ONLINE ora19rac2 STABLE
ora.ora19rac3.vip
1 ONLINE ONLINE ora19rac3 STABLE
ora.qosmserver
1 ONLINE ONLINE ora19rac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE ora19rac1 STABLE
--------------------------------------------------------------------------------
|
정상적으로 db 인스턴스가 제거됨
db 엔진 제거(3번 노드에서 수행)
|
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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
$ cd $ORACLE_HOME/deinstall
$ ./deinstall -local
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /oracle/app/oraInventory/logs/
############ ORACLE DECONFIG TOOL START ############
######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##
Checking for existence of the Oracle home location /oracle/app/oracle/product/19c
Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database
Oracle Base selected for deinstall is: /oracle/app/oracle
Checking for existence of central inventory location /oracle/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /oracle/app/grid/19c
The following nodes are part of this cluster: ora19rac3,ora19rac2,ora19rac1
Checking for sufficient temp space availability on node(s) : 'ora19rac3'
## [END] Install check configuration ##
Network Configuration check config START
Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_check2025-07-13_08-31-39PM.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_check2025-07-13_08-31-39PM.log
Use comma as separator when specifying list of values as input
Specify the list of database names that are configured locally on this node for this Oracle home. Local configurations of the discovered databases will be removed []: <<-- 엔터 입력
Database Check Configuration END
######################### DECONFIG CHECK OPERATION END #########################
####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /oracle/app/grid/19c
The following nodes are part of this cluster: ora19rac3,ora19rac2,ora19rac1
The cluster node(s) on which the Oracle home deinstallation will be performed are:ora19rac3
Oracle Home selected for deinstall is: /oracle/app/oracle/product/19c
Inventory Location where the Oracle home registered is: /oracle/app/oraInventory
Do you want to continue (y - yes, n - no)? [n]: y <<-- y 입력
A log of this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2025-07-13_08-31-34-PM.out'
Any error messages from this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2025-07-13_08-31-34-PM.err'
######################## DECONFIG CLEAN OPERATION START ########################
Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_clean2025-07-13_08-31-39PM.log
Network Configuration clean config START
Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_clean2025-07-13_08-31-39PM.log
Network Configuration clean config END
######################### DECONFIG CLEAN OPERATION END #########################
####################### DECONFIG CLEAN OPERATION SUMMARY #######################
#######################################################################
############# ORACLE DECONFIG TOOL END #############
Using properties file /tmp/deinstall2025-07-13_08-30-56PM/response/deinstall_2025-07-13_08-31-34-PM.rsp
Location of logs /oracle/app/oraInventory/logs/
############ ORACLE DEINSTALL TOOL START ############
####################### DEINSTALL CHECK OPERATION SUMMARY #######################
A log of this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2025-07-13_08-31-34-PM.out'
Any error messages from this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2025-07-13_08-31-34-PM.err'
######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to ora19rac3
Setting CLUSTER_NODES to ora19rac3
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2025-07-13_08-30-56PM/oraInst.loc
Setting oracle.installer.local to true
## [END] Preparing for Deinstall ##
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START
Detach Oracle home '/oracle/app/oracle/product/19c' from the central inventory on the local node : Done
Delete directory '/oracle/app/oracle/product/19c' on the local node : Done
The Oracle Base directory '/oracle/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/oracle/app/grid/19c'.
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END
## [START] Oracle install clean ##
## [END] Oracle install clean ##
######################### DEINSTALL CLEAN OPERATION END #########################
####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/oracle/app/oracle/product/19c' from the central inventory on the local node.
Successfully deleted directory '/oracle/app/oracle/product/19c' on the local node.
Oracle Universal Installer cleanup was successful.
Review the permissions and contents of '/oracle/app/oracle' on nodes(s) 'ora19rac3'.
If there are no Oracle home(s) associated with '/oracle/app/oracle', manually delete '/oracle/app/oracle' and its contents.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
############# ORACLE DEINSTALL TOOL END #############
|
완료됨
db 엔진 경로 확인
|
1
2
3
4
5
6
|
$ pwd
/oracle/app/oracle/product
$ ls -al
total 0
drwxrwxr-x. 2 oracle dba 6 Jul 13 15:41 .
drwxrwxr-x. 10 oracle dba 123 Jul 13 14:47 ..
|
정상적으로 제거됨
grid 엔진 제거(1번 노드에서 수행)
grid 오너로 수행, 현재 서버에는 grid 유저 없이 oracle 유저로만 구성함
|
1
2
3
|
# su - oracle
$ cd $GRID_HOME
$ ./gridSetup.sh
|
Remove nodes from the cluster 선택
ora19rac3 선택
root 스크립트 자동수행 선택
Summit 선택
grid 제거중
참고로 만약 여기서 [INS-32301] Deinstall tool failed . Check the install log for more details. 에러가 발생한다면 아래 게시글을 참고한뒤 다시 시도하면됨
참고 : [PILOT-00452] Unable to establish SSH connection to node "nodename" to execute command deinstall ( https://positivemh.tistory.com/1246 )
Yes 선택
Close 선택
grid 엔진 경로 확인
|
1
2
3
4
5
6
7
8
9
|
$ ls -al /oracle/app/
total 0
drwxrwxr-x. 3 oracle oinstall 18 Jul 13 21:06 .
drwxrwxr-x. 5 oracle oinstall 50 Jul 12 21:04 ..
drwxrwxr-x. 2 oracle oinstall 6 Jul 13 21:06 grid
$ ls -al grid/
total 0
drwxrwxr-x. 2 oracle oinstall 6 Jul 13 21:06 .
drwxrwxr-x. 3 oracle oinstall 18 Jul 13 21:06 ..
|
정상적으로 제거됨
아래 경로 삭제(제거할 3번 노드에서 실행)
|
1
2
3
4
5
|
# rm -rf /etc/oracle
# rm -rf /var/tmp/.oracle
# rm -rf /opt/ORCLfmap
# rm -rf /etc/oraInst.loc
--# rm -rf /etc/oratab
|
여기서 /etc/oratab은 백업해두면 좋음
현재 crs 상태 확인(남아있는 노드에서 확인)
|
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
|
$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ora.chad
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ora.net1.network
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ora.ons
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE ora19rac1 STABLE
OFFLINE OFFLINE ora19rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ora19rac1 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.VOTE.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 Started,STABLE
2 ONLINE ONLINE ora19rac2 Started,STABLE
3 ONLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE ora19rac1 STABLE
ora.ora11db.db
1 ONLINE ONLINE ora19rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE ora19rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.ora19db.db
1 ONLINE ONLINE ora19rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE ora19rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.ora19rac1.vip
1 ONLINE ONLINE ora19rac1 STABLE
ora.ora19rac2.vip
1 ONLINE ONLINE ora19rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE ora19rac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE ora19rac1 STABLE
--------------------------------------------------------------------------------
|
3번 노드 이름이 없어지고 번호만 남음, 해당 리소스들이 OFFLINE으로 표시됨
남아있는 노드에서 노드 제거 명령 수행
|
1
2
|
# crsctl delete node -n ora19rac3
CRS-4661: Node ora19rac3 successfully deleted.
|
제거됨
rac config 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
$ srvctl config nodeapps -a
Network 1 exists
Subnet IPv4: 192.168.137.0/255.255.255.0/ens192, static
Subnet IPv6:
Ping Targets:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
VIP exists: network number 1, hosting node ora19rac1
VIP Name: ora19rac1-vip
VIP IPv4 Address: 192.168.137.61
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
VIP exists: network number 1, hosting node ora19rac2
VIP Name: ora19rac2-vip
VIP IPv4 Address: 192.168.137.62
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
|
현재 3번 노드 vip는 이미 제거되어 있음
만약 제거되지 않았다면 아래 명령어로 3번 노드 vip 제거(root 유저로 수행)
|
1
2
|
# srvctl stop vip -vip ora19rac3-vip
# srvctl remove vip -vip ora19rac3-vip
|
잘 제거되었는지 확인(선택 사항)
grid 오너로 수행, 현재 서버에는 grid 유저 없이 oracle 유저로만 구성함
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
# su - oracle
$ $GRID_HOME/bin/cluvfy stage -post nodedel -n ora19rac3
Performing following verification checks ...
Node Removal ...
CRS Integrity ...PASSED
Clusterware Version Consistency ...PASSED
Node Removal ...PASSED
Post-check for node removal was successful.
CVU operation performed: stage -post nodedel
Date: Jul 13, 2025 9:28:24 PM
CVU version: 19.27.0.0.0 (041025x8664)
Clusterware version: 19.0.0.0.0
CVU home: /oracle/app/grid/19c
Grid home: /oracle/app/grid/19c
User: oracle
Operating system: Linux5.4.17-2136.342.5.3.el8uek.x86_64
|
정상적으로 제거되었다고 나옴
노드 목록을 확인해봐도 3번 노드는 없다고 나옴
|
1
2
3
|
$ olsnodes -s -t
ora19rac1 Active Unpinned
ora19rac2 Active Unpinned
|
결론 :
본문과 같은 gui 방식으로 rac 환경에서 노드 제거 작업을 온라인으로 진행할 수 있음
참조 :
https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/adding-and-deleting-cluster-nodes.html#GUID-929C0CD9-9B67-45D6-B864-5ED3B47FE458
https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/adding-and-deleting-cluster-nodes.html#GUID-25D8D7A2-5240-401F-A998-00C4B525413F
https://docs.oracle.com/en/database/oracle/oracle-database/19/rnrdm/bug-34485708.html
https://jack-of-all-trades.tistory.com/447
https://pskbigstar.tistory.com/entry/RAC-노드-추가OU
https://pskbigstar.tistory.com/entry/RAC-노드-제거
https://gyh214.tistory.com/entry/RAC%EC%9A%B4%EC%98%81%EC%A4%91-RAC-node-%EC%B6%94%EA%B0%80%ED%95%98%EA%B8%B013-%ED%99%98%EA%B2%BD-VMware-%EC%8B%A4%EC%8A%B5%ED%99%98%EA%B2%BD-11gR2-OEL2618-238el5PAE
https://gyh214.tistory.com/entry/RAC%EC%9A%B4%EC%98%81%EC%A4%91-RAC-node-%EC%B6%94%EA%B0%80%ED%95%98%EA%B8%B023-%ED%99%98%EA%B2%BD-VMware-%EC%8B%A4%EC%8A%B5%ED%99%98%EA%B2%BD-11gR2-OEL2618-238el5PAE
https://gyh214.tistory.com/entry/RAC%EC%9A%B4%EC%98%81%EC%A4%91-RAC-node-%EC%B6%94%EA%B0%80%ED%95%98%EA%B8%B033-%ED%99%98%EA%B2%BD-VMware-%EC%8B%A4%EC%8A%B5%ED%99%98%EA%B2%BD-11gR2-OEL2618-238el5PAE
RAC: How to delete and add a node in 19c RAC (Doc ID 3019970.1)
3045518.1
'ORACLE > Rac' 카테고리의 다른 글
| 오라클 19c RAC 롤링 패치 가능여부 확인 (2) | 2025.09.18 |
|---|---|
| 오라클 19c vote 디스크 위치 변경 방법 (17) | 2025.07.19 |
| 오라클 19c RAC 노드 추가 방법(gui) (0) | 2025.07.13 |
| 오라클 19c RAC 노드 제거 방법(silent) (0) | 2025.07.13 |
| 오라클 19c RAC 노드 추가 방법(silent) (0) | 2025.07.13 |