SRVCTL 启动、关闭实例
一，查看当前实例的状态，节点node1,node2都是Open状态
[root@node1 ~]# crsctl status res -t
…..
…..
ora.prod.db
1 ONLINE ONLINE node1 Open
2 ONLINE ONLINE node2 Open
二，执行关闭实例的指令，实例名需要在“ ”号之间，并使用, 号分割
[root@node1 ~]# srvctl stop instance -d PROD -i "PROD1,PROD2”
查看当前实例的状态，实例全部关闭
[root@node1 ~]# crsctl status res -t
……
…...
ora.prod.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
三，启动节点node1的实例PROD1，其他节点暂时不启动
[root@node1 ~]# srvctl start instance -d PROD -i PROD1
查看当前实例的状态，实例PROD1开启，其他实例是关闭状态
[root@node1 ~]# crsctl status res ora.prod.db -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.prod.db
1 ONLINE ONLINE node1 Open
2 OFFLINE OFFLINE Instance Shutdown
四，启动其他关闭状态的实例
[root@node1 ~]# srvctl start instance -d PROD -i PROD2
[root@node1 ~]# crsctl status res ora.prod.db -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.prod.db
1 ONLINE ONLINE node1 Open
2 ONLINE ONLINE node2 Open
五，SRVCTL 启动、关闭整个数据库
[root@node1 ~]# srvctl stop database -d PROD -o immediate
[root@node1 ~]# crsctl status res ora.prod.db -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.prod.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
[root@node1 ~]#
[root@node1 ~]# srvctl start database -d PROD
[root@node1 ~]# crsctl status res ora.prod.db -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.prod.db
1 ONLINE ONLINE node1 Open
2 ONLINE ONLINE node2 Open
六，通过查询的方式验证实例是否启动
SYS@PROD1> col INST_NAME for a15
SYS@PROD1> select * from v$active_instances;
INST_NUMBER INST_NAME
----------- ---------------
1 node1:PROD1
2 node2:PROD2
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29047826/viewspace-1218580/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
