Re: Monthly RMAN Long Term Backup

Hi Sallie,

Please have a read of this document:

RMAN Archival (KEEP) backups and Retention Policy (Doc ID 986382.1)

KEEP backups in 11g no longer play in the same sandbox as other DR backups. The feature was expanded in 11g to provide an archival backup mechanism that would not disturb nightly backup activity. In general a KEEP backup only knows about other KEEP backups with the same TAG. Regular archivelog backups will only become obsolete if there is a full or level 0 backup taken, and these backups fall outside the retention policy.

Cheers,

Leng.

> On 9 Mar 2021, at 8:34 am, Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov> wrote:
>
> 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
>
> <image001.png>

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