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