Re: Monthly RMAN Long Term Backup

Hello,

To be absolutely sure you did the right thing you`ll need to perform a restore test, otherwise you can just assume you did it right.

You can make use of rman restore preview to anticipate if the actual restore will work:

În lun., 8 mar. 2021 la 23:34, Sallie Cottingham < Sallie.Cottingham_at_cot.tn.gov> a scris:

> 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 <sallie.cottingham_at_cot.tn.gov>* | Direct
> Line 615.401.7962
>
>
>
> [image: A picture containing food Description automatically generated]
>
>
>

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





image/png attachment: image001.png