运行一段时间的standby 想重新启动下,在主数据库切了下日志,就重新启动standby os,启动后发现standby ASM没有自动启动,手动启动报错如下
1,启动ASM报错
[grid@racdg ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 7 05:10:36 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
2,检查那些服务器没有启动
[grid@racdg ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.ARCH.dg ora....up.type 0/5 0/ OFFLINE OFFLINE
ora.CRS.dg ora....up.type 0/5 0/ OFFLINE OFFLINE
ora.DATA1.dg ora....up.type 0/5 0/ OFFLINE OFFLINE
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE racdg
ora.asm ora.asm.type 0/5 0/ OFFLINE OFFLINE
ora.cssd ora.cssd.type 0/5 0/5 ONLINE OFFLINE ---没有启动 css
ora.diskmon ora....on.type 0/10 0/5 ONLINE OFFLINE
ora.racdb.db ora....se.type 0/2 0/1 ONLINE OFFLINE
3,手动执行CSS 服务器没有启动
[grid@racdg ~]$ crs_start ora.cssd
启动后
[grid@racdg ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.ARCH.dg ora....up.type 0/5 0/ OFFLINE OFFLINE
ora.CRS.dg ora....up.type 0/5 0/ OFFLINE OFFLINE
ora.DATA1.dg ora....up.type 0/5 0/ OFFLINE OFFLINE
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE racdg
ora.asm ora.asm.type 0/5 0/ OFFLINE OFFLINE
ora.cssd ora.cssd.type 0/5 0/5 ONLINE ONLINE racdg
ora.diskmon ora....on.type 0/10 0/5 ONLINE ONLINE racdg
ora.racdb.db ora....se.type 0/2 0/1 ONLINE OFFLINE
4,再启动ASM实列
[grid@racdg ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 7 05:53:39 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
启动OK
5,查看 配置
crs_stat -p ora.cssd
[grid@racdg ~]$ crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m
----以下来源网络
下面将AUTO_START属性的可选值列以下:
AUTO_START
Indicates whether Oracle Clusterware automatically starts a resource after a cluster server restart.Valid AUTO_START values are:
always: Restarts the resource when the server restarts regardless of the state of the resource when the server stopped.--始终restart
restore: Restores the resource to the same state that it was in when the server stopped.Oracle Clusterware attempts to restart the resource if the value of TARGET was ONLINE before the server stopped. --根据关闭前一次状态是否选择启动
never: Oracle Clusterware never restarts the resource regardless of the state of the resource when the server stopped.
可以将auto_start设置为 always,就可以随着主机启动 一直保持启动了。
tips
1)默认情况下HAS(High Availability Service)是自动启动的.通过如下命令可以取消和启用自动启动
crsctl disable has
crsctl enable has
2)HAS手动启动和停止
crsctl start has
crsctl stop has
3)查看HAS的状态
crsctl check has
4)如果想让ora.css和ora.diskmon服务随着HAS的启动而自动启动,那么你可以这两个服务的AUTO_START属性
crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
or
crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
5)如果想取消ora.css和ora.diskmon的Auto start
crsctl modify resource "ora.cssd" -attr "AUTO_START=never"
crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"
总结:
原因是cssd设置参数没有配置自动启动,设置为always或restart就OK
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15187685/viewspace-1062525/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15187685/viewspace-1062525/