02-18-2021 10:34 AM
Hello all. We have Managers high up they say we need to keep all Oracle Archive Logs for infinity to tape. We backup thousands and thousands of Archive Logs a day and they have been sent to tape for years using netbackup. Does this sound way over board. Some of the DBA's say this is rediculaus. I am no DBA so I am not 100% sure what these archive logs ae for. Does anyone hear know a DBA or is a DBA thant can help me convince them that infinity is to log?
02-18-2021 04:42 PM
02-18-2021 06:32 PM
What @pats_729 said. Your manager should ask for an RPO from his manager in writing and not just words. We keep archivelogs for 1-3 months and Full/Diff backups are kept from 3months to several years. Find out the RPO and add a buffer to it to be on safer side to get a retention figure for archivelogs. Other things to keep in mind are compliance and litigation hold.
One good way in corporate world for the managers high up to make an informed decision about how long to keep the archivelogs would be to provide them numbers in $$$ about how much it costs to keep them to infinity.Keeping two copies of archivelogs on tapes for 10 years will definitely add up with frequent archivelog backups!
BTW, infinity retention date just changed from 2038 to 3000 in NetBackup 9.0
02-19-2021 12:52 AM
My take on this:
Keeps archive log files as long as you keep Oracle backups *
It does not make sense at all, to keep archive files longer than the database backups.
* There is more to it, if oracle backup also contain archive files to perform media recovery, then archive files can be kept shorter. I would say the sweet spot for point in time recovery = 1-3 months.