Discussions specific to the VMware vSphere hypervisor
Post Reply
electricd7
Expert
Posts: 117
Liked: 7 times
Joined: Mar 27, 2012 10:13 pm
Full Name: Chad Killion
Contact:

Need example pre-freeze / post scripts for Oracle 11g r2

Post by electricd7 » Jun 19, 2014 12:35 pm

Hello,

I am going to start backing up a windows server which is running Oracle 11g R2. Can anyone provide me an example of a working pre-freeze / post-thaw script that I can use to make sure that oracle is in the proper mode for backup when the snapshot is taken? Thanks.

foggy
Veeam Software
Posts: 18278
Liked: 1564 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Need example pre-freeze / post scripts for Oracle 11g r2

Post by foggy » Jun 19, 2014 1:20 pm

Chad, as far as I know, Oracle 11g has VSS writer, so you can back it up with application-aware image processing enabled instead of using pre-freeze/post-thaw scripts.

electricd7
Expert
Posts: 117
Liked: 7 times
Joined: Mar 27, 2012 10:13 pm
Full Name: Chad Killion
Contact:

Re: Need example pre-freeze / post scripts for Oracle 11g r2

Post by electricd7 » Jun 19, 2014 1:55 pm

Right, but the customer is used to doing the offline backup and would like to continue this process, so I am trying to make the backup process with veeam as close to what they are used to in the physical world as possible.

Vitaliy S.
Product Manager
Posts: 23001
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Need example pre-freeze / post scripts for Oracle 11g r2

Post by Vitaliy S. » Jun 19, 2014 2:56 pm

In this case I believe you can simply initiate procedure of stopping and starting services via Windows cmdline, though since it is possible to do backups without any downtime then why not to leverage this opportunity? ;)

electricd7
Expert
Posts: 117
Liked: 7 times
Joined: Mar 27, 2012 10:13 pm
Full Name: Chad Killion
Contact:

Re: Need example pre-freeze / post scripts for Oracle 11g r2

Post by electricd7 » Jun 19, 2014 3:05 pm

Keep in mind I am not an Oracle DBA. If I use the VSS method for backing up Oracle, am I able to use my archive logs to get back to a point in time after a restore? Ie, restore VM to last nights full, reply archive logs to get back to 6 hours later? This is the feature which is missing for SQL with Veeam and I am wondering if its missing for Oracle as well? I know currently they do a DB offline, storage snap, DB online, backup from storage snap. I would like to replicate this process if I am unable to reply archive logs after a restore in Veeam.

Vitaliy S.
Product Manager
Posts: 23001
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Need example pre-freeze / post scripts for Oracle 11g r2

Post by Vitaliy S. » Jun 19, 2014 3:22 pm

Point in time restores and logs archiving for Oracle is not available natively, you will be able to restore your Oracle VM to the date and time you have created the restore point to. If you archive logs via 3rd party tools (for example, with RMAN), then you should be able to get back to 6 hours and later after restoring the entire VM. A bit more info can be found in this post > Questions regarding Backup/Recovery of Oracle database

With SQL Server it should be possible to do natively in v8 though, see this blogpost for more info > http://www.veeam.com/blog/the-veeam-exp ... d-sql.html

Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests