How to backup Oracle

#1 VM Backup : Modern Data Protection for VMware vSphere and Microsoft Hyper-V

How to backup Oracle

Veeam Logoby cicero » Fri May 29, 2009 4:56 pm

Hi,

does anybody have experiences about snapshoting a
Oracle-Server for backing him up?

- if I just take a snapshot, the backedup-oracle is only
crash-consistent, but maybe i can reliable recover it afterwards when nesesary?

- or does somebody use prefreeze/postthaw scripts, putting oracle in
backup mode for a snapshot and set it back online afterwards?
I think applications depending on the database will crash without their DB
in these minutes between the two scripts...
But maybe the oracle backup mode is transparent to applications
since it uses the archivelogs?

- I'm currently using Orache 10g on a Linux RHEL4, so VSS may today
be not an option for me, but may it be helpful if i move
to Orace 11g on Windows 2008 in this behavior?

Thanks, David
cicero
Enthusiast
 
Posts: 39
Liked: never
Joined: Wed Mar 18, 2009 9:48 am
Full Name: David Winkler

Re: backup Oracle-Server using snapshots

Veeam Logoby Gostev » Fri May 29, 2009 5:26 pm

David, Oracle for Windows does have VSS writer component for sure.
I would also like to hear feedback from customers running Oracle on Windows and using Veeam Backup VSS integration.

Thank you!
Gostev
Veeam Software
 
Posts: 15626
Liked: 786 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

Re: backup Oracle-Server using snapshots

Veeam Logoby alexr » Tue Jun 02, 2009 4:29 am

I do not believe oracle before 11g has VSS.
We use

ALTER SYSTEM SUSPEND;
and
ALTER SYSTEM RESUME;

on freeze/thaw which will essentially hold IO while snapshot is done. Not perfect but better than nothing perhaps
alexr
Enthusiast
 
Posts: 63
Liked: never
Joined: Sun Jan 01, 2006 1:01 am

Re: backup Oracle-Server using snapshots

Veeam Logoby cicero » Tue Jun 02, 2009 8:07 am

Hi Alexr,

sounds to be ok for replication the Oracle VM to a save place,
since we additional take a RMAN Full Backup of the data too.
Did you already test te recovery successful?

What is your freeze/thaw skript like?
Maybe you could post it?

Thank you, David
cicero
Enthusiast
 
Posts: 39
Liked: never
Joined: Wed Mar 18, 2009 9:48 am
Full Name: David Winkler

Re: backup Oracle-Server using snapshots

Veeam Logoby alexr » Thu Jun 04, 2009 5:17 am

freeze:
set ORACLE_SID=ora1
sqlplus /nolog @D:\oracle\stop.sql > D:\oracle\stop.log

where stop.sql is

connect system/password as sysdba;
ALTER SYSTEM SUSPEND;
exit;

thaw is the opposite.

I have not tested restore yet but it is definetely better than nothing and better than VMware driver (forgot its name) to syspend IO on OS level which used to crash oracle all the time and cause all sorts of problems
alexr
Enthusiast
 
Posts: 63
Liked: never
Joined: Sun Jan 01, 2006 1:01 am

Re: backup Oracle-Server using snapshots

Veeam Logoby Gostev » Sun Jun 21, 2009 9:34 am

It's called "sync driver" and yes it does corrupt MSSQL and Oracle databases. Just as FYI for new users, Veeam Backup disables sync driver automatically when Veeam VSS is used, and if it is not used but you still want it disabled, there is a check box in advanced job settings for this.
Gostev
Veeam Software
 
Posts: 15626
Liked: 786 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

Re: backup Oracle-Server using snapshots

Veeam Logoby stevenfoo » Sat Jun 27, 2009 2:17 pm

We are also using Oracle 10g on Windows with 2 VM instance.

I would like to know where to put the script SUSPEND (before snapshot) and RESUME (after snapshot)?

Any documentation and steps?

Thanks
Steven
stevenfoo
Enthusiast
 
Posts: 77
Liked: never
Joined: Fri Jun 26, 2009 3:11 am
Full Name: Steven Foo

Re: backup Oracle-Server using snapshots

Veeam Logoby Gostev » Mon Jun 29, 2009 10:46 am

Steven,

Check out this blog post:
http://blog.ntgconsult.dk/2009/05/vmwar ... cript.html

You can Google on the following keywords for more information (using these scripts on other operating systems etc.)
vmware pre-freeze post-thaw

Thanks!
Gostev
Veeam Software
 
