Comprehensive data protection for all workloads
Post Reply
sainathpawar14
Novice
Posts: 3
Liked: never
Joined: Jun 17, 2015 8:04 am
Full Name: sainath pawar
Contact:

SAP + RMAN + Sql sanpshot backup using Veam

Post by sainathpawar14 »

Hi All,

I am new to veeam backup & replication.

I would like to know how to implement snapshot backup of SAP , Oracle, Sql database backup using veeam.

earliest reply would be appreciable.

Thanks & Regards
Sainath Pawar
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: SAP + RMAN + Sql sanpshot backup using Veam

Post by PTide »

Hi Sainath,

Could you give me more details, please?

What kind of SAP are you talking about?
Do you use Windows or Linux version of Oracle?

SQL database backups in Windows environment are conducted via usage of VSS mechanism. You can find more details about the subject here:

http://helpcenter.veeam.com/backup/80/v ... ssing.html

So, if you perform a hot-backup of your SQL database in Windows environment with application-aware processing option enabled, I can assure you that your database will be totally fine. You also can adjust logs backup, if you want.
sainathpawar14
Novice
Posts: 3
Liked: never
Joined: Jun 17, 2015 8:04 am
Full Name: sainath pawar
Contact:

Re: SAP + RMAN + Sql sanpshot backup using Veam

Post by sainathpawar14 »

Hi PTide,

Thanks for your reply.

I am using EMC networker tool for backing up File system & database backup resides on VM (Windows & Suse Linux). EMC provide snapshot backup technology for file system backup and VSS technlolgy to take image base backup for sql database

but i am looking for snapshot backup for SAP & Oracle , sql database along with the file system snapshot backup. Hope so it will be possible using veeam Tool

We have both windows & linux version of oracle.

Could you please elaborate what kind of SAP question.

Thanks & Regards
Sainath



actually i am looking for snapshot
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: SAP + RMAN + Sql sanpshot backup using Veam

Post by PTide » 1 person likes this post

Could you please elaborate what kind of SAP question.
I messed up SAP with something else, sorry about that.

Unfortunately, Veeam v8 does not support EMC storage snapshots, though v9 will do, but only for VNX/VNXe storages.

Could you clarify something please:

You have an Oracle Database with SAP atop of it residing on a VM, correct?

If so, then...

1. Windows-based Oracle

Veeam app-aware processing supports transactionally consistent backups with Oracle VSS Writer installed. Make sure that your Oracle version supports VSS Writer installed. Otherwise, please use any of the methods below

2. Linux based Oracle

Three ways to do that from most to least intrusive. All methods requires ARCHIVE LOGS mode, NOARCHIVELOGS mode supports cold backups only.

2.1 Performing suspend/resume of database, requires usage of pre-freeze and post-thaw scripts.

2.2 Putting all tables in hot backup mode, requires usage of pre-freeze and post-thaw scripts.

2.3 Doing crash-consistent backup, does not require usage of pre-freeze/post-thaw scripts. The transaction consistency gained via usage of RMAN from the inside of VM running your Oracle DB. Please see details here.

More on SAP backups here

Thank you.
dellock6
Veeam Software
Posts: 6137
Liked: 1928 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: SAP + RMAN + Sql sanpshot backup using Veam

Post by dellock6 »

On Oracle we have a dedicated whitepaper with different example, it may help: http://www.veeam.com/wp-veeam-data-prot ... ments.html

Luca
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2022
Veeam VMCE #1
sainathpawar14
Novice
Posts: 3
Liked: never
Joined: Jun 17, 2015 8:04 am
Full Name: sainath pawar
Contact:

Re: SAP + RMAN + Sql sanpshot backup using Veam

Post by sainathpawar14 »

Hi Luca,

Thanks for the doc.

1. Could you please explain flow of oracle backup in Veeam. ( Note that we have Suse Linux OS VM and Oracle10g/11 , No Rac installation).

as per the guide , definitely we have to use script but is that script can do L0 , L1 and archive backup.

2. How we can do SAP database backup using Veeam ?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SAP + RMAN + Sql sanpshot backup using Veam

Post by foggy »

Starting v9 Veeam B&R will feature Oracle-aware backup, so you would not need to play with scripts, etc.
Post Reply

Who is online

Users browsing this forum: No registered users and 250 guests