============================================================
Oracle DataBase 10G RAC 学习笔记
OracleRAC管理 之 集群启动&关闭
--by 王磊2010-5-27 11:34
============================================================
RAC自动启动配置
默认安装玩CRS会在/etc/inittab文件中添加如下启动项:
h1:35:respawn:/etc/init.d/init.evmd run >/dev/null 2>&1
h2:35:respawn:/etc/init.d/init.cssd fatal >/dev/null 2>&1
h3:35:respawn:/etc/init.d/init.crsd run >/dev/null 2>&1
RAC启动顺序
节点应用【nodeapps】-->ASM实例-->生产实例-->服务
oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application OFFLINE OFFLINE
ora.node1.gsd application OFFLINE OFFLINE
ora.node1.ons application OFFLINE OFFLINE
ora.node1.vip application OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....E2.lsnr application OFFLINE OFFLINE
ora.node2.gsd application OFFLINE OFFLINE
ora.node2.ons application OFFLINE OFFLINE
ora.node2.vip application OFFLINE OFFLINE
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl startnodeapps-n node1
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application OFFLINE OFFLINE
ora....E2.lsnr application OFFLINE OFFLINE
ora.node2.gsd application OFFLINE OFFLINE
ora.node2.ons application OFFLINE OFFLINE
ora.node2.vip application OFFLINE OFFLINE
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl startnodeapps-n node2
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application OFFLINE OFFLINE
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl startasm-n node2
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl startasm-n node1
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl startinstance-d dba -i null1,null2
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application ONLINE ONLINE node1
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application ONLINE ONLINE node1
ora....l2.inst application ONLINE ONLINE node2
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl startservice-d dba
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application ONLINE ONLINE node1
ora....name.cs application ONLINE ONLINE node2
ora....ll1.srv application ONLINE ONLINE node1
ora....ll2.srv application ONLINE ONLINE node2
ora....l1.inst application ONLINE ONLINE node1
ora....l2.inst application ONLINE ONLINE node2
ora.dba.rac.cs application ONLINE ONLINE node2
ora....ll1.srv application ONLINE ONLINE node1
ora....ll2.srv application ONLINE ONLINE node2
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
RAC停止顺序
服务-->生产实例-->ASM实例-->节点应用【nodeapps】
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application ONLINE ONLINE node1
ora....name.cs application ONLINE ONLINE node2
ora....ll1.srv application ONLINE ONLINE node1
ora....ll2.srv application ONLINE ONLINE node2
ora....l1.inst application ONLINE ONLINE node1
ora....l2.inst application ONLINE ONLINE node2
ora.dba.rac.cs application ONLINE ONLINE node2
ora....ll1.srv application ONLINE ONLINE node1
ora....ll2.srv application ONLINE ONLINE node2
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl stopservice-d dba
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application ONLINE ONLINE node1
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application ONLINE ONLINE node1
ora....l2.inst application ONLINE ONLINE node2
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl stopinstance-d dba -i null1,null2
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl stopasm-n node1
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl stopasm-n node2
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application OFFLINE OFFLINE
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl stopnodeapps-n node1
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application OFFLINE OFFLINE
ora.node1.gsd application OFFLINE OFFLINE
ora.node1.ons application OFFLINE OFFLINE
ora.node1.vip application OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1 ~]$
[oracle@node1 ~]$srvctl stopnodeapps-n node2
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application OFFLINE OFFLINE
ora....name.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora.dba.rac.cs application OFFLINE OFFLINE
ora....ll1.srv application OFFLINE OFFLINE
ora....ll2.srv application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application OFFLINE OFFLINE
ora.node1.gsd application OFFLINE OFFLINE
ora.node1.ons application OFFLINE OFFLINE
ora.node1.vip application OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....E2.lsnr application OFFLINE OFFLINE
ora.node2.gsd application OFFLINE OFFLINE
ora.node2.ons application OFFLINE OFFLINE
ora.node2.vip application OFFLINE OFFLINE