Posts: 15626
Liked: 786 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

Re: backup Oracle-Server using snapshots

Veeam Logoby digitaud » Tue Jul 07, 2009 6:11 pm 1 person likes this post

Yes sirs... Oracle 11g has a coponent named "Oracle VSS Writer" :shock: that installs when selecting Windows OCI Components on the Oracle 11g database install wizard. It does support Oracle 10g also starting from patchset 10.2.0.3 (See MetaLink for download).

We use it with a W2K3 R2 and 10g 10.2.0.3. Veeam starts windows VSS agent and VSS starts Oracle VSS Writer, does the full consistent hot-backup of the database and then I use a script to clean archive logs and traces manually.

This is working like a charm for us and the problem of backing up Oracle is over.

You can see more information to: http://download-uk.oracle.com/docs/cd/B ... 10/vss.htm

Thanks!
digitaud
Lurker
 
Posts: 1
Liked: 1 time
Joined: Thu Jun 18, 2009 2:32 pm
Full Name: Adam Viusa

Re: backup Oracle-Server using snapshots

Veeam Logoby Gostev » Tue Jul 07, 2009 6:38 pm

Thanks Adam - this is great piece of information!
Gostev
Veeam Software
 
Posts: 15626
Liked: 786 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

Feature Request: Option to run Pre-scripts

Veeam Logoby athome » Thu May 26, 2011 7:35 am

[merged]

Hi!

I have a customer that would like the ability to run scripts before Veeam starts the job, (ie. a script that shuts down an oracle database inside a VM)

Does Veeam have plans to implement this feature?

A
athome
Enthusiast
 
Posts: 45
Liked: 1 time
Joined: Fri Jul 16, 2010 9:26 am
Full Name: Anders Thome

Re: How to backup Oracle

Veeam Logoby Vitaliy S. » Thu May 26, 2011 7:48 am

No plans, as this functionality is already available with VMware Tools pre-freeze and post-thaw scripts.
Vitaliy S.
Product Manager
 
Posts: 11729
Liked: 411 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: How to backup Oracle

Veeam Logoby rileybloke » Mon Oct 10, 2011 7:14 pm

Hello,

I am currently using Veeam 5.0.1 - replicating an Oracle 11g server every hour. We have the oracle VSS installed.
We have found that some oracle sessions are orphaned intermittantly when the snapshot is removed.
How can we tell if Veeam is using the Oracle VSS writers, or has anyone else encountered issues like this before?

Thanks
rileybloke
Member
 
Posts: 14
Liked: never
Joined: Mon Oct 10, 2011 7:10 pm
Full Name: Phil Riley

Re: How to backup Oracle

Veeam Logoby Gostev » Mon Oct 10, 2011 8:28 pm

Hi Phil, in the Windows event log you should see events from Oracle VSS writer at the same time when VM snapshot is created. Please check to see if you can see them. Another thing to check is run vssadmin list writers in the command prompt, and make sure Oracle VSS writers are listed and do not report any errors. Thanks!
Gostev
Veeam Software
 
Posts: 15626
Liked: 786 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

Re: How to backup Oracle

Veeam Logoby NetWise » Tue Oct 11, 2011 2:35 pm

Is anyone doing Veeam backups like this on a 'big' (big to me anyway) Oracle server? We have 10g running on 2008 R2 and I did some monkeying around to do a test that stopped the import/replay of logs from our primary to our standby, so I could do backups of the standby. This was needed because without stopping it, the 2.5TB VM was getting 200MB/1-2 minutes of Archive Logs to replay, and of course the snapshot just took forever to deal with. Even doing it this way, attached to a 10GbE SAN, it took 8 hours to do a full backup, and 5 hours to do a diff backup. Then the associated catchup after for the Archive Log replay. Now I know this isn't a Veeam problem - if we made a snapshot on that VM for an hour or so just to do patches and didn't stop the Archive Log Replay, the same thing happens, so this is simply an issue with VMware snapshots on such a large VM. But there must be other people out there doing backups/replication of a large VM that is this busy as well at the disk level? As an example, my 2.45TB became a 640GB VBK, but the next day the Diff created a 120GB VBR (reverse-incremental mode), which tells me that about 20-25% of my blocks/data are changing per day..... :(
NetWise
Member
 
Posts: 12
Liked: 2 times
Joined: Wed Aug 26, 2009 5:52 pm
Full Name: Avram Woroch

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Alexa [Bot], Google [Bot], Vitaliy S. and 19 guests