启动/关闭数据库、实例及服务

2022-10-13,,,,

关闭集群顺序】
1.使用crs_stat 命令查询rac节点的服务状态是否正常
[grid@ora01sh ~]$ crs_stat -t -v
2.使用srvctl (service control)命令依次关闭集群服务
关闭顺序:关闭数据库(实例)-->关闭asm实例-->关闭节点服务
1)关闭数据库
[grid@ora01sh ~]$ srvctl status database -d rac
--关闭数据库
srvctl stop database -d rac1
srvctl stop database -d rac2
--关闭各节点asm实例
[grid@ora01sh ~]$ srvctl status asm -n ora01sh
asm is running on ora01sh
[grid@ora01sh ~]$ srvctl status asm -n ora02sh
asm is running on ora02sh

srvctl stop asm -n ora01sh
srvctl stop asm -n ora02sh

[grid@ora01sh ~]$ crs_stat -t -v

关闭各节点服务:listener、gsd、ons、vip
[grid@ora01sh ~]$ srvctl status nodeapps -n ora01sh
vip ora01sh-vip is enabled
vip ora01sh-vip is running on node: ora01sh
network is enabled
network is running on node: ora01sh
gsd is disabled
gsd is not running on node: ora01sh
ons is enabled
ons daemon is running on node: ora01sh

[grid@ora01sh ~]$ srvctl status nodeapps -n ora02sh
vip ora02sh-vip is enabled
vip ora02sh-vip is running on node: ora02sh
network is enabled
network is running on node: ora02sh
gsd is disabled
gsd is not running on node: ora02sh
ons is enabled
ons daemon is running on node: ora02sh

srvctl stop nodeapps -n ora01sh
srvctl stop nodeapps -n ora02sh

启动集群顺序】
启动顺序:启动节点服务-->启动asm实例-->启动数据库实例
1)启动各节点的服务
srvctl start nodeapps -n ora01sh
srvctl start nodeapps -n ora02sh
2)启动asm实例
srvctl start asm -n ora01sh
srvctl start asm -n ora02sh
3)启动数据库及实例
[grid@ora01sh ~]$ srvctl status instance -d rac -i rac1,rac2
instance rac1 is running on node ora01sh
instance rac2 is running on node ora02sh

[grid@ora01sh ~]$ srvctl status database -d rac
instance rac1 is running on node ora01sh
instance rac2 is running on node ora02sh

[grid@ora01sh ~]$ crs_stat -t -v

************************************************************************************************************/

【关闭数据库、实例及服务】
--关闭数据库
srvctl stop database -d rac1
srvctl stop database -d rac2

--关闭各节点asm实例
srvctl stop asm -n ora01sh
srvctl stop asm -n ora02sh

--关闭各节点的服务包括:listener、gsd、ons、vip
srvctl stop nodeapps -n ora01sh
srvctl stop nodeapps -n ora02sh

【启动数据库、实例及服务】
--启动各节点的服务
srvctl start nodeapps -n ora01sh
srvctl start nodeapps -n ora02sh
--启动asm实例
srvctl start asm -n ora01sh
srvctl start asm -n ora02sh
--启动数据库及实例
srvctl start instance -d rac -i rac1,rac2

srvctl start database -d rac1
srvctl start database -d rac2

《启动/关闭数据库、实例及服务.doc》

下载本文的Word格式文档,以方便收藏与打印。