ORA-15058 & ORA-15063

最新推荐文章于 2022-06-21 22:54:26 发布

原创最新推荐文章于 2022-06-21 22:54:26 发布 · 3.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

DBA 专栏收录该内容

1069 篇文章

订阅专栏

本文档列举了三个在创建和管理Oracle Automatic Storage Management (ASM)磁盘组时遇到的错误及其相应的解决方法。错误包括ORA-15018（无法创建磁盘组）、ORA-15058（磁盘属于不兼容的磁盘组）和ORA-15017/15039（无法挂载或删除磁盘组，因磁盘数量不足）。提供的解决方案涉及设置磁盘修复时间、清理磁盘和强制删除磁盘组等操作。

问题1

ORA-15018: diskgroup cannot be created
ORA-15237: attribute disk_repair_time cannot be set in CREATE DISKGROUP

解决方案

alter diskgroup ssddg2 set attribute 'disk_repair_time'='24h';

问题2

ORA-15018: diskgroup cannot be created
ORA-15058: disk '/dev/qdata/local-sd ' belongs to an incompatible diskgroup

解决方案

dd if=/dev/zero of=/dev/qdata/local-sdb bs=1M count=8

问题3

ORA-15017: diskgroup "SDDDG1" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "SDDDG1"

ORA-15039: diskgroup not dropped
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATADG"

解决方案

dd if=/dev/zero of=/dev/qdata/local-sdb bs=1M count=8
select name ,state from v$asm_diskgroup;
drop diskgroup ssddg1 force including contents;
drop diskgroup ssddg1 including contents;