RAC集群的启动与关闭

crs_stat -t -v命令的使用

查询当前rac各节点下的asm实例，监听器，globalservice daemon,oracle notification server，vip，数据库实例是否正常！

 

例：

[oracle@rac1 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.orcl.db    application    0/1    0/1    ONLINE    ONLINE    rac2
ora....l1.inst application    0/5    0/0    ONLINE    ONLINE    rac1
ora....l2.inst application    0/5    0/0    ONLINE    ONLINE    rac2
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1
ora....C1.lsnr application    0/5    0/0    OFFLINE   OFFLINE
ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1
ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2
ora....C2.lsnr application    0/5    0/0    OFFLINE   OFFLINE
ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2
ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2

 

srvctl命令的使用

srvctl是servicecontrol的缩写，基本的用法是srvctl <command> <object>[<options>]，使用srvctl命令，可以对rac各个节点的数据库实例，asm实例和监听器等进行管理，挺方便的工具

 

例：

[oracle@rac2 ~]$ srvctl start listener -n rac1
[oracle@rac2 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.orcl.db    application    0/1    0/1    ONLINE    ONLINE    rac2
ora....l1.inst application    0/5    0/0    ONLINE    ONLINE    rac1
ora....l2.inst application    0/5    0/0    ONLINE    ONLINE    rac2
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1
ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2
ora....C2.lsnr application    0/5    0/0    OFFLINE   OFFLINE
ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2
ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2

rac关闭顺序：关闭数据库(实例)-->关闭ASM实例-->关闭节点服务

关闭RAC数据库：

srvctlstop database -d orcl     //orcl为数据库名

 

关闭各节点的ASM实例

srvctl stop asm -n rac1

srvctl stop asm -n rac2

 

关闭各节点的服务包括gsd,ons,vip,lisener 监听器等

srvctl stop nodeapps -nrac1

srvctl stop nodeapps -nrac2

示例：

[oracle@rac2 ~]$ srvctl stop database -d orcl
[oracle@rac2 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.orcl.db    application    0/1    0/1    OFFLINE   OFFLINE
ora....l1.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....l2.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1
ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2
ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2
[oracle@rac2 ~]$ srvctl stop asm -n rac1
[oracle@rac2 ~]$ srvctl stop asm -n rac2
[oracle@rac2 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.orcl.db    application    0/1    0/1    OFFLINE   OFFLINE
ora....l1.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....l2.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....SM1.asm application    0/5    0/0    OFFLINE   OFFLINE
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1
ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1
ora....SM2.asm application    0/5    0/0    OFFLINE   OFFLINE
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2
ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2
[oracle@rac2 ~]$ srvctl stop nodeapps -n rac1
[oracle@rac2 ~]$ srvctl stop nodeapps -n rac2
[oracle@rac2 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.orcl.db    application    0/1    0/1    OFFLINE   OFFLINE
ora....l1.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....l2.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....SM1.asm application    0/5    0/0    OFFLINE   OFFLINE
ora....C1.lsnr application    0/5    0/0    OFFLINE   OFFLINE
ora.rac1.gsd   application    0/5    0/0    OFFLINE   OFFLINE
ora.rac1.ons   application    0/3    0/0    OFFLINE   OFFLINE
ora.rac1.vip   application    0/0    0/0    OFFLINE   OFFLINE
ora....SM2.asm application    0/5    0/0    OFFLINE   OFFLINE
ora....C2.lsnr application    0/5    0/0    OFFLINE   OFFLINE
ora.rac2.gsd   application    0/5    0/0    OFFLINE   OFFLINE
ora.rac2.ons   application    0/3    0/0    OFFLINE   OFFLINE
ora.rac2.vip   application    0/0    0/0    OFFLINE   OFFLINE

反之为开启：启动节点服务-->启动ASM实例-->启动数据库实例

 

开启各节点的服务包括gsd,ons,vip,lisener 监听器等

srvctl start nodeapps -nrac1

srvctl start nodeapps -nrac2

 

开启各节点的ASM实例

srvctl start asm -n rac1

srvctl start asm -n rac2

 

开启RAC数据库：

srvctlstart database -d orcl

 

srvctl start instance -d orcl -i orcl1 -o mount

srvctl start instance -d orcl -i orcl2 -o open

示例：

[oracle@rac1 ~]$ srvctl start nodeapps -n rac1
[oracle@rac1 ~]$ srvctl start nodeapps -n rac2
[oracle@rac1 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.orcl.db    application    0/1    0/1    OFFLINE   OFFLINE
ora....l1.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....l2.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....SM1.asm application    0/5    0/0    OFFLINE   OFFLINE
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1
ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1
ora....SM2.asm application    0/5    0/0    OFFLINE   OFFLINE
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2
ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2
[oracle@rac1 ~]$ srvctl start asm -n rac1
[oracle@rac1 ~]$ srvctl start asm -n rac2
[oracle@rac1 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.orcl.db    application    0/1    0/1    OFFLINE   OFFLINE
ora....l1.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....l2.inst application    0/5    0/0    OFFLINE   OFFLINE
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1
ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2
ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2
[oracle@rac1 ~]$ srvctl start database -d orcl
[oracle@rac1 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.orcl.db    application    0/1    0/1    ONLINE    ONLINE    rac1
ora....l1.inst application    0/5    0/0    ONLINE    ONLINE    rac1
ora....l2.inst application    0/5    0/0    ONLINE    ONLINE    rac2
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1
ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2
ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 1 21:55:31 2018

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> select open_mode,name  from v$database;

OPEN_MODE  NAME
---------- ---------
READ WRITE ORCL