Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REDUNDANCY and RECOVERY WINDOW retention policies ; Which one to choose ?

Y.RamletFeb 5 2016 — edited Feb 5 2016

DB version: 11.2.0.4 on RAC

OS : Oracle Linux 6.7

In my shop, we are going to build around 20 prod DBs of various sizes. The largest DB will be 10 Terabytes and the smallest one will be around 750GB in size.

RMAN has two type of retention policies :

          1. REDUNDANCY retention polcy

   2. RECOVERY WINDOW retention policy

I know what these 2 policies are but I don't know the conventions followed when choosing either of these two policies.

Question1.

Does DB size matter when choosing the ideal retention policy for a DB ? ie. Is there some general rule (rule of thumb) like , for larger DBs use a particular retention policy and for a smaller DB , choose this type ?

Question2.

Oracle 11.2 documentation says "A backup retention policy applies only to full or level 0 datafile and control file backups".

So, retention policy does not affect incremental (L1) backups ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2016
Added on Feb 5 2016
8 comments
3,327 views