ora.crsd资源异常-INTERMEDIATE

./crsctl stop has &
/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count= &

./srvctl stop scan_listener -i 1

./srvctl stop scan -i 1
[root@wxrac02 bin]# ./crsctl start resource "ora.crsd" -init
CRS-2672: Attempting to start 'ora.crsd' on 'wxrac02'
CRS-2676: Start of 'ora.crsd' on 'wxrac02' succeeded
[root@wxrac02 bin]# ./crsctl status res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       wxrac02                  Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       wxrac02                                      
ora.crf
      1        ONLINE  OFFLINE                                                   
ora.crsd
      1        ONLINE  INTERMEDIATE wxrac02                                      
ora.cssd
      1        ONLINE  ONLINE       wxrac02                                      
ora.cssdmonitor
      1        ONLINE  ONLINE       wxrac02                                      
ora.ctssd
      1        ONLINE  ONLINE       wxrac02                  OBSERVER            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       wxrac02                                      
ora.gipcd
      1        ONLINE  ONLINE       wxrac02                                      
ora.gpnpd
      1        ONLINE  ONLINE       wxrac02                                      
ora.mdnsd
      1        ONLINE  ONLINE       wxrac02                                      
[root@wxrac02 bin]# ./crsctl status res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       wxrac02                  Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       wxrac02                                      
ora.crf
      1        ONLINE  OFFLINE                                                   
ora.crsd
      1        ONLINE  INTERMEDIATE wxrac02                                      
ora.cssd
      1        ONLINE  ONLINE       wxrac02                                      
ora.cssdmonitor
      1        ONLINE  ONLINE       wxrac02                                      
ora.ctssd
      1        ONLINE  ONLINE       wxrac02                  OBSERVER            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       wxrac02                                      
ora.gipcd
      1        ONLINE  ONLINE       wxrac02                                      
ora.gpnpd
      1        ONLINE  ONLINE       wxrac02                                      
ora.mdnsd
      1        ONLINE  ONLINE       wxrac02                                      
[root@wxrac02 bin]# ./crsctl status res -t -init

 

监听资源无法正常启动，sqlnet.ora的文件调整修改无法通过，导致无法启动，状态为INTERMEDIATE

 

案例2 由于归档满，导致crs管理的数据库资源无法启动导致状态问题

[root@rac02 bin]# ./crsctl status res -t -init 
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       wxrac02                  Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       wxrac02                                      
ora.crf
      1        ONLINE  OFFLINE                                                   
ora.crsd
      1        ONLINE  ONLINE       wxrac02                                      
ora.cssd
      1        ONLINE  interimmediate       wxrac02     --查看 tns 查看ora，然后查看对应的日志。                                   
ora.cssdmonitor
      1        ONLINE  ONLINE       wxrac02                                      
ora.ctssd
      1        ONLINE  ONLINE       wxrac02                  OBSERVER            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       wxrac02                                      
ora.gipcd
      1        ONLINE  ONLINE       wxrac02                                      
ora.gpnpd
      1        ONLINE  ONLINE       wxrac02                                      
ora.mdnsd
      1        ONLINE  ONLINE       wxrac02                                      
[root@wxrac02 bin]# ps -ef|grep ora_

RC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Picked broadcast on commit scheme to generate SCNs
SUCCESS: diskgroup FRA was mounted
Unable to create archive log file '+FRA'
ARC1: Error 19504 Creating archive log file to '+FRA'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance radiodb2 - Archival Error
ORA-16038: log 3 sequence# 4745 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 2: '+DATA/radiodb/onlinelog/group_3.266.946223453'
Errors in file /u01/oracle/diag/rdbms/radiodb/radiodb2/trace/radiodb2_ora_17090.trc:
ORA-16014: log 3 sequence# 4745 not archived, no available destinations
ORA-00312: online log 3 thread 2: '+DATA/radiodb/onlinelog/group_3.266.946223453'
USER (ospid: 17090): terminating the instance due to error 16014
ASMCMD> cd fra
ASMCMD> ls
RADIODB/
ASMCMD> cd ra*
ASMCMD> ls
ARCHIVELOG/
ASMCMD> cd ar*
ASMCMD> ls
2019_10_10/
2019_10_12/
2019_10_13/
2019_10_15/
2019_10_16/
2019_10_18/
2019_10_20/
2019_10_21/
2019_10_23/
2019_10_24/
2019_10_26/
2019_10_27/
2019_10_28/
2019_10_30/
2019_10_31/
2019_11_02/
2019_11_03/
2019_11_05/
2019_11_06/
ASMCMD> rm -rf *


[oracle@rac02 trace]$ srvctl start instance -d radiodb -n rac02

[oracle@wrac02 trace]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Dec 1 23:07:36 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: RAODB (DBID=1695886933)

RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;