oracle RAC节点重构_oracle rac 节点重装-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_42575078/article/details/136401213

本文详细描述了如何在OracleRAC环境中清除二节点信息，包括删除实例、更新集群列表、移除VIP、检查和删除节点，以及重新添加节点的过程，涉及dbca、srvctl、olsnodes等工具的使用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、清除集群上二节点的节点信息
1、删除实例
dbca或静默：

[oracle@rac1 ~]$ dbca -silent -deleteinstance -nodelist rac2 -gdbname orcl -instancename orcl2 -sysdbausername sys -sysdbapassword oracle

dbca-实例管理-删除节实例-选择服务输入密码-选择inactive实例-确认删除
2、查看数据库实例情况

[oracle@rac1 ~]$ srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /oracle/app/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/orcl/spfileorcl.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1
Disk Groups: DATA
Services: 
Database is administrator managed
 
 
sqlplus / as sysdba
SQL> select inst_id,instance_name from gv$instance;
 
  INST_ID INSTANCE_NAME
----------------------------------------------------------
         1 orcl1

3、在保留节点使用oracle用户更新集群列表

[oracle@rac1 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME  "CLUSTER_NODES={rac1}"       
 
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB.   Actual 8191 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /oracle/oraInventory
'UpdateNodeList' was successful.

4、移除集群中二节点的VIP
停止二节点VIP：

cd $GRID_HOME/bin
[root@rac1 bin]# ./srvctl stop vip -i rac2-vip

删除二节点VIP：

[root@rac1 bin]#./srvctl remove vip -i rac2-vip -f

5、查看节点状态
查看集群状态

[grid@rac1 ~]$crs_stat -t
[grid@rac1 ~]$crsctl stat res -t

可以看到其中关于二节点的VIP信息已被删除

查看集群节点信息

[grid@rac1 ~]$ olsnodes -s -t
rac1    Active  Unpinned
rac2    Inactive        Unpinned

（如果二节点是ping状态，需要执行这步：
[grid@rac1 ~]$crsctl unpin css -n rac2）

6、删除节点

[root@rac1 bin]# $GRID_HOME/bin/crsctl delete node -n rac2
CRS-4661: Node rac2 successfully deleted.

7、更新GI的inventory信息

su - gird
cd $ORACLE_HOME/oui/bin
[grid@rac1 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={rac1}" CRS=TRUE  -local
 
Starting Oracle Universal Installer...
 
Checking swap space: must be greater than 500 MB.   Actual 8191 MB    Passed
The inventory pointer is located at /etc