绑定完请刷新页面
取消
刷新

分享好友

×
取消 复制
如何删除集群节点
2020-09-27 11:31:53

正常删除集群节点集群正常运行中,出于更换硬件等的要求删除节点。下面模拟这个过程。

前提:2节点集群,RAC1RAC2 ,删除RAC2节点

1 确认GRID_HOME,集群安装软件目录 


[grid@rac2 asm]$ echo $ORACLE_HOME

/oracle/asm


2 查询节点状态,是否pin

[root@rac2 ~]# olsnodes -s -t

rac1    Active  Unpinned

rac2    Active  Unpinned


3 卸载集群软件

[root@rac2 install]# ./rootcrs.pl -deconfig -force

Using configuration parameter file: ./crsconfig_params

PRCR-1070 : Failed to check if resource ora.rac2.vip is registered

Cannot communicate with crsd

PRCR-1070 : Failed to check if resource ora.gsd is registered

Cannot communicate with crsd

PRCR-1070 : Failed to check if resource ora.ons is registered

Cannot communicate with crsd


CRS-2797: Shutdown is already in progress for 'rac2', waiting for it to complete

CRS-2797: Shutdown is already in progress for 'rac2', waiting for it to complete

CRS-4133: Oracle High Availability Services has been stopped.

Removing Trace File Analyzer

Successfully deconfigured Oracle clusterware stack on this node


4 在其保留节点执行如下操作,删除集群对节点2的记录信息

[root@rac1 ~]# crsctl delete node -n rac2

CRS-4661: Node rac2 successfully deleted.


5 RAC2 更新节点列表

[grid@rac2 ~]$ cd /oracle/asm/oui/bin

[grid@rac2 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/oracle/asm "CLUSTER_NODES={rac2}" CRS=TRUE -local;

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 1998 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /oracle/oraInventory

'UpdateNodeList' was successful.


6 删除节点RAC2的集群软件

grid@rac2 asm]$ cd /oracle/asm/deinstall/

[grid@rac2 deinstall]$ ./deinstall -local       <<<<按照提示执行,中间需要跑一个脚本


7 在保留节点更新节点列表


[grid@rac1 ~]$ cd $ORACLE_HOME/oui/bin

[grid@rac1 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/oracle/asm "CLUSTER_NODES={rac1}" CRS=TRUE;

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 2046 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /oracle/oraInventory

 'UpdateNodeList' was successful.


8运行CVU确认指定节点已经正常删除

[grid@rac1 ~]$ cd $ORACLE_HOME/oui/bin

[grid@rac1 bin]$  cluvfy stage -post nodedel -n rac2 -verbose;

Performing post-checks for node removal 

Checking CRS integrity...


Clusterware version consistency passed

The Oracle Clusterware is healthy on node "rac1"

CRS integrity check passed

Result: 

Node removal check passed

Post-check for node removal was successful.



9 检查节点状态 

[grid@rac1 bin]$    olsnodes -s -t

rac1    Active  Unpinned


[grid@rac1 bin]$ crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE        SERVER                   STATE_DETAILS       

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ARCH.dg

               ONLINE  ONLINE       rac1                                         

ora.ASMOCR.dg

               ONLINE  ONLINE       rac1                                         

ora.ASMVG1.dg

               ONLINE  ONLINE       rac1                                         

ora.LISTENER.lsnr

               ONLINE  ONLINE       rac1                                         

ora.asm

               ONLINE  ONLINE       rac1                     Started             

ora.gsd

               OFFLINE OFFLINE      rac1                                         

ora.net1.network

               ONLINE  ONLINE       rac1                                         

ora.ons

               ONLINE  ONLINE       rac1                                         

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       rac1                                         

ora.cvu

      1        ONLINE  ONLINE       rac1                                         

ora.oc4j

      1        ONLINE  ONLINE       rac1                                         

ora.orcl.db

      1        ONLINE  ONLINE       rac1                     Open                

      2        ONLINE  OFFLINE                               Instance Shutdown   

ora.rac1.vip

      1        ONLINE  ONLINE       rac1                                         

ora.rac2.vip

      1        ONLINE  INTERMEDIATE rac1                     FAILED OVER         

ora.scan1.vip

      1        ONLINE  ONLINE       rac1                                         


至此,完整删除集群的RAC2节点。

分享好友

分享这个小栈给你的朋友们,一起进步吧。

Oracle运维新鲜事-技术与管理各占半边天
创建时间:2020-08-04 11:34:57
本技术栈旨在分享技术心得,运维趣事,故障处理经验,调优案例,故障处理涉及集群,DG,OGG,大家生产中遇到的问题基本都会囊括了,我会发布生产库遇到的故障,希望在交流中互助互益,共同提高,也希望大家讨论,如果您有生产中遇到的集群问题,也可以在这里提出来,一起讨论,现实中也帮助不少同学解决了生产库的故障。
展开
订阅须知

• 所有用户可根据关注领域订阅专区或所有专区

• 付费订阅:虚拟交易,一经交易不退款;若特殊情况,可3日内客服咨询

• 专区发布评论属默认订阅所评论专区(除付费小栈外)

栈主、嘉宾

查看更多
  • Abraham林老师
    栈主
  • 小雨滴
    嘉宾
  • hawkliu
    嘉宾
  • u_97a59a25246404
    嘉宾

小栈成员

查看更多
  • 栈栈
  • dapan
  • 小菜鸟___
  • hwayw
戳我,来吐槽~