archivelogdeletion
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>
[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>
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial