Oracle 3 node RAC to 1 standby node & further node add through RAC
905854Dec 16 2011 — edited Dec 21 2011For the Oracle solution architects, I have an interesting situation.
The production site contains 3 server nodes and clustered using Oracle RAC, database replication will be done with the help of Oracle Data guard. As a minimum, the DR site will have a single physical server working in Physical Standby mode.
Tricky situation: DR environment is also shared by a testing environment. This testing enviornment have 3 database servers working in RAC cluster. These servers will have 2 images, one for Testing network and one for DR network. Now, when the actual DR will invoke, the Testing image would be shut down and DR image will start working and will join the 1st Physical DR Server node and eventually becomes a 4 node DR.
Database: Oracle 11g, Replication s/w: OGD, Backup s/w RMAN
How is this going to work? and technical difficulties involved?