joaotelles
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
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
ASKER
Any reliable document for the Dataguard configuration you can suggest?
Something that would also include the network pre-requisites.
Something that would also include the network pre-requisites.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.