• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

Oracle 11g - Dataguard configuration

Hi,

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?

Tks,
Joao
0
joaotelles
Asked:
joaotelles
  • 2
  • 2
  • 2
  • +1
3 Solutions
 
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.
0
 
joaotellesAuthor Commented:
Any reliable document for the Dataguard configuration you can suggest?

Something that would also include the network pre-requisites.
0
 
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.

http://docs.oracle.com/cd/E11882_01/server.112/e41134/toc.htm

It has:
2.3 Data Guard Operational Prerequisites
2.3.1 Hardware and Operating System Requirements
2.3.2 Oracle Software Requirements
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
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 -> http://docs.oracle.com/cd/E11882_01/server.112/e41134/create_ps.htm#SBYDB00200  The examples and steps in there are pretty detailed.
0
 
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.

Tks,
Joao
0
 
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.
0
 
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now