Forum Stats

  • 3,838,735 Users
  • 2,262,395 Discussions


Different retention policies for datafiles and archived logs

Y.Ramlet Member Posts: 258 Bronze Badge
edited Jun 18, 2020 2:34AM in Recovery Manager (RMAN)

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 ?


  • Dude!
    Dude! Member Posts: 22,830 Black Diamond
    edited Jun 18, 2020 2:34AM

    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:

    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.