Home » Server Options » RAC & Failsafe » ORA-15028: error in ASM (Oracle 10g )
ORA-15028: error in ASM [message #407275] Tue, 09 June 2009 07:08 Go to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
Hi,

In production environment, i am trying the drop the unwanted datafile present in the ASM. I am getting the below error

ORA-15028: ASM file '+DGROUP1/DMTRN10/DATAFILE/SYSTEM.750.689054995' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)


I got the solution as Shutdown all the database instances in the server and drop the file from the ASM.

Is there any other solution of not restarting the instances, i can drop the data file from ASM ? Very urgent
Re: ORA-15028: error in ASM [message #407291 is a reply to message #407275] Tue, 09 June 2009 08:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Post the actual command used.

>>ORA-15028: ASM file '+DGROUP1/DMTRN10/DATAFILE/SYSTEM.750.689054995

Is that a system datafile?
quoting docs
Quote:
You cannot drop datafiles in the SYSTEM tablespace.


Generally with ASM and OMF , use drop tablespace and remove manually.

[Updated on: Tue, 09 June 2009 08:10]

Report message to a moderator

Re: ORA-15028: error in ASM [message #407303 is a reply to message #407291] Tue, 09 June 2009 09:02 Go to previous messageGo to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
I am trying to remove the files using rm command. i have run the drop database and trying to remove from ASM. find the error below



ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
TEMPFILE/
control01.ctl
control02.ctl
control03.ctl
ASMCMD> rm -r DATAFILE/
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DGROUP1/DMTRN10/DATAFILE/SYSTEM.750.689054995' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DGROUP1/DMTRN10/DATAFILE/UNDOTS1.734.689055009' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DGROUP1/DMTRN10/DATAFILE/SYSAUX.690.689055019' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DGROUP1/DMTRN10/DATAFILE/USERS.917.689055025' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DGROUP1/DMTRN10/DATAFILE/TOOLS.799.689055025' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DGROUP1/DMTRN10/DATAFILE/UNDOTS2.826.689055779' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)
Re: ORA-15028: error in ASM [message #407304 is a reply to message #407303] Tue, 09 June 2009 09:11 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
still something is using those files. As said before,
With ASM and OMF, shutdown the instance and remove the files.
Previous Topic: Upgrade from 10.2.0.1.0 to 10.2.0.4.0
Next Topic: ONS service Offline after Reboot
Goto Forum:
  


Current Time: Thu Mar 28 07:42:32 CDT 2024