Does REDUNDANCY retention policy guarantee PITR from the earliest backup

oracleoracle-9irman

From ORACLE-BASE:

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

…

The recovery window is used to make sure that there are always sufficient backups to recover the database to any point in time with the last 'X' days. Any backups that fall outside this time period can be deleted. The redundancy option simply states that any backups in excess of the latest 'X' are no longer needed.

In other words, setting the RMAN retention policy to a recovery window explicitly guarantees PITR to any time within the recovery window. It isn't clear from this description whether PITR is guaranteed using the alternative redundancy configuration — does RMAN retain all archivelog backups necessary for PITR to any point since the earliest retained backup?

Best Answer

Does RMAN retain all archivelog backups necessary for PITR to any point since the earliest retained backup?

No, at least not if you have incremental backups in the mix:

…we don’t guarantee a recoverability to a certain point in time, just, the number of backupsets.

I'm not sure if the same applies if you aren't using incrementals, but there are too many edge cases with using a redundancy-based policy (see this horror story for example). Use a recovery window instead if you possibly can. The article you quote has the same advice:

The safest option is to use the redundancy window as several backups on a single day could cause the redundancy option to mark valuable files as redundant.

Related Question