Link to home
Start Free TrialLog in
Avatar of joaotelles
joaotellesFlag for United States of America

asked on

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
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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.
Avatar of joaotelles

ASKER

Any reliable document for the Dataguard configuration you can suggest?

Something that would also include the network pre-requisites.
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial