Backup of enterprise applications (Microsoft stack, IBM Db2, Oracle, PostgreSQL, SAP)
Post Reply
lowlander
Service Provider
Posts: 450
Liked: 30 times
Joined: Dec 28, 2014 11:48 am
Location: The Netherlands
Contact:

Transaction Logs to Capacity Tier

Post by lowlander » 1 person likes this post

Hi,

can we copy transaction logs to object storage ?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by foggy »

No, transaction log backups are not copied to Capacity Tier.
rweis
Veeam Software
Posts: 460
Liked: 71 times
Joined: Jun 13, 2011 7:46 pm
Full Name: Randy Weis
Location: Raleigh, NC, USA
Contact:

Re: Transaction Logs to Capacity Tier

Post by rweis »

@foggy I understand that granular intervals of restore (using logs, for example) aren't consistent with the idea of long term retention points. However, if a backup jobs takes advantage of the new copy/move feature of SOBR with Capacity Tier, and the use of GFS in the primary job definition, SQL transaction log backups are left on-premise (like it used to be with backup copy jobs). So if I want to get a copy of my transaction log backups offsite, I need a Backup Copy Job, which now supports copying transaction log backups. Correct?
Randy Weis
Enterprise SE, NA Strategic Accounts
Gostev
Chief Product Officer
Posts: 31459
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Transaction Logs to Capacity Tier

Post by Gostev » 1 person likes this post

That is correct, Randy.
jmarstoncr
Lurker
Posts: 1
Liked: never
Joined: Aug 25, 2020 1:08 am
Full Name: Jake Marston
Contact:

Re: Transaction Logs to Capacity Tier

Post by jmarstoncr »

Has anyone figured out a good workaround for this, that doesn't require storing a duplicate copy of data?
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Transaction Logs to Capacity Tier

Post by HannesK »

Hello,
and welcome to the forums.

as of today, there is no "integrated workaround".

Best regards,
Hannes
FLS_Nick
Influencer
Posts: 18
Liked: 2 times
Joined: Mar 06, 2019 2:49 pm
Full Name: Nick Mahlitz
Contact:

[MERGED] Agent For Linux Central Managed - Archive Logs Secondary Copy?

Post by FLS_Nick »

Hi,

I have a physical server running Oracle databases that is being backed up by Veeam Agent on Linux to a Veeam B&R Server where the agent is manged by the B&R Server.

The backup of the databases lands in a scaleable repo with performance tier local and capacity tier in Azure and that works well.

We are backing up the database logs every 15 mins via the Veeam B&R server that is set to grab the logs direct from the physical server and stores in the local repo but if I lose my data centre then it is only the backups that are in Azure that are available, I see no way to get the logs that are stored by Veeam for redo restores to be sent to the capacity tier along with the backups.

Is there a way to do this via Veeam so I have copies of the backup in Azure AND copies of the logs in Azure via Veeam or is the assumption you will hive off the logs to a seconday location and simply use Veeam to backup the logs in that secondary location?
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Transaction Logs to Capacity Tier

Post by HannesK »

Hello,
please see the answers above.

With Oracle you cloud maybe use the RMAN plugin where we introduced capacity tier support with V11.

Best regards,
Hannes
eduzimrs
Service Provider
Posts: 56
Liked: 7 times
Joined: Jul 25, 2018 5:08 pm
Full Name: Eduardo Scheffer
Location: Florianopolis - Brazil
Contact:

Re: Transaction Logs to Capacity Tier

Post by eduzimrs »

Hi,

Any feature requests about copying Databases Logs to Capacity Tier ? Is this in Veeam's Roadmap?
I'm backing up my Oracle Physical Servers with Agents targeting a SOBR, the only way to achieve this is using RMAN plugin then?

Thanks.
--
Best Regards.
Eduardo K. Scheffer - SE
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Transaction Logs to Capacity Tier

Post by HannesK »

Hello,
same in V11, yes.

We count your request +1

Thanks,
Hannes
eduzimrs
Service Provider
Posts: 56
Liked: 7 times
Joined: Jul 25, 2018 5:08 pm
Full Name: Eduardo Scheffer
Location: Florianopolis - Brazil
Contact:

Re: Transaction Logs to Capacity Tier

Post by eduzimrs »

Is it OK to coexist RMAN Plugin Backups along Image backups with Agent to get the full protection by the Capacity Tier feature?
I'm aware about the Oracle Archive Logs, we can have only one tool managing it, so i would disable Log processing within AAIP.

Thanks.
--
Best Regards.
Eduardo K. Scheffer - SE
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Transaction Logs to Capacity Tier

Post by HannesK »

Hello,
yes, if disable the log processing for image based backups, then RMAN can be used.

Best regards,
Hannes
mark49808
Enthusiast
Posts: 83
Liked: 13 times
Joined: Feb 02, 2017 6:31 pm
Contact:

Re: Transaction Logs to Capacity Tier

Post by mark49808 »

+1 for this feature. Is this possibly coming to v12?
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Transaction Logs to Capacity Tier

Post by HannesK »

for V12, we are extending object storage support massively. the plan is to support database logs to object storage, yes
lowlander
Service Provider
Posts: 450
Liked: 30 times
Joined: Dec 28, 2014 11:48 am
Location: The Netherlands
Contact:

Re: Transaction Logs to Capacity Tier

Post by lowlander »

Cool,

Will there be a capacity penalty for the object storage storing these logs ?
Gostev
Chief Product Officer
Posts: 31459
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Transaction Logs to Capacity Tier

Post by Gostev »

What do you mean?
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Transaction Logs to Capacity Tier

Post by HannesK »

the plan is to support database logs to object storage, yes
I need to clarify this statement... database logs of application aware image processing backup (SQL etc.) can be stored on object storage with backup jobs or backup copy jobs. For capacity tier, V12 will be same as V11 - no copy of database logs. So if you need a copy on object storage, the backup copy job would be the way to go (instead of capacity tier)
TheBrain82
Influencer
Posts: 14
Liked: never
Joined: Mar 01, 2022 1:53 pm
Full Name: Oleg the Brain
Contact:

Re: Transaction Logs to Capacity Tier

Post by TheBrain82 »

Hello, does someone knows whether this behavior "For capacity tier, V12 will be same as V11 - no copy of database logs" did change somehow with V12.1?
Cheers,
Gostev
Chief Product Officer
Posts: 31459
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Transaction Logs to Capacity Tier

Post by Gostev »

I don't see this mentioned in the official What's New in 12.1 document. @PetrM will know what are our plans here.
PetrM
Veeam Software
Posts: 3229
Liked: 520 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Transaction Logs to Capacity Tier

Post by PetrM »

Hello,

Correct, there are no changes in 12.1 but we see this request quite often and it definitely makes sense to think about implementation in one of our future releases. Let's say we have such plans but I'm not ready to share ETA.

As a workaround, you may point the backup job directly to an object storage repository.

Thanks!
mv@cloudio.dk
Service Provider
Posts: 3
Liked: 1 time
Joined: Sep 06, 2019 11:30 am
Full Name: Martin Veng
Contact:

Re: Transaction Logs to Capacity Tier

Post by mv@cloudio.dk » 1 person likes this post

+1 for this feature. Is a deal breaker for using Capacity Tier.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests