rac启动与关闭.doc

rac启动与关闭和学操作系统一样，安装完RAC集群后，第一件事就是就是要学习如何启动和关闭，启动和关闭rac一般使用三种方式:sqlplus,srvctl以及dbconsole或者Oracle grid control,本节中简要介绍下使用srvctl启动和关闭rac数据库集群！ 使用crs_stat命令可以查询当前rac各节点下的asm实例，监听器，global service daemon,Oracle notification server，vip，数据库实例是否正常！ C:UsersAdministrator crs_stat -t -vName Type R/RA F/FT Target State Host -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 ora.racdb.db application 0/1 0/1 ONLINE ONLINE rac1 ora.b1.inst application 0/5 0/0 ONLINE ONLINE rac1 ora.b2.inst application 0/5 0/0 ONLINE ONLINE rac2 srvctl命令的使用srvctl是service control的缩写，基本的用法是srvctl ，使用srvctl命令，可以对rac各个节点的数据库实例，asm实例和监听器等进行管理，挺方便的工具 C:UsersAdministrator srvctl Usage: srvctl command: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config objects: database|instance|service|nodeapps|asm|listenerFor detailed help on each command and object and its options use: srvctl -h 获取更详细的帮助C:UsersAdministrator srvctl start asm -hUsage: srvctl start asm -n -i -o -c | -q -n Node name -i ASM instance name -o Options to startup command (e.g. open, mount, or nomount) -c Connect string (default: / as sysdba) -q Query connect string from standard input -h Print usage 关闭rac数据库 C:UsersAdministrator srvctl stop database -d racdb C:UsersAdministrator crs_stat -t -vName Type R/RA F/FT Target State Host -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 ora.racdb.db application 0/1 0/1 OFFLINE OFFLINE ora.b1.inst application 0/5 0/0 OFFLINE OFFLINE ora.b2.inst application 0/5 0/0 OFFLINE OFFLINE 关闭各节点的asm实例 C:UsersAdministrator srvctl stop asm -n rac1 C:UsersAdministrator srvctl stop asm -n rac2C:UsersAdministrator crs_stat -t -vName Type R/RA F/FT Target State Host -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 ora.racdb.db application 0/1 0/1 OFFLINE OFFLINE ora.b1.inst application 0/5 0/0 OFFLINE OFFLINE ora.b2.inst application 0/5 0/0 OFFLINE OFFLINE 关闭各节点的服务，包括gsd,ons，vip以及监听器 C:UsersAdministrator srvctl stop nodeapps -n rac1C:UsersAdministrator srvctl stop nodeapps -n rac2C:UsersAdministrator crs_stat -t -vName Type R/RA F/FT Target State Host -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 ora.racdb.db application 0/1 0/1 OFFLINE OFFLINE ora.b1.inst application 0/5 0/0 OFFLINE OFFLINE ora.b2.inst application 0/5 0/0 OFFLINE OFFLINE rac数据的关闭顺序是：1、关闭集群数据库实例2、关闭各节点ASM实例3、关闭各节点服务启动的顺序则相反！ C:UsersAdministrator srvctl start nodeapps -n rac1C:UsersAdministrator srvctl start nodeapps -n rac2C:UsersAdministrator srvctl start asm -n rac1C:UsersAdministrator srvctl start asm -n rac2C:UsersAdministrator srvctl start instance -d racdb -i racdb1 -o mountC:UsersAdministrator srvctl start instance -d racdb -i racdb2 -o open C:UsersAdministrator sqlplus sys/123456racdb1 as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 26 12:15:57 2011Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL select open_mode,name from v$database; OPEN_MODE NAME- -MOUNTED RACDB SQL conn sys/123456racdb2 as sysdbaConnected.SQL select open_mode,name from v$database; OPEN_MODE NAME- -READ WRITE RACDB 关闭rac节点中的某个实例 C:UsersAdministrator srvctl stop instance -d racdb -i racdb1 -o immediateC:UsersAdministrator srvctl stop asm -n rac1C:UsersAdministrator srvctl stop nodeapps -n rac1C:UsersAdministrator crs_stat -t -vName Type R/RA F/FT Target State Host -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 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 ora.racdb.db application 0/1 0/1 ONLINE ONLINE rac2 ora.b1.inst application 0/5 0/0 OFFLINE OFFLINE ora.b2.inst application 0/5 0/0 ONLINE ONLINE rac2 禁止asm实例和数据库实例自启动 C:UsersAdministrator srvctl disable asm -n rac1C:UsersAdministrator srvctl disable asm -n rac2C:UsersAdministrator srvctl disable database -d racdbC:UsersAdministrator uptime 21:46:45 up 2 min, 1 user, load average: 2.03, 0.78, 0.28C:UsersAdministrator crs_stat -t -vName Type R/RA F/FT Target State Host -ora.SM1.asm application 0/5 0/0 ONLINE OF