标题: ASMCMD Results ORA-15028 When Delete Datafile of a Dropped Database in ASM [打印本页] 作者: 刘泽宇 时间: 2024-9-22 13:36 标题: ASMCMD Results ORA-15028 When Delete Datafile of a Dropped Database in ASM 现象：
Following error receive when drop a datafile from asmcmd after dropping a database normally without deleting its contents.
ASMCMD> rm -f SYSAUX.337.1045998233
ORA-15032: not all alterations performed
ORA-15028: ASM file '+<DG_NAME1>/<DB_NAME2>/DATAFILE/SYSAUX.337.1045998233' not
dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
原因：
ORA-15028 error is due to file open by the DB under a user alias.
System state dump through below command report that +<DG_NAME1>/<DB_NAME1>/DATAFILE/sysaux.dbf is user aliases of +<DG_NAME1>/<DB_NAME2>/DATAFILE/SYSAUX.337.1045998233
alter session set events 'immediate trace name systemstate level 267';
处理方法：
Close +<DG_NAME1>/<DB_NAME1>/DATAFILE/sysaux.dbf from DB <DB_NAME1>, and you will be able to delete SYSAUX.337.1045998233