Oracle 10g RAC 删除节点

程序员文章站 2024-01-22 10:36:58

...

如何添加节点Oracle 10g RAC 添加节点 http://www.linuxidc.com/Linux/2012-12/76786.htm 目前RAC环境如下,先要删除racdb3 SQLg

如何添加节点Oracle 10g RAC 添加节点

目前RAC环境如下,先要删除racdb3

SQL> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ACTIVE_STATE,INSTANCE_ROLE,DATABASE_STATUS from gv$INSTANCE;

INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS ACTIVE_ST INSTANCE_ROLE DATABASE_STATUS
---------------- ---------- ----------------- ----------------------- ------------ --------- ------------------ -----------------
racdb1 racnode1 10.2.0.5.0 27-DEC-2012 14:52:55 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
racdb3 racnode3 10.2.0.5.0 27-DEC-2012 15:21:09 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
racdb2 racnode2 10.2.0.5.0 27-DEC-2012 15:19:52 OPEN NORMAL PRIMARY_INSTANCE ACTIVE

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@racnode1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.racdb.db application ONLINE ONLINE racnode2
ora....b1.inst application ONLINE ONLINE racnode1
ora....b2.inst application ONLINE ONLINE racnode2
ora....b3.inst application ONLINE ONLINE racnode3
ora.....zwc.cs application ONLINE ONLINE racnode1
ora....db1.srv application ONLINE ONLINE racnode1
ora....SM1.asm application ONLINE ONLINE racnode1
ora....E1.lsnr application ONLINE ONLINE racnode1
ora....de1.gsd application ONLINE ONLINE racnode1
ora....de1.ons application ONLINE ONLINE racnode1
ora....de1.vip application ONLINE ONLINE racnode1
ora....SM2.asm application ONLINE ONLINE racnode2
ora....E2.lsnr application ONLINE ONLINE racnode2
ora....de2.gsd application ONLINE ONLINE racnode2
ora....de2.ons application ONLINE ONLINE racnode2
ora....de2.vip application ONLINE ONLINE racnode2
ora....SM3.asm application ONLINE ONLINE racnode3
ora....E3.lsnr application ONLINE ONLINE racnode3
ora....de3.gsd application ONLINE ONLINE racnode3
ora....de3.ons application ONLINE ONLINE racnode3
ora....de3.vip application ONLINE ONLINE racnode3

停止racdb3的instance

[oracle@racnode1 ~]$ srvctl stop instance -d racdb -i racdb3
[oracle@racnode1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.racdb.db application ONLINE ONLINE racnode2
ora....b1.inst application ONLINE ONLINE racnode1
ora....b2.inst application ONLINE ONLINE racnode2
ora....b3.inst application OFFLINE OFFLINE
ora.....zwc.cs application ONLINE ONLINE racnode1
ora....db1.srv application ONLINE ONLINE racnode1
ora....SM1.asm application ONLINE ONLINE racnode1
ora....E1.lsnr application ONLINE ONLINE racnode1
ora....de1.gsd application ONLINE ONLINE racnode1
ora....de1.ons application ONLINE ONLINE racnode1
ora....de1.vip application ONLINE ONLINE racnode1
ora....SM2.asm application ONLINE ONLINE racnode2
ora....E2.lsnr application ONLINE ONLINE racnode2
ora....de2.gsd application ONLINE ONLINE racnode2
ora....de2.ons application ONLINE ONLINE racnode2
ora....de2.vip application ONLINE ONLINE racnode2
ora....SM3.asm application ONLINE ONLINE racnode3
ora....E3.lsnr application ONLINE ONLINE racnode3
ora....de3.gsd application ONLINE ONLINE racnode3
ora....de3.ons application ONLINE ONLINE racnode3
ora....de3.vip application ONLINE ONLINE racnode3