Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Different retention policies for datafiles and archived logs

RDBMS version: 11.2 and higher
When configuring RMAN retention policy for a database, is it possible to set 'Recovery Window' retention policy for datafiles and 'Redundancy' retention policy for Archived logs ?
Answers
-
No, the retention policy applies to both, rman datafile and archivelog backups. But you can define an archivelog deletion policy that applies when deleting archivelogs. The policy by default it is set to none. Please see the documentation:
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfb.htm#BRADV89439
Keep in mind that RMAN does not delete anything unless you instruct it to do so. If you configure FRA, and there is space pressure, only then will Oracle automatically delete files according to your retention and archivelog policy. The policy also applies when you backup files using "delete input". Also, no rman backups are considered obsolete regardless of age, when the data is required to fulfill your retention policy, e.g. older parent level 0 backups.