Re: Monthly RMAN Long Term Backup

From: MacGregor Ian A. <"MacGregor>
Date: Tue, 9 Mar 2021 04:44:39 +0000
Message-ID: <BYASPR01MB43E8CFC6F54DC35843824E2929_at_BYASPR01MB4.namprd07.prod.outlook.com>

Hi Sallie have you considered the impact of Oracle upgrades on your long-term retention strategy?

Ian A. MacGregor
SLAC IT
SLAC National Accelerator Laboratory

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov> Sent: Monday, March 8, 2021 1:34 PM
To: ORACLE-L <oracle-l_at_freelists.org> Subject: Monthly RMAN Long Term Backup

Hi �

I currently have a daily full RMAN backup job that runs each evening and one additional job that runs every 2 hours to backup the archive logs. My setup is that the full backup is kept for a recovery window of 14 days and for the archive log files, once they have been backed up twice they are deleted.

I have a new requirement for a new job to be run monthly to get a full backup of the database and keep that backup for a year. I�ve been researching this and found that to do this I can use the �keep until time sysdate +365� to accomplish this. My understanding is that by using the �keep until� parameter RMAN will backup the database as well as any archive logs needed for a consistent backup. And spfile/control file as well?

I�m trying to understand how the archive logs backups work in this situation. When the monthly backup is run and needed archive logs are included in the backup is that counted against the 2 that I normally want to keep? And also could there be a situation where a needed archive log might have already been backed up twice and therefore been deleted? These monthly backups are going to be written to DDBoost at our DR site and so I�m wanting to be double sure that I know everything needed for a restore is included � but also that I haven�t done anything that would upset my normal backup routine.

Any insight would be helpful � Thanks!

Sallie A. Cottingham, OCP

Database Administrator

Comptroller of the Treasury

Technology Solutions

425 Rep. John Lewis Way N. | Nashville, TN 37243

sallie.cottingham_at_cot.tn.gov<mailto:sallie.cottingham_at_cot.tn.gov> | Direct Line 615.401.7962

[A picture containing food Description automatically generated]

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image001.png

Received on Tue Mar 09 2021 - 05:44:39 CET