ORA-15028: error in ASM [message #407275] |
Tue, 09 June 2009 07:08 |
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 |
|
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 |
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)
|
|
|
|