一学就会，一会就废系列之--Oracle 10g RAC 多节点集群删除节点实操记录终结篇.pdf
10墨值下载
主机名 public-IP virtual-IP
private-
IP
操作系统版本
数据库版
本
local-xxx-
standby-db1
192.168.10.2 192.168.10.3 10.90.1.12
CentOS release
5.11 (Final)
10.2.0.5
local-xxx-
standby-db1
192.168.10.4 192.168.10.5 10.90.1.14
CentOS release
5.11 (Final)
10.2.0.5
local-xxx-
standby-db1
192.168.10.6 192.168.10.7 10.90.1.16
CentOS release
5.11 (Final)
10.2.0.5
一、概述
1.1 项目背景
有套Oracle 10g RAC 三节点数据库，综合衡量，为更好的节省资源，计划将其改造成单机数据库，剔除其它
两节点。
1.2 现有集群节点信息
二、删除节点
先删除实例三节点，待检查正常后再删除实例二节点。
建议在操作之前备份voting Disk，此处略。
2.1 查看集群状态
使用Oracle用户在任一节点查看集群状态。
[oracle@local-xxx-standby-db1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.xxx.db application 0/0 0/1 ONLINE ONLINE loca...-db2
ora....s1.inst application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....s2.inst application 0/5 0/0 ONLINE ONLINE loca...-db2
ora....s3.inst application 0/5 0/0 ONLINE ONLINE loca...-db3
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....db1.gsd application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....db1.ons application 0/3 0/0 ONLINE ONLINE loca...-db1
ora....db1.vip application 0/0 0/0 ONLINE ONLINE loca...-db1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE loca...-db2
ora....B2.lsnr application 0/5 0/0 ONLINE ONLINE loca...-db2
ora....db2.gsd application 0/5 0/0 ONLINE ONLINE loca...-db2
ora....db2.ons application 0/3 0/0 ONLINE ONLINE loca...-db2
ora....db2.vip application 0/0 0/0 ONLINE ONLINE loca...-db2
ora....SM3.asm application 0/5 0/0 ONLINE ONLINE loca...-db3
ora....B3.lsnr application 0/5 0/0 ONLINE ONLINE loca...-db3
ora....db3.gsd application 0/5 0/0 ONLINE ONLINE loca...-db3
ora....db3.ons application 0/3 0/0 ONLINE ONLINE loca...-db3
ora....db3.vip application 0/0 0/0 ONLINE ONLINE loca...-db3
[oracle@local-xxx-standby-db1 ~]$ srvctl status database -d xxx
Instance xxx1 is running on node local-xxx-standby-db1
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
2.2 停止被删节点实例
使用Oracle用户在任一节点操作，停止被删除节点oracle及ASM实例。
2.3 从spfile删除被删节点参数
使用Oracle用户在任一未被删除节点操作。
Instance xxx2 is running on node local-xxx-standby-db2
Instance xxx3 is running on node local-xxx-standby-db3
27
28
[oracle@local-xxx-standby-db1 ~]$ srvctl stop instance -d xxx -i xxx3 -o immediate
[oracle@local-xxx-standby-db1 ~]$ srvctl status asm -n local-xxx-standby-db3
ASM instance +ASM3 is running on node local-xxx-standby-db3.
[oracle@local-xxx-standby-db1 ~]$ srvctl stop asm -n local-xxx-standby-db3
[oracle@local-xxx-standby-db1 ~]$ srvctl status asm -n local-xxx-standby-db3
ASM instance +ASM3 is not running on node local-xxx-standby-db3.
1
2
3
4
5
6
7
8
[oracle@local-xxx-standby-db1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Sep 19 10:18:25 2023
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> set long 9999 head off pages 0 lines 1000
SQL> show parameter spfile;
spfile string +DATA/xxx/spfilexxx.ora
SQL> select name,value from v$spparameter where sid='xxx3';
thread 3
instance_number 3
undo_tablespace
UNDOTBS3
local_listener
LISTENER_XXX3
SQL> alter system reset thread scope=spfile sid='xxx3';
System altered.
SQL> alter system reset instance_number scope=spfile sid='xxx3';
System altered.
SQL> alter system reset undo_tablespace scope=spfile sid='xxx3';
System altered.
SQL> select name,value from v$spparameter where sid='xxx3';
local_listener
LISTENER_XXX3
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
2.4 停止被删除节点监听
使用Oracle用户在任一非被删除节点操作。
2.5 删除数据库实例
使用Oracle用户在任一非被删除节点操作。
SQL> select sid,name,value from v$spparameter where
name='cluster_database_instances';
* cluster_database_instances 3
36
37
38
[oracle@local-xxx-standby-db1 ~]$ srvctl stop listener -n local-xxx-standby-db3
[oracle@local-xxx-standby-db1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.xxx.db application 0/0 0/1 ONLINE ONLINE loca...-db2
ora....s1.inst application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....s2.inst application 0/5 0/0 ONLINE ONLINE loca...-db2
ora....s3.inst application 0/5 0/0 OFFLINE OFFLINE
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....db1.gsd application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....db1.ons application 0/3 0/0 ONLINE ONLINE loca...-db1
ora....db1.vip application 0/0 0/0 ONLINE ONLINE loca...-db1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE loca...-db2
ora....B2.lsnr application 0/5 0/0 ONLINE ONLINE loca...-db2
ora....db2.gsd application 0/5 0/0 ONLINE ONLINE loca...-db2
ora....db2.ons application 0/3 0/0 ONLINE ONLINE loca...-db2
ora....db2.vip application 0/0 0/0 ONLINE ONLINE loca...-db2
ora....SM3.asm application 0/5 0/0 OFFLINE OFFLINE
ora....B3.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora....db3.gsd application 0/5 0/0 ONLINE ONLINE loca...-db3
ora....db3.ons application 0/3 0/0 ONLINE ONLINE loca...-db3
ora....db3.vip application 0/0 0/0 ONLINE ONLINE loca...-db3
[oracle@local-xxx-standby-db1 ~]$ srvctl status database -d xxx
Instance xxx1 is running on node local-xxx-standby-db1
Instance xxx2 is running on node local-xxx-standby-db2
Instance xxx3 is not running on node local-xxx-standby-db3
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
[oracle@local-xxx-standby-db1 ~]$ srvctl remove instance -d xxx -i xxx3
Remove instance xxx3 from the database xxx? (y/[n]) y --- 输入 y
[oracle@local-xxx-standby-db1 ~]$ srvctl status database -d xxx
Instance xxx1 is running on node local-xxx-standby-db1
Instance xxx2 is running on node local-xxx-standby-db2
[oracle@local-xxx-standby-db1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.xxx.db application 0/0 0/1 ONLINE ONLINE loca...-db2
ora....s1.inst application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....s2.inst application 0/5 0/0 ONLINE ONLINE loca...-db2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....db1.gsd application 0/5 0/0 ONLINE ONLINE loca...-db1
ora....db1.ons application 0/3 0/0 ONLINE ONLINE loca...-db1
ora....db1.vip application 0/0 0/0 ONLINE ONLINE loca...-db1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
of 11
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
陕西北佳信息技术有限责任公司
最新上传
下载排行榜
1
2
9-数据库人的进阶之路：从PG分区、SQL优化到拥抱AI未来（罗敏）.pptx
3
1-PG版本兼容性案例（彭冲）.pptx
4
2-TDSQL PG在复杂查询场景中的挑战与实践-opensource.pdf
5
6-PostgreSQL 哈希索引原理浅析（文一）.pdf
6
3-AI时代的变革者-面向机器的接口语言(MOQL)_吕海波.pptx
7
8-基于PG向量和RAG技术的开源知识库问答系统MaxKB.pptx
8
4-IvorySQL V4：双解析器架构下的兼容性创新实践.pptx
9
7-拉起PG好伙伴DifySupaOdoo.pdf
10
《云原生安全攻防启示录》李帅臻.pdf
文档被以下合辑收录
相关文档
评论