启动和停止rac节点数据库

来源：互联网发布：五大流氓国笑话知乎编辑：程序博客网时间：2024/04/26 22:06

本人red hat linux as 4系统的内核版本为x86_64的2.6.9-42.ELsmp,rac集群中数据库节点有4个，hostname分别为node1,node2,node3和node4.
一.通过srvctl工具管理
1.关闭rac数据库服务顺序
[oracle@node2 ~]$ srvctl stop database -d fyweb
[oracle@node2 ~]$ srvctl stop asm       -n node1
[oracle@node2 ~]$ srvctl stop asm       -n node2
[oracle@node2 ~]$ srvctl stop asm       -n node3
[oracle@node2 ~]$ srvctl stop asm       -n node4
[oracle@node2 ~]$ srvctl stop nodeapps -n node1
[oracle@node2 ~]$ srvctl stop nodeapps -n node2
[oracle@node2 ~]$ srvctl stop nodeapps -n node3
[oracle@node2 ~]$ srvctl stop nodeapps -n node4
2.启动rac数据库服务顺序
[oracle@node2 ~]$ srvctl start nodeapps -n node1
[oracle@node2 ~]$ srvctl start nodeapps -n node2
[oracle@node2 ~]$ srvctl start nodeapps -n node3
[oracle@node2 ~]$ srvctl start nodeapps -n node4
[oracle@node2 ~]$ srvctl start asm      -n node1
[oracle@node2 ~]$ srvctl start asm      -n node2
[oracle@node2 ~]$ srvctl start asm      -n node3
[oracle@node2 ~]$ srvctl start asm      -n node4
[oracle@node2 ~]$ srvctl start database -d fyweb
3.其他命令
实例管理
[oracle@node2 ~]$ srvctl status instance -d fyweb -i "fyweb1"
[oracle@node2 ~]$ srvctl stop   instance -d fyweb -i "fyweb1"
[oracle@node2 ~]$ srvctl start instance -d fyweb -i "fyweb1"
监听管理
[oracle@node2 ~]$ srvctl stop   listener -n node1
[oracle@node2 ~]$ srvctl start listener -n node1
[oracle@node2 ~]$ srvctl status listener -n node1
二.通过crsctl工具管理
[oracle@node1 ~]$ crs_stat -t
[oracle@node1 ~]$ crs_stat
[oracle@node1 ~]$ crs_start -all
[oracle@node1 ~]$ crs_stop -all
[oracle@node1 ~]$ crs_stop "ora.fyweb.db"

From http://wanglihu.iteye.com/blog/383003