ORA-15028

原创于 2022-05-20 15:06:23 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

DBA 专栏收录该内容

1069 篇文章

订阅专栏

本文探讨了一种ASM磁盘组中出现的硬盘离线（Offline）问题，详细解释了错误代码15028的含义，即文件正在被客户端访问，无法被删除。解决此类问题需要停止所有使用该文件的客户端并重新尝试删除操作。建议查询V$ASM_CLIENT视图或使用ASMCMD工具来列出活跃客户端。

MGMT磁盘组有一块盘offline
在这里插入图片描述

oerr ora 15028
15028, 00000, "ASM file '%s' not dropped; currently being accessed"
// *Cause:  An attempt was made to drop an ASM file, but the file was
//          being accessed by one or more clients and therefore could 
//          not be dropped.
// *Action: Stop all clients that are using this file and retry the drop 
//          command. Query the V$ASM_CLIENT fixed view in an ASM instance
//          or use ASMCMD LSOF to list active clients.
//

在这里插入图片描述