This discussion is archived
10 Replies Latest reply: Feb 17, 2011 11:21 PM by 741939 RSS

Configure Retention Policy?

28348 Newbie
Currently Being Moderated
Dear all,

What is the difference between "configure retention policy to recovery window of 14 days" and "configure retention policy to redundancy 2"?

Best Regards,
Amy
  • 1. Re: Configure Retention Policy?
    26741 Oracle ACE
    Currently Being Moderated
    The two are mutually exclusive.

    RECOVERY WINDOW specifies the age of backups that need to be retained.

    REDUNDANCY specifies the number of backups that need to be retained.

    Think about the case where you have a critical database that you backup
    3 times a day. Your WINDOW has to be 14 days OR REDUNDANCY has to be 42 copies.
  • 2. Re: Configure Retention Policy?
    28348 Newbie
    Currently Being Moderated
    Hi Hemant,

    According to what you said, RECOVERY WINDOW specifies the age of backups would be more reason if the database only backup once a day. As a result, I have 14 days of backups. Am I right?

    Thanks,
    Amy
  • 3. Re: Configure Retention Policy?
    26741 Oracle ACE
    Currently Being Moderated
    correct
  • 4. Re: Configure Retention Policy?
    28348 Newbie
    Currently Being Moderated
    I issue the following command:

    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
    CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

    That means the database is backup once a day and the window has to be 7 days.
    Is it correct?

    Best Regards,
    Amy
  • 5. Re: Configure Retention Policy?
    26741 Oracle ACE
    Currently Being Moderated
    The two are mutually exclusive. Check the documentation.
    So the later setting will override the earlier one.
    Check the value with a SHOW ALL at the RMAN commandline.

    I suggest that you reset it to
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS
  • 6. Re: Configure Retention Policy?
    28348 Newbie
    Currently Being Moderated
    Dear Hemant,

    I check the document and I was misunderstanding these 2 commands.

    Many thanks your suggestion.
    Amy
  • 7. Re: Configure Retention Policy?
    491476 Expert
    Currently Being Moderated
    correct
    With a RECOVERY WINDOW OF 14 DAYS, the OP would actually maintain 15 days worth of backups.
  • 8. Re: Configure Retention Policy?
    dba-hyd Pro
    Currently Being Moderated
    Recovery window of 14 days mean it will keep all 14 days backups as available and the older copies as obsolete.

    Redundancy of 2 means it keeps the last 2 backups available and the older onces as obsolete.

    Correct if I am wrong.
  • 9. Re: Configure Retention Policy?
    491476 Expert
    Currently Being Moderated
    Recovery window of 14 days mean it will keep all 14 days backups as available and the older copies as obsolete.
    The OP mentioned backup once a day. With that in mind, typically backups are scheduled at the same time everyday. Therefore, with a RECOVERY WINDOW OF 14 DAYS, RMAN will require a backup sufficiently old enough to recover to the desired time. The backup from the 14th day wouldn't be old enough, therefore the 15 day old backup would be required.
  • 10. Re: Configure Retention Policy?
    741939 Newbie
    Currently Being Moderated
    We are backing up our database full backup once a week (on Monday) and 2 times of daily backup.

    Is "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS" good enough?

    I am very confused about retention policy.

    here is our parameters in RMAN
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    CONFIGURE BACKUP OPTIMIZATION OFF; # default
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/db/ba
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.1.0/db_1/db

    Please advice.