Oracle RAC日常管理命令(五)
2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
此时已经不能连接到数据库了
（3）当我们忘了命令语法的时候，直接srvctl就可以查看帮助信息了
RACDB1@rac1 /home/oracle$ srvctl stop asm
PRKO-2001 : Invalid command line syntax
RACDB1@rac1 /home/oracle$ srvctl
Usage: srvctl
command: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config
objects: database|instance|service|nodeapps|asm|listener
For detailed help on each command and object and its options use:
srvctl
可以使用-h选项打开帮助信息
RACDB1@rac1 /home/oracle$ srvctl start asm -h
Usage: 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
先关闭节点2的ASM实例
RACDB2@rac2 /home/oracle$ srvctl stop asm -n rac2
RACDB2@rac2 /home/oracle$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application OFFLINE OFFLINE
ora....B2.inst application OFFLINE OFFLINE
ora....DB1.srv application OFFLINE OFFLINE
ora.....TAF.cs application OFFLINE OFFLINE
ora.RACDB.db application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1节点1的ASM实例还在启动
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application OFFLINE OFFLINE节点2的ASM实例已经关闭
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
再关闭节点1的ASM实例
RACDB1@rac1 /home/oracle$ srvctl stop asm -n rac1
RACDB1@rac1 /home/oracle$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application OFFLINE OFFLINE
ora....B2.inst application OFFLINE OFFLINE
ora....DB1.srv application OFFLINE OFFLINE
ora.....TAF.cs application OFFLINE OFFLINE
ora.RACDB.db application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
我们在把ASM数据库 实例启动起来，操作的顺序是相反的
（4）先启动ASM
在节点1和节点2分别启动ASM
RACDB1@rac1 /home/oracle$ srvctl start asm -n rac1
RACDB2@rac2 /home/oracle$ srvctl start asm -n rac2
RACDB2@rac2 /home/oracle$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application OFFLINE OFFLINE
ora....B2.inst application OFFLINE OFFLINE
ora....DB1.srv application OFFLINE OFFLINE
ora.....TAF.cs application OFFLINE OFFLINE
ora.RACDB.db application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application