【Oracle Real Application Cluster Database】集群删除节点
原创
©著作权归作者所有：来自51CTO博客作者dbprofessional的原创作品，请联系作者获取转载授权，否则将追究法律责任
[grid@node01 ~]$ srvctl stop listener -n node03
[grid@node01 ~]$ srvctl stop instance -d core -n node03
[oracle@node01 ~]$ dbca -silent -deleteInstance -nodeList node03 -gdbName core -instanceName core3 -sysDBAUserName sys -sysDBAPassword 1QAZ2wsx
[oracle@node03 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={node03}" -local
[oracle@node03 ~]$ $ORACLE_HOME/deinstall/deinstall -local
[oracle@node01 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={node01,node02}"
[grid@node01 ~]$ olsnodes -s -t
node01 Active Unpinned
node02 Active Unpinned
node03 Active Unpinned
[grid@node01 ~]$ crsctl unpin css -n node03
[root@node03 ~]# yum install -y perl-Env
[root@node03 ~]# cd /u01/app/11.2.0.4/grid/crs/install
[root@node03 install]# ./rootcrs.pl -deconfig -force
[root@node01 ~]# /u01/app/11.2.0.4/grid/bin/crsctl delete node -n node03
[grid@node03 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={node03}" CRS=true -local
[grid@node03 ~]$ $ORACLE_HOME/deinstall/deinstall -local
......
Run the following command as the root user or the administrator on node "node03".
/tmp/deinstall2023-08-19_11-30-35AM/perl/bin/perl -I/tmp/deinstall2023-08-19_11-30-35AM/perl/lib -I/tmp/deinstall2023-08-19_11-30-35AM/crs/install /tmp/deinstall2023-08-19_11-30-35AM/crs/install/rootcrs.pl -force -deconfig -paramfile "/tmp/deinstall2023-08-19_11-30-35AM/response/deinstall_Ora11g_gridinfrahome1.rsp"
Press Enter after you finish running the above commands
[root@node03 ~]# /tmp/deinstall2023-08-19_11-30-35AM/perl/bin/perl -I/tmp/deinstall2023-08-19_11-30-35AM/perl/lib -I/tmp/deinstall2023-08-19_11-30-35AM/crs/install /tmp/deinstall2023-08-19_11-30-35AM/crs/install/rootcrs.pl -force -deconfig -paramfile "/tmp/deinstall2023-08-19_11-30-35AM/response/deinstall_Ora11g_gridinfrahome1.rsp"
[root@node03 ~]# rm -rf /etc/oraInst.loc
[root@node03 ~]# rm -rf /opt/ORCLfmap
[root@node03 ~]# rm -rf /etc/oratab
[grid@node01 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={node01,node02}" CRS=true
[grid@node01 ~]$ cluvfy stage -post nodedel -n node03
Performing post-checks for node removal
Checking CRS integrity...
Clusterware version consistency passed
CRS integrity check passed
Node removal check passed
Post-check for node removal was successful.
[grid@node01 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node01
ONLINE ONLINE node02
ora.FRA.dg
ONLINE ONLINE node01
ONLINE ONLINE node02
ora.LISTENER.lsnr
ONLINE ONLINE node01
ONLINE ONLINE node02
ora.OCRVDISK.dg
ONLINE ONLINE node01
ONLINE ONLINE node02
ora.asm
ONLINE ONLINE node01 Started
ONLINE ONLINE node02 Started
ora.gsd
OFFLINE OFFLINE node01
OFFLINE OFFLINE node02
ora.net1.network
ONLINE ONLINE node01
ONLINE ONLINE node02
ora.ons
ONLINE ONLINE node01
ONLINE ONLINE node02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node01
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE node01
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE node02
ora.cvu
1 ONLINE ONLINE node02
ora.oc4j
1 ONLINE ONLINE node02
ora.scan1.vip
1 ONLINE ONLINE node01
ora.scan2.vip
1 ONLINE ONLINE node01
ora.scan3.vip
1 ONLINE ONLINE node02
ora.node.db
2 ONLINE ONLINE node02 Open
3 ONLINE ONLINE node01 Open
ora.node01.vip
1 ONLINE ONLINE node01
ora.node02.vip
1 ONLINE ONLINE node02
