Data Guard Configuration on 11g RAC One Node
I have a 11g RAC One Node environment. One node is always active and the second node is passive(down). If the active node goes down, it will relocate automatically to the second node. I've also configured dataguard (not using DG Broker) to keep a consistent copy of my database on a DR site. This is a physical standby. Now, I DO NOT intend to failover to the DR site. I will only use the DR site to offload work from my production such as backup and making sure that I always have a hot copy online.
The question is how do I prevent my primary server from automatic failover to physical standby (DR site)?