In the similar vein to my other topic, my management has just dictated we have to use a complicated retention policy for backups of our Databases.
They want the following:
Dailys at 6 days.
Weekly at 4 weeks
Monthly at 11 months
Yearly at 7 years.
The problem is, my DBAs are telling me that RMAN cannot handle multiple retentions. It's a single global retention and nothing else.
My understanding is that calling this line "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF x DAYS;" in the RMAN script before each backup occurs, with x replaced by the number of days that equal our retentions would do the trick.
Am I wrong?
They want the following:
Dailys at 6 days.
Weekly at 4 weeks
Monthly at 11 months
Yearly at 7 years.
The problem is, my DBAs are telling me that RMAN cannot handle multiple retentions. It's a single global retention and nothing else.
My understanding is that calling this line "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF x DAYS;" in the RMAN script before each backup occurs, with x replaced by the number of days that equal our retentions would do the trick.
Am I wrong?