oracle 12c 删除节点,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]$