RAC DG 物理standby ASM无法启动

运行一段时间的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/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值