- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Delete archivelogs never been backed up?
Dear RMAN connoisseurs,
how do I get RMAN to automatically delete archivelogs never backed up?
Let's say I have configured a retention window of 14 days, rendering backups older than >14 days obsolete (and being deleted).
Let's also assume our LOG_ARCHIVE_DEST points already to the backup storage system, so there's no need to explicitly back them up (since the originals are already in the backup location and backing them up would create rather pointless copies).
Now, how do I delete those archivelogs >14 days (more exact: from before my oldest, but not-yet-obsoleted backup set), even though these have never been backed up...?
The 11g RMAN docs say for archivelogs to become eligible to be deleted, they must A) been backed up at least once to disk and must be older than my retention policy.
I have tried to CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 0 TIMES TO DISK; but this is refused by RMAN, of course.
Since my retention window covers 14 days, I will never have backups older than ~14 days, rendering useless all archive logs from before my oldest still-existing backup set. Yet it seems as if I cannot delete them unless they have been backed up...
May be I didn't understand some conceptual thing here, may be our idea of setting LOG_ARCHIVE_DEST to point straight into the backup storage is not so good...
Can you sched some light to this problem...?