解决Oracle crs_stat状态为UNKNOWN问题

最新推荐文章于 2022-09-30 10:37:36 发布

原创最新推荐文章于 2022-09-30 10:37:36 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle培训 #oracle学习 #cuug培训 #ocp #com

本文详细描述了Oracle RAC环境下，当CRS_stat-t显示有两个resource状态为unknown时，如何通过crs_stop和crs_start命令进行资源状态切换，并解决资源变为offline状态的问题。

RAC启动后，crs_stat -t显示有两个resource的状态为unknown，如下：

Oracle@RAC1 [/home/oracle] crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE UNKNOWN rac1
ora.rac1.ons application ONLINE UNKNOWN rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
ora.xjny.db application ONLINE ONLINE rac2
ora....y1.inst application ONLINE ONLINE rac1
ora....y2.inst application ONLINE ONLINE rac2

通过crs_stop，使该resource变为offline状态，然后用crs_start重启该resource，如下：

oracle@RAC1 [/home/oracle] crs_stop ora.rac1.gsd
Attempting to stop `ora.rac1.gsd` on member `rac1`
Stop of `ora.rac1.gsd` on member `rac1` succeeded.

oracle@RAC1 [/home/oracle] crs_stop ora.rac1.ons
Attempting to stop `ora.rac1.ons` on member `rac1`
Stop of `ora.rac1.ons` on member `rac1` succeeded.

命令完成后，相关resource变为OFFLINE状态：

oracle@RAC1 [/home/oracle] crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application OFFLINE OFFLINE
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
ora.xjny.db application ONLINE ONLINE rac2
ora....y1.inst application ONLINE ONLINE rac1
ora....y2.inst application ONLINE ONLINE rac2

使用crs_start命令启动该resource：

oracle@RAC1 [/home/oracle] crs_start ora.rac1.gsd
Attempting to start `ora.rac1.gsd` on member `rac1`
Start of `ora.rac1.gsd` on member `rac1` succeeded.
oracle@RAC1 [/home/oracle] crs_start ora.rac1.ons
Attempting to start `ora.rac1.ons` on member `rac1`
Start of `ora.rac1.ons` on member `rac1` succeeded.
oracle@RAC1 [/home/oracle]
oracle@RAC1 [/home/oracle] crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
[img]http://dl2.iteye.com/upload/attachment/0095/3889/3be86f70-c640-36f1-be5c-165d51e7b279.jpg[/img]

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 ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
ora.xjny.db application ONLINE ONLINE rac2
ora....y1.inst application ONLINE ONLINE rac1
ora....y2.inst application ONLINE ONLINE rac2