Mani's Blog

September 1, 2011

Oracle: ORA-15028: ASM file ‘%S’ not dropped; currently being accessed

Filed under: Oracle — mani @ 5:33 pm

We had a situation on TEST DB, the datafile is corrupted.  Decided to drop the datafile since we are not using it.    Dropped using ALTER TABLESPACE,  I don’t see the file in v$datafile.  The physical file still exist, get following error.

ASMCMD> rm -f xn_msg.dbf
ORA-15032: not all alterations performed
ORA-15028: ASM file ‘+XN_DATA2/XNB1RAC/DATAFILE/xn_msg.dbf’ not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)

Solution:

I will have to restart the instance then I was able to remove the file.  I wouldn’t prefer to restart the instance, since it is staging area, no much impact.

ASMCMD> rm -f xn_msg.dbf

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: