Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Necessity of Backup DB (log replication) when running 11g under VMware?

Posted on 2011-09-29
Medium Priority
Last Modified: 2012-05-12
Hello - i need to use Oracle standard 11g for a financial software suite. We are on a tight budget since we are starting up, and I was told we need a backup (standby) database to compliment our primary one. So I was quoted approx 30hrs of DBA time to install and build/configure the production database (which is fine), and then an additional 20hrs of DBA time to install 11g and establish standby database for the main production database.. by using log replication... including setting up all necessary scripts, etc. and on top of that I need another $6000 or so for the database log replication stool that provides redundancy in Oracle Std Edition.

Since I'm going to be running the Oracle VM on VMware, I was thinking I would be better off by getting VMware snapshots of the VM (and backup these snapshots using Veeam as well). Wouldnt this be better than going with the secondary (backup) server approach?

I assume restoring from a snapshot would be faster than running off the "standby" DB server - is this correct?

I realize I have to run a script before the snapshot to quiesce the DB prior to export, (pre-freeze/post-thaw script) after the snapshot, but if these are taken care of, would this approach be risky? and then I assume i have to put the control files in the same vmdk file so i can have everything in my snapshot in case something goes wrong.

Also just wanted to note that i am getting an ongoing monthly support package from the same firm that will be doing the initial oracle configuration, and they support vmware even though oracle officially doesn't.

Would 5 support hrs of DBA per month (proactive and reactive) be considered sufficient for a small database with 5 users?

Thank you
Question by:darkbluegr
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 3
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1332 total points
ID: 36817089
>>Since I'm going to be running the Oracle VM on VMware

Are you aware of Oracle's Support position on VMWare?  

In a nutshell:  If you cannot reproduce a problem on a physical machine to 'show' it is Oracle related and not VM related, they will not provide support.

I would not run a production database in VMWare for this reason.

>> Wouldnt this be better than going with the secondary (backup) server approach?

What is being talked about is probably Oracle Data Guard:

It is much more than a backup/recovery tool/platform.
LVL 124

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 668 total points
ID: 36817094
Veeam Backup and Replication, and replicate your Virtual Machine to another location, every 15 minutes.

But the database would be 15 minutes old, so how much data would be lost in that 15 minutes window.

As for restore of the Veeam Backups, you can start virtual machines from Veeam Backup with actually restoring, so Veeam Restores are Very fast! (if not immediate, or at least 5 minutes)

Author Comment

ID: 36817108
I'm fine with the 15 minute window.. is there any whitepaper from veeam discussing this specifically for Oracle? why is veeam better than a VMware snapshot?

Should I just ask them to go ahead without standby database and without Oracle's log replication software?

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

LVL 124
ID: 36817133
VMware Snapshots are NOT BACKUPS!

A snapshot is NOT a backup of a VM; that is a gross misconception.  

A snap shot is a way to preserve a point in time when the VM was running OK before making changes. A snapshot is NOT a way to get a static copy of a VM before making changes.  When you take a snapshot of a VM what happens is that a delta file gets created and the original VMDK file gets converted to a Read-Only file.  There is an active link between the original VMDK file and the new delta file.  Anything that gets written to the VM actually gets written to the delta file.   The correct way to use a snapshot is when you want to make some change to a VM like adding a new app or a patch; something that might damage the guest OS. After you apply the patch or make the change and it’s stable, you should really go into snapshot manager and delete the snapshot which will commit the changes to the original VM, delete the snap, and make the VMDK file RW. The official stance is that you really shouldn’t have more than one snap at a time and that you should not leave them out there for long periods of time. Adding more snaps and leaving them there a long time degrades the performance of the VM.  If the patch or whatever goes badly or for some reason you need to get back to the original unmodified VM, that’s possible as well.  

I highly recommend reading these 2 articles on VMware Virtual Machine Snapshots:

Understanding Snapshots - http://kb.vmware.com/kb/1015180
Snaphot Best Practices - http://kb.vmware.com/kb/1025279

Also check out the following Snapshot Articles by Eric Siebert

Pt.1- http://is.gd/Lajg4p
Pt.2- http://is.gd/NdKQWC
Pt.3- http://is.gd/tp2vEK
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36817148
>>Should I just ask them ...

I cannot advise you on this.  Only you know your uptime/recovery requirements.

>>from veeam discussing this specifically for Oracle

I'm not a VMWare person but there does appear to be some talk on this subject:

I'm not sure if you would need Oracle VSS or not to make this work.

You did catch my comment on being unsupported in VMWare.

Author Comment

ID: 36817295
thank you both for the insights -

hanccocka - If I may phrase the question now without snapshots, but backups of the VM with either VMware data recovery that came with my essentials plus kit, or Veeam Backup & Replication, would you recommend going this route versus log-based replication of the DB?

slightwv, thank you - understood. Without considering my specific requirements (5 users and small environment overall), in any case - wouldn't VM backup and restore be faster than restoring oracle from the standby server? or would the log-based replication be more robust than what I am suggesting/exploring?
LVL 124
ID: 36817311
VMware Data Recovery, will not provided the Step DR functions of Veeam Replication every 15 minutes.
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 1332 total points
ID: 36817496
>>wouldn't VM backup and restore be faster

Cannot speak to that.  I don't know how long a VM backup/restore will take.

You also need to make sure Oracle will be stable during the VM backup.  You cannot just backup live Oracle files.  I don't know veeam but you need to make sure Oracle can be properly backed up with it.  Otherwise you might not be able to restore.

FYI:  Just because you 'test' it once and Oracle recovers does not mean it will every time.  Over the I have played around with different 'backups' of Oracle where the Admins just performed a filesystem backup (including Oracle datafiles).  Some times Oracle can recover.  Other times, not and the database was trashed.

>>restoring oracle from the standby server

You really don't 'restore' from a data guard standby.  You fail over to it.  This gives you the time to rebuild your primary.  You don't have downtime.

Author Comment

ID: 36817520
Gotcha. I will talk to veeam technical team and see what they say.

This has been very helpful, thank you both very much!

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When speed and performance are vital to revenue, companies must have complete confidence in their cloud environment.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question