转载

【RAC】Oracle11g RAC删除节点相关事项

RAC delete node

操作前建议检查相关信息，如集群状态、数据库运行情况等，最好最一个备份。

########移除数据库########
--通过DBCA方式删除节点（此处举例rac03），请在rac01/02运行，如不说明，默认情况下rac03运行

点击(此处)折叠或打开

dbca -silent -deleteInstance -nodeList rac03 -gdbName racdb -instanceName racdb3 -sysDBAUserName sys -sysDBAPassword oracle

--查看数据库运行情况，

点击(此处)折叠或打开

---停止监听

点击(此处)折叠或打开

--更新查看列表

点击(此处)折叠或打开

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

--移除数据库实例节点

点击(此处)折叠或打开

./deinstall -local
…………………………
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Successfully detached Oracle home '/u02/app/oracle/product/11.2.0/db_home' from the central inventory on the local node.
Successfully deleted directory '/u02/app/oracle/product/11.2.0/db_home' on the local node.
Oracle Universal Installer cleanup was successful.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############

--更新其他的节点的inventory RAC01/02执行

点击(此处)折叠或打开

./runInstaller -updateNodeList ORACLE_HOME=/u02/app/oracle/product/11.2.0/db_home "CLUSTER_NODES={rac1,rac2}"

###########移除 grid#################

--查看状态 olsnodes -s -t

--移除节点grid资源配置 root用户

点击(此处)折叠或打开

/u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force
………………
CRS-2673: Attempting to stop 'ora.cssd' on 'rac03'
CRS-2677: Stop of 'ora.cssd' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac03'
CRS-2677: Stop of 'ora.gipcd' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac03'
CRS-2677: Stop of 'ora.gpnpd' on 'rac03' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac03' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully deconfigured Oracle clusterware stack on this node