Do archive logs in long-term (archival) backups count toward log file backup count?
Oracle DB 12.2.0.1 / RHEL
I currently have a daily RMAN backup of my database with a recovery window of 14 days that runs each evening. I also have a job that runs every 2 hours that backs up my archive logs and once an archive log has been backed up twice it is deleted.
I now need to setup an additional backup job that will run monthly and be retained for 365 days. I've researched this and my understanding is that in this case I would need to use the 'keep until time' parameter to specify that this should be kept for a year and not fall under my normal recovery window. In this case of a long term backup, the docs say that the archivelogs needed for a consistent backup and the spfile will also be backed up automatically.