Solved

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

Posted on 2011-09-29
9
402 Views
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
0
Comment
Question by:darkbluegr
  • 3
  • 3
  • 3
9 Comments
 
LVL 76

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:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/concepts.htm

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

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE)
Andrew Hancock (VMware vExpert / EE MVE) 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)
0
 

Author Comment

by:darkbluegr
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?

Thanks!
0
 
LVL 118
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
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 76

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:
http://forums.veeam.com/viewtopic.php?f=2&t=1141

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.
0
 

Author Comment

by:darkbluegr
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?
0
 
LVL 118
ID: 36817311
VMware Data Recovery, will not provided the Step DR functions of Veeam Replication every 15 minutes.
0
 
LVL 76

Accepted Solution

by:
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.
0
 

Author Comment

by:darkbluegr
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!
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
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 videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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…

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now