Hi All,
Currently we are using Oracle 10g (10.2.0.4) 2 node RAC with same structure of DR in 2 locations with active-passive scenario (dataguard).
Primary:
INST_ID HOST_NAME INSTANCE_NAME OPEN_MODE DATABASE_ROLE
------- --------------- -------------- ------------ --------------
1 dxxxxx01 instd1 READ WRITE PRIMARY
2 dxxxxx02 instd2 READ WRITE PRIMARY
Standby:
INST_ID HOST_NAME INSTANCE_NAME OPEN_MODE DATABASE_ROLE
------- --------------- -------------- ------------ --------------
1 rxxxxx01 instr1 READ ONLY PHYSICAL STANDBY
2 rxxxxx02 instr6 READ ONLY PHYSICAL STANDBY
We need to make the DR setup as Active-Active, I need such configuration to ensure if my Primary site becomes unavailable, standby should automatically pointed to application without switch over or fail over operations with zero downtime.
Please guide me on below,
1) Is it possible to implement Active-Active concept with current environment (with 10g db and dataguard)? If yes how can I plan for that? (to my knowledge read-write mode is not possible parallel in primary and secondary)
2) Is it possible from upgrading to 11g without Active dataguard ?
3) How can we do this with Active dataguard?
Thanks