Oracle 11g grid 删除故障节点，重新添加

由于一个节点软件故障，不能启动，需要删除，重新添加节点。

1，删除损坏节点：

#在正常节点执行--删除之前建议故障节点没有oracle,grid相关进程，可以使用kill 清理干净。

olsnodes -t -s

crsctl delete node -n racdb2

#使用grid用户更新集群列表-inventory信息

$ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME “CLUSTER_NODES={racdb1}” CRS=true

#oracle用户新集群列表-inventory信息

$ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME “CLUSTER_NODES={racdb1}”

#故障节点直接删除软件安装目录--本次集群和数据库软件安装位置为u01

rm -rf /u01

2，重新添加节点

##grid重装节点执行

export IGNORE_PREADDNODE_CHECKS=Y

$ORACLE_HOME/oui/bin/addNode.sh -silent "CLUSTER_NEW_NODES={racdb02}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={racdb02-vip}"

##oracle重装节点执行

export IGNORE_PREADDNODE_CHECKS=Y

$ORACLE_HOME/oui/bin/addNode.sh -silent "CLUSTER_NEW_NODES={racdb02}"

##########oracle文档步骤：

Deleting a Cluster Node on Linux and UNIX Systems

1,Ensure that Grid_home correctly specifies the full directory path for the Oracle Clusterware home on each node, where Grid_home is the location of the installed Oracle Clusterware software.2,$ olsnodes -s -t
3,$ emctl stop dbconsole
# ./rootcrs.pl -deconfig -force

Note:

If you do not use the -force option in the preceding command or the node you are deleting is not accessible for you to execute the preceding command, then the VIP resource remains running on the node. You must manually stop and remove the VIP resource using the following commands as root from any node that you are not deleting:

# srvctl stop vip -i vip_name -f
# srvctl remove vip -i vip_name -f

4,
# crsctl delete node -n node_to_be_deleted5,
$ ./runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES={node_to_be_deleted}" CRS=TRUE -silent -local

6,If you have a shared home, then run the following commands in the following order on the node you want to delete.
#Run the following command to deconfigure Oracle Clusterware:
$ Grid_home/perl/bin/perl Grid_home/crs/install/rootcrs.pl -deconfig
#Run the following command from the Grid_home/oui/bin directory to detach the Grid home:
$ ./runInstaller -detachHome ORACLE_HOME=Grid_home -silent -local

#Manually delete the following files:
/etc/oraInst.loc
/etc/oratab
/etc/oracle/
/opt/ORCLfmap/
$OraInventory/
#For a local home, deinstall the Oracle Clusterware home from the node that you want to delete, as follows, by running the following command, where Grid_home is the path defined for the Oracle Clusterware home:
$ Grid_home/deinstall/deinstall -local


7,On any node other than the node you are deleting
$ ./runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES={remaining_nodes_list}" CRS=TRUE -silent

#You must run this command a second time where ORACLE_HOME=ORACLE_HOME, and CRS=TRUE -silent is omitted from the syntax, as follows:
$ ./runInstaller -updateNodeList ORACLE_HOME=ORACLE_HOME "CLUSTER_NODES={remaining_nodes_list}"

8,Run the following CVU command to verify that the specified nodes have been successfully deleted from the cluster:
$ cluvfy stage -post nodedel -n node_list [-verbose]

#Adding a Cluster Node on Linux and UNIX Systems

#To extend the Grid Infrastructure home to the node3, navigate to the Grid_home/oui/bin directory on node1 and run the addNode.sh script as the user that installed Oracle Clusterware using the following syntax, where node3 is the name of the node that you are adding and node3-vip is the VIP name for the node:#If you are using Grid Naming Service (GNS), run the following command:
$ ./addNode.sh "CLUSTER_NEW_NODES={node3}"
#If you are not using GNS, run the following command:
$ ./addNode.sh "CLUSTER_NEW_NODES={node3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={node3-vip}"
#Navigate to the Oracle_home/oui/bin directory on node1 and run the addNode.sh script as the user that installed Oracle RAC using the following syntax:$ ./addNode.sh "CLUSTER_NEW_NODES={node3}"