Discussions specific to the Microsoft Hyper-V hypervisor
Post Reply
mdecker77
Novice
Posts: 4
Liked: 1 time
Joined: Sep 05, 2013 3:15 pm
Full Name: Martin Decker
Contact:

Oracle Archive Log Deletion every x minutes

Post by mdecker77 » Oct 31, 2018 9:45 am 1 person likes this post

Dear Veeam-Community,

for a customer installation we are facing difficulties with the configuration of veeam backup job for application-aware oracle processing.

The database is running in Archivelog Mode and is producing a high volume of archivelog data per hour. Filesystem space is limited, therefore we want to perform archivelog backup every 20 minutes and then delete the archivelogs after the backup in order to prevent space issues in archivelog filesystem.

We have followed this procedure:
https://helpcenter.veeam.com/docs/backu ... tml?ver=95

It seems that with this configuration, the deletion of archivelogs is not done every x minutes by the archivelog backup job, but only once per day with the parent incremental backup job.

How can the deletion of archivelogs every X minutes be accomplished with Veeam?

Best Regards,
Martin

wishr
Veeam Software
Posts: 1103
Liked: 112 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Oracle Archive Log Deletion every x minutes

Post by wishr » Oct 31, 2018 10:54 am

Hi Martin,

Have you tried using the "Delete logs older than <N> hours" setting mentioned in the article? It should fit your use-case.

Thanks,
Fedor

mdecker77
Novice
Posts: 4
Liked: 1 time
Joined: Sep 05, 2013 3:15 pm
Full Name: Martin Decker
Contact:

Re: Oracle Archive Log Deletion every x minutes

Post by mdecker77 » Oct 31, 2018 11:48 am

Hi Fedor,

yes of course. We have specified:

-> Delete logs older than 1 hours
-> Backup logs every 20 minutes
-> Retain log backups: until the corresponding image-level backup is deleted.

The "delete logs older than"-Option only performs the delete operation once per day, not every 20 minutes. We see that every 20 minutes, archivelogs are backed up, but not deleted. the delete operation only takes place once per day.

How can the deletion of archivelogs every X minutes be accomplished with Veeam?

Regards,
Martin

wishr
Veeam Software
Posts: 1103
Liked: 112 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Oracle Archive Log Deletion every x minutes

Post by wishr » Oct 31, 2018 1:01 pm

Hi Martin,

Thanks for clarifying.

Currently, the deletion of the logs archived logs based on their age/size is done when an image backup is being made (parent job), however, we do plan to implement a set of changes to this functionality and make the deletion process to go along with the logs backup job (child one). Please stay tuned for updates.

As a temporary workaround, you may set your parent job to run more frequently.

Regards,
F

mdecker77
Novice
Posts: 4
Liked: 1 time
Joined: Sep 05, 2013 3:15 pm
Full Name: Martin Decker
Contact:

Re: Oracle Archive Log Deletion every x minutes

Post by mdecker77 » Oct 31, 2018 1:43 pm

Thank you very much for this definitive answer. We will increase frequency of parent job and are awaiting updates ... ;-)

wishr
Veeam Software
Posts: 1103
Liked: 112 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Oracle Archive Log Deletion every x minutes

Post by wishr » Oct 31, 2018 2:14 pm 1 person likes this post

Welcome and thank you for the feedback!

@everyone, if anybody else is interested in having the aforementioned feature in place - please do not hesitate to post your comments here.

Thanks,
Fedor

drom
Lurker
Posts: 1
Liked: never
Joined: Oct 31, 2018 9:44 am
Full Name: Patrick Liebenow

Re: Oracle Archive Log Deletion every x minutes

Post by drom » Oct 31, 2018 2:29 pm

Hello there,

we are facing the exact same issues here as Martin. Looking forward to related features be introduced with any future Veeam release. :)

Thank you,
Patrick

Post Reply

Who is online

Users browsing this forum: No registered users and 13 guests