oracle rac 如何正确的删除单个节点的actionlist

1 节点2 使用dbca删除1个节点 2 节点1 alter database disable thread 2; 3 节点1 验证是不是已删除1个节点数据库 [03:49:06 oracle(db)@rac1 ~]$ srvctl config database -d prod Database unique name: prod Database name: prod Oracle home: /u01/app/oracle/product/11.2.0/db Oracle user: oracle Spfile: +DATA/prod/spfileprod.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: prod Database instances: prod1 Disk Groups: DATA Mount point paths: Services: Type: RAC Database is administrator managed 4 节点1 停止节点2的监听 srvctl disable listener -l LISTENER -n rac2; srvctl stop listener -l LISTENER -n rac2; 5 节点2 更新节点信息 /u01/app/oracle/product/11.2.0/db/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0/db "CLUSTER_NODES={rac2}" -local 6 节点2 删除节点2的ORACLE软件 /u01/app/oracle/product/11.2.0/db/deinstall/deinstall -local 7 节点1 更新剩余节点的信息 /u01/app/oracle/product/11.2.0/db/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0/db "CLUSTER_NODES={rac1}" 删除oracle软件已完成 下面来删除grid软件 8 节点1 查看ons的资源情况 olsnodes -s -t rac1 Active Unpinned rac2 Active Unpinned 9 节点2 以root用户履行rootcrs.pl 脚本清楚grid的配置信息 /u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -deinstall -force 10 节点1 再次确认ons的资源情况 olsnodes -s -t rac1 Active Unpinned rac2 Inactive Unpinned 11 节点1 root用户履行 删除另外1个节点的信息 crsctl delete node -n rac2 olsnodes -s -t rac1 Active Unpinned 12 节点2 oracle用户履行 /u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid/ "CLUSTER_NODES=rac2" CRS=TRUE -silent -local 13 节点2 卸载grid软件 oracle用户履行 /u01/app/11.2.0/grid/deinstall/deinstall -local root 用户下履行 rm -rf /etc/oraInst.loc rm -rf /opt/ORCLfmap rm -rf /etc/oratab 14 节点1 更新剩余节点的信息 oracle用户履行： /u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid/ "CLUSTER_NODES=rac1" CRS=TRUE -silent 15 节点1 检查是不是已删除 [04:24:28 oracle(db)@rac1 ~]$ 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. 可以看到节点删除成功