Oracle RAC ASM磁盘(diskgroup)丢失,显示OFFLINE的问题

集群状态显示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
 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

sunny05296

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值