archivelogdeletion

anishtv
anishtv used Ask the Experts™
on
why my archivelog deletion is not happening.

[oracle@dbadm ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jan 30 14:58:30 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DDD (DBID=3695488924)

RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-30';

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=215 instance=DDD device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1191 instance=DDD device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1489 instance=DDD device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=6 instance=DDD device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=205 instance=DDDD device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=303 instance=DDD device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=1099 instance=DDD device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1196 instance=DDD device type=DISK
specification does not match any archived log in the repository

RMAN>
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Several possible reasons.

First possibility:
The connect you provided to RMAN was local and not for a catalog.

If the backups are done through a recovery catalog then they are managed from the catalog and not from the control files.

Second:
The archived redo logs you see on disk aren't part of the managed files from RMAN.

Third:
It may be possible they are still necessary for recovery and cannot be deleted.

Fourth:
Possibly a few other ways.

If you can, please post your RMAN backup scripts.

Author

Commented:
Succeeded.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial