SAP Knowledge Base Article - Preview

3260892 - Deleting archived log fails with ORA-15028

Symptom

Archived log cannot be deleted in ASM, following error is thrown:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on default channel at 10/19/2022 18:21:22
ORA-15028: ASM file '+<DGNAME>/<DB_NAME>/archivelog/2022_10_19/thread_1_seq_12345.1234.123456789' not dropped; currently being accessed

Or in BRARCHIVE:

'/* BRARCHIVE */ ALTER DISKGROUP STB_ARCH DROP FILE '+<DGNAME>/<DB_NAME>/archivelog/2022_10_19/thread_1_seq_12345.1234.123456789''
ORA-15032: not all alterations performed
ORA-15028: ASM file '++<DGNAME>/<DB_NAME>/archivelog/2022_10_19/thread_1_seq_12345.1234.123456789' not dropped; currently being accessed


Read more...

Environment

  • Any SAP product
  • Oracle database with ASM not restricted to any version
  • Any OS platform

Keywords

archivedlog archivelog hold hang drop , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.