集群状态显示OFFLINE
[grid@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.ARCH.dg ora....up.type OFFLINE OFFLINE
ora.DATA.dg ora....up.type ONLINE ONLINE rac1
ora....ER.lsnr ora....er.type ONLINE ONLINE rac1
ora....N1.lsnr ora....er.type ONLINE ONLINE rac2
ora.OCR.dg ora....up.type ONLINE ONLINE rac1
ora.asm ora.asm.type ONLINE ONLINE rac1
ora.eons ora.eons.type ONLINE ONLINE rac1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE rac1
ora.orcl.db ora....se.type OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type ONLINE ONLINE rac2
ora.scan1.vip ora....ip.type ONLINE ONLINE rac2
[grid@rac1 ~]$
ASM磁盘目录没有mount
[root@rac1 opt]# su - grid
Last login: Tue Aug 4 19:17:49 CST 2020 on pts/0
[grid@rac1 ~]$ asmcmd
ASMCMD> ls -l
State Type Rebal Name
MOUNTED EXTERN N DATA/
MOUNTED NORMAL N OCR/
ASMCMD>
exit
查看diskgroup显示not running
$ srvctl status diskgroup -g DATA
Disk Group DATA is running on rac1,rac2
[grid@rac1 ~]$
[grid@rac1 ~]$ srvctl status diskgroup -g ARCH
Disk Group ARCH is not running
归档日志磁盘没有ONLINE,导致Oracle数据库启动失败:
su - grid
start database -d orcl
[grid@rac1 ~]$ srvctl start database -d orcl
PRCR-1079 : Failed to start resource ora.orcl.db
ORA-16014: log 2 sequence# 24 not archived, no available destinations
ORA-00312: online log 2 thread 1: '+DATA/orcl/onlinelog/group_2.262.1047345431'
CRS-2674: Start of 'ora.orcl.db' on 'rac2' failed
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
[grid@rac1 ~]$
尝试手动启动diskgroup
[grid@rac1 ~]$ srvctl start diskgroup -g ARCH
[grid@rac1 ~]$ srvctl status diskgroup -g ARCH
Disk Group ARCH is running on rac1,rac2
启用diskgroup ARCH的自动重启功能,失败或主机重启时能自动启动:
[grid@rac1 ~]$ srvctl enable diskgroup -g ARCH