欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2022-07-01 15:48:32
【关闭集群顺序】1.使用crs_stat 命令查询RAC节点的服务状态是否正常[grid@ora01sh ~]$ crs_stat -t -v2.使用srvctl (service control)命令依次关闭集群服务关闭顺序:关闭数据库(实例)-->关闭ASM实例-->关闭节点服务1)关闭数据库[ ......

【关闭集群顺序】
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