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 ?