---禁用节点
srvctl disable instance -d mbs -i mbs2

SQL> alter database disable thread 2;

--启用节点

SQL> alter database enable thread 2;

srvctl enable instance -d mbs -i mbs2

------下面进行测试：
1. 禁用节点2的实例mbs2
[oracle@rac01 ~]$ srvctl disable instance -d mbs -i mbs2

[oracle@rac01 ~]$ srvctl stop instance -i mbs2 -d mbs
[oracle@rac01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.mbs.db application ONLINE ONLINE rac01
ora....s1.inst application ONLINE ONLINE rac01
ora....s2.inst application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application ONLINE ONLINE rac01
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip application ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application ONLINE ONLINE rac02
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip application ONLINE ONLINE rac02

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 465 52428800 1 NO CURRENT 15045204 26-APR-14
2 1 463 52428800 1 YES INACTIVE 15024844 26-APR-14
3 2 344 52428800 1 YES INACTIVE 15024846 26-APR-14
4 2 345 52428800 1 YES INACTIVE 15024848 26-APR-14
5 1 464 52428800 1 YES INACTIVE 15024987 26-APR-14
6 2 346 52428800 1 NO CURRENT 15046541 27-APR-14

6 rows selected.

SQL> alter database disable thread 2;

Database altered.

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 465 52428800 1 NO CURRENT 15045204 26-APR-14
2 1 463 52428800 1 YES INACTIVE 15024844 26-APR-14
3 2 344 52428800 1 YES INACTIVE 15024846 26-APR-14
4 2 345 52428800 1 YES INACTIVE 15024848 26-APR-14
5 1 464 52428800 1 YES INACTIVE 15024987 26-APR-14
6 2 346 52428800 1 YES INACTIVE 15046541 27-APR-14

6 rows selected.

--禁用实例后，使用srvctl启动和关闭数据库只针对一个实例操作

[oracle@rac01 ~]$ srvctl stop database -d mbs
[oracle@rac01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.mbs.db application OFFLINE OFFLINE
ora....s1.inst application OFFLINE OFFLINE
ora....s2.inst application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application ONLINE ONLINE rac01
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip application ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application ONLINE ONLINE rac02
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip application ONLINE ONLINE rac02
[oracle@rac01 ~]$ srvctl start database -d mbs
[oracle@rac01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.mbs.db application ONLINE ONLINE rac02
ora....s1.inst application ONLINE ONLINE rac01
ora....s2.inst application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application ONLINE ONLINE rac01
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip application ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application ONLINE ONLINE rac02
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip application ONLINE ONLINE rac02

----------启用节点
SQL> alter database enable thread 2;
Database altered.
SQL> set lines 132 pages 100
SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 465 52428800 1 NO CURRENT 15045204 26-APR-14
2 1 463 52428800 1 YES INACTIVE 15024844 26-APR-14
3 2 347 52428800 1 NO CURRENT 15050115 27-APR-14
4 2 345 52428800 1 YES INACTIVE 15024848 26-APR-14
5 1 464 52428800 1 YES INACTIVE 15024987 26-APR-14
6 2 346 52428800 1 YES INACTIVE 15046541 27-APR-14

6 rows selected.
[oracle@rac01 ~]$ srvctl enable instance -d mbs -i mbs2
[oracle@rac01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.mbs.db application ONLINE ONLINE rac02
ora....s1.inst application ONLINE ONLINE rac01
ora....s2.inst application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application ONLINE ONLINE rac01
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip application ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application ONLINE ONLINE rac02
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip application ONLINE ONLINE rac02
[oracle@rac01 ~]$ srvctl start instance -d mbs -i mbs2
[oracle@rac01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.mbs.db application ONLINE ONLINE rac02
ora....s1.inst application ONLINE ONLINE rac01
ora....s2.inst application ONLINE ONLINE rac02
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application ONLINE ONLINE rac01
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip application ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application ONLINE ONLINE rac02
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip application ONLINE ONLINE rac02

ITPub博客

RAC数据库启用、禁用一个实例

最新文章