RAC删除节点操作

                                        RAC删除节点操作

   因为各种原因有时候需要删除不必要的节点，删除节点很方便，可以在线操作，不需要任何的停时间.
环境:ORACLE RAC 12C,OS redhat 5.8
需求:删除节点RAC2

1,使用dbca删除将要删除节点上的instnace。有朋友不先删除实例，后续的步骤把整个数据库都删掉了.

2,查看将要删除的节点是被pin住，如果pin住需要，unpin节点

[grid@rac2 ~]$ olsnodes -n -t -s
rac1    1       Active  Pinned
rac2    2       Active  Pinned

3,unpin节点.需要root权限

[root@rac2 12.1.0]#  crsctl unpin css -n rac2
CRS-4667: Node rac2 successfully unpinned.

4,删除软件

[oracle@rac2 bin]$ /u01/app/oracle/product/12.1.1/db_1/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/12.1.1/db_1 "CLUSTER_NODES={rac2}" –local

[oracle@rac2 bin]$ /u01/app/oracle/product/12.1.1/db_1/deinstall/deinstall -local  --删除oracle home， run as oracle user,不定义local,把整个集群所有节点上的软件都删掉了.

[grid@rac2 deinstall]$ ./deinstall -local   --删除crs oracle,run as grid

Option -local will not modify any ASM configuration.
Do you want to continue (y - yes, n - no)? [n]: y   --选择y

Run the following command as the root user or the administrator on node "rac2".

/tmp/deinstall2014-02-10_08-44-36AM/perl/bin/perl -I/tmp/deinstall2014-02-10_08-44-36AM/perl/lib -I/tmp/deinstall2014-02-10_08-44-36AM/crs/install /tmp/deinstall2014-02-10_08-44-36AM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2014-02-10_08-44-36AM/response/deinstall_OraGI12Home1.rsp"

Press Enter after you finish running the above commands

--以上提示，copy命令到另一个终端窗口以root用户执行,执行完毕后，在该窗口中按enter
待以root执行的窗口出现以下提示，再返回当窗口输入enter

2014/02/10 08:54:17 CLSRSC-336: Successfully deconfigured Oracle clusterware stack on this node

5,在其他节点上删除被删除节点信息

[root@rac1 grid]# crsctl delete node -n rac2
CRS-4661: Node rac2 successfully deleted.

6,在其他节点上更新grid软件信息，主要是更新inventory中的信息

[grid@rac1 bin]$ $GI_HOME/oui/bin/runInstaller -updatenodelist ORACLE_HOME=/u01/app/grid/12.1.0 cluster_nodes={rac1} CRS=TRUE -slient
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 3164 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
'UpdateNodeList' was successful.

7,在其他节点上更新oracle软件信息，主要是更新inventory中的信息

[oracle@rac1 bin]$ $ORACLE_HOME/oui/bin/runInstaller -updatenodelist ORACLE_HOME=/u01/app/oracle/product/12.1.1/db_1 cluster_nodes={rac1} CRS=TRUE -slient

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 2819 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
'UpdateNodeList' was successful.

8,确认删除完成.
[grid@rac1 bin]$ olsnodes -n -t -s
rac1    1       Active  Pinned
[grid@rac1 bin]$