oracle中15042,ora-15040 diskgroup is incomplete ORA-15042 ASM Disk"2" is missing.

在尝试启动ASM实例时遇到ORA-15040及ORA-15042错误,显示磁盘组DG_GROUP3不完整且丢失ASM磁盘2。尽管从操作系统层面检查确认所有磁盘均正常,但无法成功挂载磁盘组。需要指导如何正确启动ASM实例并避免数据损失。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

hi,

unfortunatly our server get rebooted after taht we are try to start ASM instance then we got below error

ora-15040 diskgroup is incomplete ORA-15042 ASM Disk"2" is missing.but we are checking from OS side all disk are OK.all the Diskgroup are in external rededuncy.

GROUP_NUMBER NAME TYPE OFFLINE_DISKS U STATE

------------------------------

------------- -

1 DG_GROUP1 EXTERN 0 N MOUNTED

2 DG_GROUP2 EXTERN 0 N MOUNTED

3 DG_GROUP4 EXTERN 0 N MOUNTED

0 DG_GROUP3 0 N DISMOUNTED

when i m mount th diskgroup usging below query we have got error

SQL> alter diskgroup DG_GROUP3 mount;

alter diskgroup DG_GROUP3 mount

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15040: diskgroup is incomplete

ORA-15042: ASM disk "2" is missing

what steps we need to perform to start the ASM does it causeess the data loss.how we can recover the database.

thanks,

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值