Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, August 11, 2015

ORA-15028: ASM file not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)


Issue:
ORA-15028: ASM file not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
 Trying to drop a asm file which is actively used by ORACLE Database.

ASMCMD> rm -rf users01.dbf
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DATA2/ORCL/users01.dbf' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)


Fix:
Take the file offline(or shut the DB down ) and then try again:

SQL> alter database datafile '+DATA2/orcl/users01.dbf' offline;

Database altered.

ASMCMD> rm -rf users01.dbf

ASMCMD> ls -l users01.dbf
ASMCMD-8002: entry 'users01.dbf' does not exist in directory '+DATA2/ORCL/'



No comments: