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]$