• 欢迎访问搞代码网站,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站!
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏搞代码吧

RAC如何启动状态为UNKNOWN的资源PRKS-1009,CRS-1028,CRS-0223

mysql 搞代码 4年前 (2022-01-09) 23次浏览 已收录 0个评论

RAC如何启动状态为UNKNOWN的资源PRKS-1009,CRS-1028,CRS-0223

RAC如何启动状态为UNKNOWN的资源&&PRKS-1009,CRS-1028,CRS-0223

现象:
RAC的一个节点起不来,crs_stat查看发现很多资源状态都为offline
[Oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
————————————————————
ora.rac.db application OFFLINE OFFLINE
ora….c1.inst application ONLINE OFFLINE
ora….c2.inst application ONLINE OFFLINE
ora….test.cs application OFFLINE OFFLINE
ora….ac1.srv application OFFLINE OFFLINE
ora….ac2.srv application OFFLINE OFFLINE
ora….SM1.asm application ONLINE ONLINE rac1
ora….C1.lsnr application ONLINE ONLINE rac1
ora….ac1.gsd application ONLINE ONLINE rac1
ora….ac1.ons application ONLINE ONLINE rac1
ora….ac1.vip application ONLINE ONLINE rac1
ora….SM2.asm application ONLINE UNKNOWN rac2
ora….C2.lsnr applicati本文来源gaodai#ma#com搞@@代~&码*网/on ONLINE UNKNOWN rac2
ora….ac2.gsd application ONLINE ONLINE rac2
ora….ac2.ons application ONLINE ONLINE rac2
ora….ac2.vip application ONLINE ONLINE rac2
[oracle@rac1 ~]$ srvctl start asm -n rac2
PRKS-1009 : Failed to start ASM instance “+ASM2” on node “rac2”, [PRKS-1009 : Failed to start ASM instance “+ASM2” on node “rac2”, [CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource ‘ora.rac2.ASM2.asm’ has placement error.]]
[PRKS-1009 : Failed to start ASM instance “+ASM2” on node “rac2”, [CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource ‘ora.rac2.ASM2.asm’ has placement error.]]
[oracle@rac1 ~]$ srvctl stop asm -n rac2
[oracle@rac1 ~]$ srvctl start asm -n rac2
PRKS-1009 : Failed to start ASM instance “+ASM2” on node “rac2”, [PRKS-1009 : Failed to start ASM instance “+ASM2” on node “rac2”, [CRS-0215: Could not start resource ‘ora.rac2.ASM2.asm’.]]
[PRKS-1009 : Failed to start ASM
stop之后再start还是不行。

分析:
资源状态因为某种原因变为UNKNOWN,,导致无法通过正常方式启动。

解决方法:
客户的系统比较重要,当时先恢复业务,再仔细分析原因。
恢复业务的方法如下:
先强制停止状态为UNKNOWN的资源:
crs_stop -f ora.rac2.ASM2.asm
crs_stop -f ora.rac2.lsnr
再重新启动资源:
crs_start -all
重启之后业务恢复正常。


搞代码网(gaodaima.com)提供的所有资源部分来自互联网,如果有侵犯您的版权或其他权益,请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected],我们会在看到邮件的第一时间内为您处理,或直接联系QQ:872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接:RAC如何启动状态为UNKNOWN的资源PRKS-1009,CRS-1028,CRS-0223
喜欢 (0)
[搞代码]
分享 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址