RAC DG 物理standby ASM無法啟動

aishu521發表於2013-12-06
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章