ORA-15032、ORA-15017、ORA-15040的处理

最新推荐文章于 2025-05-23 16:54:23 发布

文档搬运工

最新推荐文章于 2025-05-23 16:54:23 发布

阅读量2.1k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： GI ASM 文章标签： sql oracle

本文链接：https://blog.csdn.net/xxzhaobb/article/details/120199942

GI ASM 专栏收录该内容

26 篇文章

订阅专栏

在VM环境下，Oracle RDBMS 12.2.0.1的GIStandalone在主机重启后，ASM磁盘组无法正常挂载。ASM实例虽然启动，但alertlog显示磁盘组DATA不完整。通过oerror命令分析，发现可能的ASM_DISKSTRING配置问题。检查发现asm_diskstring参数设置为'AFD:*'，与实际ASM文件路径不符。修正asm_diskstring为'/dev/asm*'并重新挂载后，问题得到解决。

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

RDBMS 12.2.0.1

VM下的GI Standalone，重启主机后，发现ASM磁盘不能mount，但是asm实例是起来了。asm的alert log中提示：

2021-09-09T11:02:58.112574+08:00
GMON dismounting group 1 at 2 for pid 24, osid 10865
2021-09-09T11:02:58.117569+08:00
ERROR: diskgroup DATA was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15040: diskgroup is incomplete

oerr查看报错原因，从报错上看，提示asm_diskstring设置有问题

[grid@asm12c ~]$ oerr ora 15040
15040, 00000, "diskgroup is incomplete"
// *Cause:  Some of the disks comprising a diskgroup were not present.
// *Action: Check the hardware to ensure that all disks are functional. Also
//          check that the setting of the ASM_DISKSTRING initialization 
//          parameter has not changed.  Alternatively, for normal or high
//          redundancy diskgroups, use MOUNT FORCE to offline missing disks
//          as part of mounting the diskgroup.
//
[grid@asm12c ~]$

查看asm_diskstring参数，参数为“AFD：*”

SQL> show parameter ASM_DISKSTRING

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring                       string      AFD:*
SQL>

查看ASM文件的路径，并修改asm_diskstring参数，mount后正常。

[grid@asm12c trace]$ ll /dev/asm*
lrwxrwxrwx 1 root root 4 Sep  9 11:02 /dev/asm-data01 -> sdb1
[grid@asm12c trace]$
SQL> alter system set ASM_DISKSTRING='/dev/asm*';

System altered.

SQL> ALTER DISKGROUP DATA MOUNT;

Diskgroup altered.

SQL>

END