This discussion is archived
6 Replies Latest reply: Jan 12, 2013 7:11 AM by Girish Sharma RSS

ASM files delete

902332 Newbie
Currently Being Moderated
Hi all,

We are trying to delete some files from ASM disk group using rm -rf command but it is not deleting

ASMCMD> rm -rf HISTDATA_2005.372.669653109
ORA-15032: not all alterations performed
ORA-15028: ASM file '+ASM_GROUP1/xxxx/DATAFILE/xxxx_2005.372.669653109' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ASMCMD>

no instance is using these files.

is there any option to deleted these files forcefully

it's urgent pls
please let me know...

Edited by: 899329 on Jan 12, 2013 5:49 AM
  • 1. Re: ASM files delete
    Girish Sharma Guru
    Currently Being Moderated
    With ASM and OMF, shutdown the instance and remove the files.

    http://www.orafaq.com/forum/t/146233/2
  • 2. Re: ASM files delete
    902332 Newbie
    Currently Being Moderated
    checked from os leve ps -ef|grep no instance is using this.
  • 3. Re: ASM files delete
    Girish Sharma Guru
    Currently Being Moderated
    899329 wrote:
    checked from os leve ps -ef|grep no instance is using this.
    Ok. What happens if you tries to restart the instance and then try to remove the file, because this is something in below link too :

    http://manidba.wordpress.com/2011/09/01/oracle-ora-15028-asm-file-s-not-dropped-currently-being-accessed/

    Show us the copy and paste from sqlplus and your command prompt output by copy and paste.
  • 4. Re: ASM files delete
    902332 Newbie
    Currently Being Moderated
    from sql:

    SQL(njbar1): >alter diskgroup ASM_GROUP1 drop file '+ASM_GROUP1/TTBAR1/DATAFILE/DATA01.264.669651777';
    alter diskgroup ASM_GROUP1 drop file '+ASM_GROUP1/TTBAR1/DATAFILE/DATA01.264.669651777'
    *
    ERROR at line 1:
    ORA-15032: not all alterations performed
    ORA-15028: ASM file '+ASM_GROUP1/TTBAR1/DATAFILE/DATA01.264.669651777' not
    dropped; currently being accessed


    from asmcmd:

    ORA-15032: not all alterations performed
    ORA-15028: ASM file '+ASM_GROUP1/TTHST/DATAFILE/SYSTEM.303.668096595' not dropped; currently being accessed (DBD ERROR: OCIStmtExe
    ORA-15032: not all alterations performed
    ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)


    60 days back only server rebooted and that database was not using from 1 year. no controlfiles, parfiles for that

    Edited by: 899329 on Jan 12, 2013 6:48 AM
  • 5. Re: ASM files delete
    JohnWatson Guru
    Currently Being Moderated
    Are you certain there is no ASM client active? Nothing in the v$asm_client viiew?
    Also, you could try using asmcmd to check the diskgroup for meta data corruptions,

    chkdg asm_group1

    it has a repair switch which might help.
  • 6. Re: ASM files delete
    Girish Sharma Guru
    Currently Being Moderated
    Please check below link :

    Re: Does directory exist or not?

    In the above thread the same error is there ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

    Discussion says that it may be a bug or try to play around the SQL provided in the link by Oracle itself.

    Thread should be moved to [url https://forums.oracle.com/forums/forum.jspa?forumID=385&start=0]Automatic Storage Management forum.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points