./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;