CRS注册资源删除2010-08-24 11:12发现单节点rac standby的crs资源出现问题:
[oracle@bf-center-db3 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B3.lsnr application ONLINE ONLINE bf-c...-db3
ora....db3.gsd application ONLINE ONLINE bf-c...-db3
ora....db3.ons application ONLINE ONLINE bf-c...-db3
ora....db3.vip application ONLINE ONLINE bf-c...-db3
ora....a1.inst application ONLINE UNKNOWN bf-c...-db3
先看看UNKNOWN资源:
[oracle@bf-center-db3 ~]$ crs_stat -v
部分省略。。。。
NAME=ora.bf-center-db3.vip
TYPE=application
RESTART_ATTEMPTS=0
RESTART_COUNT=0
FAILURE_THRESHOLD=0
FAILURE_COUNT=0
TARGET=ONLINE
STATE=ONLINE on bf-center-db3
NAME=ora.bfdata47.bfdata1.inst
TYPE=application
RESTART_ATTEMPTS=5
RESTART_COUNT=0
FAILURE_THRESHOLD=0
FAILURE_COUNT=0
TARGET=ONLINE
STATE=UNKNOWN on bf-center-db3
尝试用srvctl命令去删除该注册项,不成功。
继续使用crs命令:
[oracle@bf-center-db3 ~]$ crs_stop ora.bfdata47.bfdata1.inst
Attempting to stop `ora.bfdata47.bfdata1.inst` on member `bf-center-db3`
`ora.bfdata47.bfdata1.inst` on member `bf-center-db3` has experienced an unrecoverable failure.
Human intervention required to resume its availability.
CRS-0216: Could not stop resource 'ora.bfdata47.bfdata1.inst'.
这还不行,看来还得强制删除。
[oracle@bf-center-db3 ~]$ crs_stop ora.bfdata47.bfdata1.inst -f -q
[oracle@bf-center-db3 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B3.lsnr application ONLINE ONLINE bf-c...-db3
ora....db3.gsd application ONLINE ONLINE bf-c...-db3
ora....db3.ons application ONLINE ONLINE bf-c...-db3
ora....db3.vip application ONLINE ONLINE bf-c...-db3
ora....a1.inst application ONLINE UNKNOWN bf-c...-db3
[oracle@bf-center-db3 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B3.lsnr application ONLINE ONLINE bf-c...-db3
ora....db3.gsd application ONLINE ONLINE bf-c...-db3
ora....db3.ons application ONLINE ONLINE bf-c...-db3
ora....db3.vip application ONLINE ONLINE bf-c...-db3
ora....a1.inst application OFFLINE OFFLINE
[oracle@bf-center-db3 ~]$ crs_unregister ora.bfdata47.bfdata1.inst
[oracle@bf-center-db3 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B3.lsnr application ONLINE ONLINE bf-c...-db3
ora....db3.gsd application ONLINE ONLINE bf-c...-db3
ora....db3.ons application ONLINE ONLINE bf-c...-db3
ora....db3.vip application ONLINE ONLINE bf-c...-db3
删除成功。
[oracle@bf-center-db3 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B3.lsnr application ONLINE ONLINE bf-c...-db3
ora....db3.gsd application ONLINE ONLINE bf-c...-db3
ora....db3.ons application ONLINE ONLINE bf-c...-db3
ora....db3.vip application ONLINE ONLINE bf-c...-db3
ora....a1.inst application ONLINE UNKNOWN bf-c...-db3
先看看UNKNOWN资源:
[oracle@bf-center-db3 ~]$ crs_stat -v
部分省略。。。。
NAME=ora.bf-center-db3.vip
TYPE=application
RESTART_ATTEMPTS=0
RESTART_COUNT=0
FAILURE_THRESHOLD=0
FAILURE_COUNT=0
TARGET=ONLINE
STATE=ONLINE on bf-center-db3
NAME=ora.bfdata47.bfdata1.inst
TYPE=application
RESTART_ATTEMPTS=5
RESTART_COUNT=0
FAILURE_THRESHOLD=0
FAILURE_COUNT=0
TARGET=ONLINE
STATE=UNKNOWN on bf-center-db3
尝试用srvctl命令去删除该注册项,不成功。
继续使用crs命令:
[oracle@bf-center-db3 ~]$ crs_stop ora.bfdata47.bfdata1.inst
Attempting to stop `ora.bfdata47.bfdata1.inst` on member `bf-center-db3`
`ora.bfdata47.bfdata1.inst` on member `bf-center-db3` has experienced an unrecoverable failure.
Human intervention required to resume its availability.
CRS-0216: Could not stop resource 'ora.bfdata47.bfdata1.inst'.
这还不行,看来还得强制删除。
[oracle@bf-center-db3 ~]$ crs_stop ora.bfdata47.bfdata1.inst -f -q
[oracle@bf-center-db3 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B3.lsnr application ONLINE ONLINE bf-c...-db3
ora....db3.gsd application ONLINE ONLINE bf-c...-db3
ora....db3.ons application ONLINE ONLINE bf-c...-db3
ora....db3.vip application ONLINE ONLINE bf-c...-db3
ora....a1.inst application ONLINE UNKNOWN bf-c...-db3
[oracle@bf-center-db3 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B3.lsnr application ONLINE ONLINE bf-c...-db3
ora....db3.gsd application ONLINE ONLINE bf-c...-db3
ora....db3.ons application ONLINE ONLINE bf-c...-db3
ora....db3.vip application ONLINE ONLINE bf-c...-db3
ora....a1.inst application OFFLINE OFFLINE
[oracle@bf-center-db3 ~]$ crs_unregister ora.bfdata47.bfdata1.inst
[oracle@bf-center-db3 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B3.lsnr application ONLINE ONLINE bf-c...-db3
ora....db3.gsd application ONLINE ONLINE bf-c...-db3
ora....db3.ons application ONLINE ONLINE bf-c...-db3
ora....db3.vip application ONLINE ONLINE bf-c...-db3
删除成功。