Active Active Oracle Database set up across data centres

[former_member239802]

Hi,

We have a customer who is interested in moving their existing infrastructure to an Active Active Database configuration, they have several SAP systems including ECC, CRM and PI. They currently have an Oracle database clustered in one data center and then use Oracle Data Guard to replicate the database into a 2nd DC. Now they want to configure the Database as Active Active across the data centers, they want always on set up, just in case they lose one of the DC's so that they wont lose the database for the minutes to hours for fail over to the 2nd DC that they currently have.

We are looking at Extended RAC across the DC's but this will also mean additional Network upgrades so its looking quite expensive, any other options?

thanks

Simon. 

[fidel_vales]

AFAIK, the only option to have an active active DB is RAC.

it is expensive, not only for what you mention but also the license itself

[SDH1]

You can use Hardware replication which replicates the DISKs from DC#1 to DC#2. We have set this up and have been using it without any issues for over 6 yrs now. You do not need Oracle dataguard for this.When DC#1 fails, you can switch over to DC#2 and startup Oracle which will perform automatic recovery during startup (no need to apply any redologs or perform manual recovery).

[former_member239802]

Hi Salim, thanks response, but I assume thats not going to be Active Active, i.e. always on and running DB in both DC's. Your solution is using hardware replication and there will be a time when no access to the system is available whilst the DB in DC2 starts up after the failure in DC1. We potentially want one SAP and DB spanning across the 2 DC's so that if one fails then users wont see the failure.