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

Posted on 2011-09-29
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
  • 3
  • 3
  • 3
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 333 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 119

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 167 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?

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

LVL 119
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 -
Snaphot Best Practices -

Also check out the following Snapshot Articles by Eric Siebert

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 119
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 333 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

830 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