oracle 11gr2 删除节点最佳实践
oracle 11gr2 添加节点最佳实践可参见我的博文:
http://space.itpub.net/26143577/viewspace-742169
OS信息:
[grid@11grac1 ~]$ uname -a
Linux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/Linux
DB信息:
SQL> select * from v$version where rownum<5;
OS信息:
[grid@11grac1 ~]$ uname -a
Linux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/Linux
DB信息:
SQL> select * from v$version where rownum<5;
BANNER
------------------------------------------------------------------------
------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
查看当前资源状态
[grid@11grac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE 11grac1
ora....C1.lsnr application ONLINE ONLINE 11grac1
ora....ac1.gsd application ONLINE ONLINE 11grac1
ora....ac1.ons application ONLINE ONLINE 11grac1
ora....ac1.vip ora....t1.type ONLINE ONLINE 11grac1
ora....SM2.asm application ONLINE ONLINE 11grac2
ora....C2.lsnr application ONLINE ONLINE 11grac2
ora....ac2.gsd application ONLINE ONLINE 11grac2
ora....ac2.ons application ONLINE ONLINE 11grac2
ora....ac2.vip ora....t1.type ONLINE ONLINE 11grac2
ora.DATA.dg ora....up.type ONLINE ONLINE 11grac1
ora....ER.lsnr ora....er.type ONLINE ONLINE 11grac1
ora....N1.lsnr ora....er.type ONLINE ONLINE 11grac1
ora.asm ora.asm.type ONLINE ONLINE 11grac1
ora.eons ora.eons.type ONLINE ONLINE 11grac1
ora.gsd ora.gsd.type ONLINE ONLINE 11grac1
ora....network ora....rk.type ONLINE ONLINE 11grac1
ora.oc4j ora.oc4j.type ONLINE ONLINE 11grac1
ora.ons ora.ons.type ONLINE ONLINE 11grac1
ora.racdb.db ora....se.type ONLINE ONLINE 11grac1
ora.scan1.vip ora....ip.type ONLINE ONLINE 11grac1
[grid@11grac1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node 11grac1
Instance racdb2 is running on node 11grac2
[grid@11grac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE 11grac1
ora....C1.lsnr application ONLINE ONLINE 11grac1
ora....ac1.gsd application ONLINE ONLINE 11grac1
ora....ac1.ons application ONLINE ONLINE 11grac1
ora....ac1.vip ora....t1.type ONLINE ONLINE 11grac1
ora....SM2.asm application ONLINE ONLINE 11grac2
ora....C2.lsnr application ONLINE ONLINE 11grac2
ora....ac2.gsd application ONLINE ONLINE 11grac2
ora....ac2.ons application ONLINE ONLINE 11grac2
ora....ac2.vip ora....t1.type ONLINE ONLINE 11grac2
ora.DATA.dg ora....up.type ONLINE ONLINE 11grac1
ora....ER.lsnr ora....er.type ONLINE ONLINE 11grac1
ora....N1.lsnr ora....er.type ONLINE ONLINE 11grac1
ora.asm ora.asm.type ONLINE ONLINE 11grac1
ora.eons ora.eons.type ONLINE ONLINE 11grac1
ora.gsd ora.gsd.type ONLINE ONLINE 11grac1
ora....network ora....rk.type ONLINE ONLINE 11grac1
ora.oc4j ora.oc4j.type ONLINE ONLINE 11grac1
ora.ons ora.ons.type ONLINE ONLINE 11grac1
ora.racdb.db ora....se.type ONLINE ONLINE 11grac1
ora.scan1.vip ora....ip.type ONLINE ONLINE 11grac1
[grid@11grac1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node 11grac1
Instance racdb2 is running on node 11grac2
写入测试数据
[oracle@11grac1 ~]$ sqlplus /nolog
[oracle@11grac1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 29 10:02:08 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> sho user
USER is "SYS"
SQL> create table test (id number,name varchar2(10));
Connected.
SQL> sho user
USER is "SYS"
SQL> create table test (id number,name varchar2(10));
Table created.
SQL> insert into test values (1,'yallonking');
SQL> insert into test values (1,'yallonking');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test;
ID NAME
---------- ----------
1 yallonking
---------- ----------
1 yallonking
删除节点实例(可用DBCA,也可用后边的命令静默删除)
运行dbca,根据向导删除相关信息
instance management-> delete an instance-> 输入sysdba用户的账户和密码-> 选定删除的节点实例
[oracle@11grac1 ~]$ export DISPLAY=192.168.137.1:0.0
[oracle@11grac1 ~]$ dbca
运行dbca,根据向导删除相关信息
instance management-> delete an instance-> 输入sysdba用户的账户和密码-> 选定删除的节点实例
[oracle@11grac1 ~]$ export DISPLAY=192.168.137.1:0.0
[oracle@11grac1 ~]$ dbca
查看数据库状态
[grid@11grac1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node 11grac1
[grid@11grac1 ~]$ crsctl check cluster -all
**************************************************************
11grac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
11grac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@11grac1 ~]$
[grid@11grac1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node 11grac1
[grid@11grac1 ~]$ crsctl check cluster -all
**************************************************************
11grac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
11grac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@11grac1 ~]$
删除EM
[oracle@11grac1 ~]$ emca -deconfig dbcontrol db -repos drop -cluster
[oracle@11grac1 ~]$ emca -deconfig dbcontrol db -repos drop -cluster
STARTED EMCA at Aug 29, 2012 10:29:12 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database unique name: racdb
Service name: racdb
Listener port number: 1521
Listener ORACLE_HOME [ /u01/11.2.0/grid ]:
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Aug 29, 2012 10:29:35 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2012_08_29_10_29_11.log.
Aug 29, 2012 10:29:36 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Aug 29, 2012 10:29:45 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Aug 29, 2012 10:29:45 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 29, 2012 10:43:38 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 29, 2012 10:43:38 AM
[oracle@11grac1 ~]$
Database unique name: racdb
Service name: racdb
Listener port number: 1521
Listener ORACLE_HOME [ /u01/11.2.0/grid ]:
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Aug 29, 2012 10:29:35 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2012_08_29_10_29_11.log.
Aug 29, 2012 10:29:36 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Aug 29, 2012 10:29:45 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Aug 29, 2012 10:29:45 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 29, 2012 10:43:38 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 29, 2012 10:43:38 AM
[oracle@11grac1 ~]$
备份OCR
[root@11grac1 ~]# /u01/11.2.0/grid/bin/ocrconfig -manualbackup
[root@11grac1 ~]# /u01/11.2.0/grid/bin/ocrconfig -manualbackup
11grac1 2012/08/29 10:47:33 /u01/11.2.0/grid/cdata/racscan/backup_20120829_104733.ocr
[root@11grac1 ~]#
[root@11grac1 ~]#
删除实例(静默状态下)
[oracle@11grac1 ~]$ dbca -silent -deleteinstance -nodelist 11grac2 -gdbname racdb -instancename racdb2 -sysdbausername sys -sysdbapassword oracle
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/racdb.log" for further details.
[oracle@11grac1 ~]$ dbca -silent -deleteinstance -nodelist 11grac2 -gdbname racdb -instancename racdb2 -sysdbausername sys -sysdbapassword oracle
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/racdb.log" for further details.
查看数据库配置信息
[oracle@11grac1 ~]$ srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1
Disk Groups: DATA
Services:
Database is administrator managed
[oracle@11grac1 ~]$ srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1
Disk Groups: DATA
Services:
Database is administrator managed
查看数据库实例和redo情况
[oracle@11grac1 ~]$ sqlplus /nolog
[oracle@11grac1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 29 10:51:31 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> select inst_id,instance_name from gv$instance;
Connected.
SQL> select inst_id,instance_name from gv$instance;
INST_ID INSTANCE_NAME
---------- ----------------
1 racdb1
---------- ----------------
1 racdb1
SQL> select group#,thread# from v$log;
GROUP# THREAD#
---------- ----------
1 1
2 1
---------- ----------
1 1
2 1
查看节点监听配置信息
[oracle@11grac2 ~]$ srvctl config listener -a
Name: LISTENER
Network: 1, Owner: grid
Home:
/u01/11.2.0/grid on node(s) 11grac2,11grac1
End points: TCP:1521
更新oracle inventory
[oracle@11grac2 db_1]$ /u01/app/oracle/product/11.2.0/db_1/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={11grac2}" -local
Starting Oracle Universal Installer...
[oracle@11grac2 db_1]$ /u01/app/oracle/product/11.2.0/db_1/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={11grac2}" -local
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 4094 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
删除oracle软件
[oracle@11grac2 db_1]$ cd $ORACLE_HOME/deinstall
[oracle@11grac2 deinstall]$ ./deinstall -local
Checking for required files and bootstrapping ...
Please wait ...
[oracle@11grac2 db_1]$ cd $ORACLE_HOME/deinstall
[oracle@11grac2 deinstall]$ ./deinstall -local
Checking for required files and bootstrapping ...
Please wait ...
更新oracle inventory
[oracle@11grac1 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updatenodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={11grac1}"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 3854 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
查看节点状态
[root@11grac1 ~]# /u01/11.2.0/grid/bin/olsnodes -s -t
11grac1 Active Unpinned
11grac2 Active Unpinned
禁用节点cluster
[root@11grac2 ~]# cd /u01/11.2.0/grid/crs/install/
[root@11grac2 install]# ./rootcrs.pl -deconfig -force
2012-08-29 11:06:54: Parsing the host name
2012-08-29 11:06:54: Checking for super user privileges
2012-08-29 11:06:54: User has super user privileges
Using configuration parameter file: ./crsconfig_params
VIP exists.:11grac1
VIP exists.: /11grac1-vip/192.168.137.163/255.255.255.0/eth0
VIP exists.:11grac2
VIP exists.: /11grac2-vip/192.168.137.164/255.255.255.0/eth0
GSD exists.
ONS daemon exists. Local port 6100, remote port 6200
eONS daemon exists. Multicast port 18611, multicast IP address 234.228.184.247, listening port 2016
ADVM/ACFS is not supported on oraclelinux-release-5-8.0.2
[root@11grac2 ~]# cd /u01/11.2.0/grid/crs/install/
[root@11grac2 install]# ./rootcrs.pl -deconfig -force
2012-08-29 11:06:54: Parsing the host name
2012-08-29 11:06:54: Checking for super user privileges
2012-08-29 11:06:54: User has super user privileges
Using configuration parameter file: ./crsconfig_params
VIP exists.:11grac1
VIP exists.: /11grac1-vip/192.168.137.163/255.255.255.0/eth0
VIP exists.:11grac2
VIP exists.: /11grac2-vip/192.168.137.164/255.255.255.0/eth0
GSD exists.
ONS daemon exists. Local port 6100, remote port 6200
eONS daemon exists. Multicast port 18611, multicast IP address 234.228.184.247, listening port 2016
ADVM/ACFS is not supported on oraclelinux-release-5-8.0.2
ACFS-9201: Not Supported
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '11grac2'
CRS-2673: Attempting to stop 'ora.crsd' on '11grac2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on '11grac2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on '11grac2'
CRS-2677: Stop of 'ora.DATA.dg' on '11grac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on '11grac2'
CRS-2677: Stop of 'ora.asm' on '11grac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on '11grac2' has completed
CRS-2677: Stop of 'ora.crsd' on '11grac2' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on '11grac2'
CRS-2673: Attempting to stop 'ora.gpnpd' on '11grac2'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on '11grac2'
CRS-2673: Attempting to stop 'ora.ctssd' on '11grac2'
CRS-2673: Attempting to stop 'ora.evmd' on '11grac2'
CRS-2673: Attempting to stop 'ora.asm' on '11grac2'
CRS-2677: Stop of 'ora.cssdmonitor' on '11grac2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on '11grac2' succeeded
CRS-2677: Stop of 'ora.gpnpd' on '11grac2' succeeded
CRS-2677: Stop of 'ora.evmd' on '11grac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on '11grac2' succeeded
CRS-2675: Stop of 'ora.asm' on '11grac2' failed
CRS-2679: Attempting to clean 'ora.asm' on '11grac2'
ORA-01089: immediate shutdown in progress - no operations are permitted
Process ID: 0
Session ID: 0 Serial number: 0
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '11grac2'
CRS-2673: Attempting to stop 'ora.crsd' on '11grac2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on '11grac2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on '11grac2'
CRS-2677: Stop of 'ora.DATA.dg' on '11grac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on '11grac2'
CRS-2677: Stop of 'ora.asm' on '11grac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on '11grac2' has completed
CRS-2677: Stop of 'ora.crsd' on '11grac2' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on '11grac2'
CRS-2673: Attempting to stop 'ora.gpnpd' on '11grac2'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on '11grac2'
CRS-2673: Attempting to stop 'ora.ctssd' on '11grac2'
CRS-2673: Attempting to stop 'ora.evmd' on '11grac2'
CRS-2673: Attempting to stop 'ora.asm' on '11grac2'
CRS-2677: Stop of 'ora.cssdmonitor' on '11grac2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on '11grac2' succeeded
CRS-2677: Stop of 'ora.gpnpd' on '11grac2' succeeded
CRS-2677: Stop of 'ora.evmd' on '11grac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on '11grac2' succeeded
CRS-2675: Stop of 'ora.asm' on '11grac2' failed
CRS-2679: Attempting to clean 'ora.asm' on '11grac2'
ORA-01089: immediate shutdown in progress - no operations are permitted
Process ID: 0
Session ID: 0 Serial number: 0
CRS-2681: Clean of 'ora.asm' on '11grac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on '11grac2'
CRS-2677: Stop of 'ora.cssd' on '11grac2' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on '11grac2'
CRS-2673: Attempting to stop 'ora.gipcd' on '11grac2'
CRS-2677: Stop of 'ora.gipcd' on '11grac2' succeeded
CRS-2677: Stop of 'ora.diskmon' on '11grac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on '11grac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully deconfigured Oracle clusterware stack on this node
[root@11grac2 install]#
CRS-2673: Attempting to stop 'ora.cssd' on '11grac2'
CRS-2677: Stop of 'ora.cssd' on '11grac2' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on '11grac2'
CRS-2673: Attempting to stop 'ora.gipcd' on '11grac2'
CRS-2677: Stop of 'ora.gipcd' on '11grac2' succeeded
CRS-2677: Stop of 'ora.diskmon' on '11grac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on '11grac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully deconfigured Oracle clusterware stack on this node
[root@11grac2 install]#
查看节点状态
[grid@11grac1 ~]$ olsnodes -s -t
11grac1 Active Unpinned
11grac2 Inactive Unpinned
删除节点
[root@11grac1 ~]# /u01/11.2.0/grid/bin/crsctl delete node -n 11grac2
CRS-4661: Node 11grac2 successfully deleted.
[root@11grac1 ~]# /u01/11.2.0/grid/bin/crsctl delete node -n 11grac2
CRS-4661: Node 11grac2 successfully deleted.
查看节点状态
[root@11grac1 ~]# /u01/11.2.0/grid/bin/olsnodes -s -t
11grac1 Active Unpinned
[root@11grac1 ~]# /u01/11.2.0/grid/bin/olsnodes -s -t
11grac1 Active Unpinned
更新oracle inventory
[grid@11grac2 bin]$ pwd
/u01/11.2.0/grid/oui/bin
[grid@11grac2 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={11grac2}" CRS=TRUE -local
Starting Oracle Universal Installer...
[grid@11grac2 bin]$ pwd
/u01/11.2.0/grid/oui/bin
[grid@11grac2 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={11grac2}" CRS=TRUE -local
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 4094 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
删除GI软件
[grid@11grac2 deinstall]$ pwd
/u01/11.2.0/grid/deinstall
[grid@11grac2 deinstall]$ ./deinstall -local
Checking for required files and bootstrapping ...
Please wait ...
[grid@11grac2 deinstall]$ pwd
/u01/11.2.0/grid/deinstall
[grid@11grac2 deinstall]$ ./deinstall -local
Checking for required files and bootstrapping ...
Please wait ...
删除相关目录
[root@11grac2 install]# rm -rf /etc/oraInst.loc
[root@11grac2 install]# rm -rf /opt/ORCLfmap/
[root@11grac2 install]# rm -rf /u01
[root@11grac2 install]# rm -rf /etc/oraInst.loc
[root@11grac2 install]# rm -rf /opt/ORCLfmap/
[root@11grac2 install]# rm -rf /u01
更新oracle inventory
[grid@11grac1 bin]$ pwd
/u01/11.2.0/grid/oui/bin
[grid@11grac1 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={11grac1}" CRS=TRUE
Starting Oracle Universal Installer...
[grid@11grac1 bin]$ pwd
/u01/11.2.0/grid/oui/bin
[grid@11grac1 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={11grac1}" CRS=TRUE
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 3826 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
删除后的验证
[grid@11grac1 bin]$ cluvfy stage -post nodedel -n 11grac2 -verbose
[grid@11grac1 bin]$ cluvfy stage -post nodedel -n 11grac2 -verbose
Performing post-checks for node removal
Checking CRS integrity...
The Oracle clusterware is healthy on node "11grac1"
The Oracle clusterware is healthy on node "11grac1"
CRS integrity check passed
Result:
Node removal check passed
Post-check for node removal was successful.
查看节点资源信息
[grid@11grac1 ~]$ crsctl check cluster -all
**************************************************************
11grac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@11grac1 ~]$ crsctl check cluster -all
**************************************************************
11grac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@11grac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE 11grac1
ora....C1.lsnr application ONLINE ONLINE 11grac1
ora....ac1.gsd application ONLINE ONLINE 11grac1
ora....ac1.ons application ONLINE ONLINE 11grac1
ora....ac1.vip ora....t1.type ONLINE ONLINE 11grac1
ora.DATA.dg ora....up.type ONLINE ONLINE 11grac1
ora....ER.lsnr ora....er.type ONLINE ONLINE 11grac1
ora....N1.lsnr ora....er.type ONLINE ONLINE 11grac1
ora.asm ora.asm.type ONLINE ONLINE 11grac1
ora.eons ora.eons.type ONLINE ONLINE 11grac1
ora.gsd ora.gsd.type ONLINE ONLINE 11grac1
ora....network ora....rk.type ONLINE ONLINE 11grac1
ora.oc4j ora.oc4j.type ONLINE ONLINE 11grac1
ora.ons ora.ons.type ONLINE ONLINE 11grac1
ora.racdb.db ora....se.type ONLINE ONLINE 11grac1
ora.scan1.vip ora....ip.type ONLINE ONLINE 11grac1
[grid@11grac1 ~]$
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE 11grac1
ora....C1.lsnr application ONLINE ONLINE 11grac1
ora....ac1.gsd application ONLINE ONLINE 11grac1
ora....ac1.ons application ONLINE ONLINE 11grac1
ora....ac1.vip ora....t1.type ONLINE ONLINE 11grac1
ora.DATA.dg ora....up.type ONLINE ONLINE 11grac1
ora....ER.lsnr ora....er.type ONLINE ONLINE 11grac1
ora....N1.lsnr ora....er.type ONLINE ONLINE 11grac1
ora.asm ora.asm.type ONLINE ONLINE 11grac1
ora.eons ora.eons.type ONLINE ONLINE 11grac1
ora.gsd ora.gsd.type ONLINE ONLINE 11grac1
ora....network ora....rk.type ONLINE ONLINE 11grac1
ora.oc4j ora.oc4j.type ONLINE ONLINE 11grac1
ora.ons ora.ons.type ONLINE ONLINE 11grac1
ora.racdb.db ora....se.type ONLINE ONLINE 11grac1
ora.scan1.vip ora....ip.type ONLINE ONLINE 11grac1
[grid@11grac1 ~]$
验证测试数据
Microsoft Windows [版本 6.1.7600]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\YallonKing>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期三 8月 29 12:29:43 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn
sys/oracle@racdb_11g as sysdba
已连接。
已连接。
SQL> select instance_name from gv$instance;
INSTANCE_NAME
--------------------------------
racdb1
--------------------------------
racdb1
SQL> select * from test;
ID NAME
---------- --------------------
1 yallonking
---------- --------------------
1 yallonking
剩下的就是删除被删除节点的GI和ORACLE相关文件、用户、组、裸设备、网络设置等信息。
至此,OK!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26143577/viewspace-742170/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26143577/viewspace-742170/