srvctl stop database 是以哪种方式关闭的数据库？

ricky_zhu · 发表于 2008-12-29 19:54

原帖由 owlstudio 于 2008-12-29 14:30 发表
shahand：有联机手册吗？能给个链接吗？

不相信的可以自己测试一下啊

另外，srvctl stop nodeapps -n rac1 是以哪种方式关闭的数据库呢？

nodeapps包括vip, gsd and ons，跟数据库资源没什么关系，所以不要搞混淆概念。

srvctl stop nodeapps只是关闭这几个资源。

shahand · 发表于 2008-12-29 21:38

下午无意又试了一下，是immediate，11.1.0.6 on aix

owlstudio · 发表于 2008-12-30 14:58

原帖由 ricky_zhu 于 2008-12-29 19:54 发表

nodeapps包括vip, gsd and ons，跟数据库资源没什么关系，所以不要搞混淆概念。

srvctl stop nodeapps只是关闭这几个资源。

rac1-> crs_stat -t
Name          Type          Target State    Host
------------------------------------------------------------
ora.devdb.db application ONLINE ONLINE rac1
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
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 ONLINE OFFLINE
ora....C2.lsnr application ONLINE OFFLINE
ora.rac2.gsd application ONLINE OFFLINE
ora.rac2.ons application ONLINE OFFLINE
ora.rac2.vip application ONLINE ONLINE rac1
rac1-> srvctl stop nodeapps -n rac1
rac1-> crs_stat -t
Name          Type          Target State    Host
------------------------------------------------------------
ora.devdb.db application OFFLINE OFFLINE
ora....b1.inst application OFFLINE OFFLINE
ora....b2.inst application ONLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application OFFLINE OFFLINE
ora.rac1.vip application OFFLINE OFFLINE
ora....SM2.asm application ONLINE OFFLINE
ora....C2.lsnr application ONLINE OFFLINE
ora.rac2.gsd application ONLINE OFFLINE
ora.rac2.ons application ONLINE OFFLINE
ora.rac2.vip application ONLINE ONLINE rac1

srvctl stop nodeapps 也会把数据库关掉啊!

ricky_zhu ，我试了一下，也是immediate方式的

xueji03 · 发表于 2008-12-30 16:27

srvctl stop nodeapps 也会把数据库关掉啊!

不会啊，测试如下：
RAC02</home/oracle>$srvctl stop nodeapps -n rac02
RAC02</home/oracle>$srvctl status database -d racdb
Instance racdb1 is running on node rac01
Instance racdb2 is running on node rac02
RAC02</home/oracle>$srvctl status nodeapps -n rac02
VIP is not running on node: rac02
GSD is not running on node: rac02
Listener is not running on node: rac02
ONS daemon is not running on node: rac02
RAC02</home/oracle>$srvctl status database -d racdb
Instance racdb1 is running on node rac01
Instance racdb2 is running on node rac02

SQL> select instance_name,status from gv$instance;

INSTANCE_NAME STATUS
---------------- ------------
racdb2 OPEN
racdb1 OPEN

[ 本帖最后由 xueji03 于 2008-12-30 16:30 编辑 ]

wwwlh · 发表于 2008-12-30 21:32

原帖由 ricky_zhu 于 2008-12-26 19:43 发表
默认来说，srvctl stop database 是以normal方式关闭的，不过也有开关供选择，包括trans, immediate and abort

srvctl stop database -d db_unique_name [-o stop_options]
-o stop_options

shutdown command options (for example: normal, transactional, immediate, or abort)

stop instance也有类似的开关，可以查看帮助

srvctl -h |grep instance

正确，我们可以干预这条命令的，SVRCTL是比较方便，可以帮我们在多个节点上执行shutdown immediate罢了，手工执行也是一样的。