Oracle 11g - Dataguard configuration


Im planning to do a Dataguard setup using two separate VMware env each with one VM with Oracle installed. One will be of course the primary DB and the other the standby one.

I was wondering if its feasible to do such setup (taking in consideration of course that the VMs will have connection between each other) and if the Physichal standby configuration would be the best one to go on this setup and if you guys have any 'how to' to recommend to do this task.

Also, once the Dataguard is in place and working, is it feaseble to copy these two VMs that have the Oracle running from their two dif. VMware envs. to another two dif. VMware envs with similar configuration?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Cannot speak to Dataguard best practices.

I always like to point out Oracle's Support policy on VMware:
Support Position for Oracle Products Running on VMWare Virtualized Environments (Doc ID 249212.1)

In a nutshell:
Oracle will only provide support if the issue is a known problem or can be reproduced in a supported environment.  Otherwise you will have to get Oracle Support from VMware itself.

For that reason, I would never run Oracle on VMware in production.
joaotellesAuthor Commented:
Any reliable document for the Dataguard configuration you can suggest?

Something that would also include the network pre-requisites.
slightwv (䄆 Netminder) Commented:
Not a Data Guard person.  Only what I've read about in the docs and online.

I would start in the online docs.

It has:
2.3 Data Guard Operational Prerequisites
2.3.1 Hardware and Operating System Requirements
2.3.2 Oracle Software Requirements
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

johnsoneSenior Oracle DBACommented:
As you are talking about a physical standby, I assume that you are going to use log shipping to keep the standby up to date and are not going with real time apply.  If that is the case, then the network requirement would be that the 2 systems need to be able to talk to each other and ship archives.  What you need beyond that depends on how many archives you are generating.

I would also hope that the 2 virtual machines you are building are on completely separate hardware.  If not, there really isn't a point to doing it, other than as a practice exercise.

As far as a how to on creating a physical standby, I use the documentation ->  The examples and steps in there are pretty detailed.
joaotellesAuthor Commented:
Tks for the clarification and for the links.

I talked about the physical standby but as you explained I fdont think this is what Im looking for.. I need real time apply.. Im assuming now that this would be better achieved with a Logical Standby Database, is this the case?

Any network special requirement for this other than the 2 systems need to be able to talk to each other and enough bandwidth between them?

Yes they are in separate hardware.

johnsoneSenior Oracle DBACommented:
You can create a physical standby with real time apply.  I have never done it, so I don't know what the difference in maintenance is.  There is a difference in the command to start managed recovery, but I'm not sure if there is more than that.

If I was setting it up, I would have a separate NIC for the communication between the 2 machines.  It would be dedicated with all ports open.  Makes life a lot easier.  If that is feasible.
Mark GeerlingsDatabase AdministratorCommented:
Yes, it is possible to set up Oracle11g on VMware and to have a physical standby server with DataGuard in real-time apply mode on a separate VM.

Remember, as others have indicated, Oracle doesn't certify this combination, so whether this is a good idea for your system or not, you will have to decide.  This isn't the safest way to run a production system.

Yes, ideally you would have at least two NICs in your physical machines so one NIC in each VM can be dedicated to the DataGuard log shipping, and the other NIC can handle the "normal" database user connections.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.