Home » Server Options » Data Guard » Database Fault Tolerance solution (Oracle 11g R2 (11.2.0.2.0))
Database Fault Tolerance solution [message #489258] Fri, 14 January 2011 01:48 Go to next message
prashantgoel1984
Messages: 3
Registered: January 2011
Junior Member
Hi All,

We have the following Fault tolerance Architecture for one of our customers:-

Site 1 (Location A)
===================

1) 2 Application Servers (Weblogic 11, Active-Passive)
2) 2 Database Servers (Dataguard Physical Standby)


Site 2 (Location B)
===================

1) 2 Application Servers (Weblogic 11, Active - Passive)
2) 2 Database Servers (Dataguard Physical Standby)


Following are the further details:-

1) Site1 & Site2 are both Active and are in 2 different TimeZones(WAN connectivity).
2) Primary Databases on both sites have Bi-Directional Stream Replication enabled (Schema Level for Production Schema).
3) 60% of Workload is handled by Site 1 & 40% by Site 2.
4) Like Databases, only 1 Application server is active on each site.
5) The above configuration ensures Disaster Recovery, Load Balancing at both App & DB Layer and also fulfills the requirement of 2 Sites being in Active-Active mode.

Now, another customer has a slightly different requirement. Site 2 will be passive and there will be no requests processed at Site 2. Thus we will have 100% workload at Site 1.

I can think of following Architectures in this case:-

Option 1 : Same as above Architecture
=====================================

Positives:

1) Disaster Recovery
2) Capabiltity of being converted into a Load balancing solution(Active-Active) incase required in future.

Negatives:

1) 3 DB Servers & 3 App Servers not being used for most of time - Too expensive
2) No Load Balancing

Option 2 :
===========

Site 1
=======

1) 2 Database Servers in RAC (Active - Active)
2) 2 Application Servers(Active-Passive)

Site 2
======

1) 2 Database Servers (physical standby for Site 1) in RAC.
2) 2 Application Servers (Passive)

Positives:

1) Disaster Recovery
2) Load Balancing
3) Better Server Utilization
4) More Robust than streams

Negatives:

1) More Costly due to License of both RAC & DG


Kindly let me know if there are any more Positives/negatives in these approaches.

Also, if anyone can suggest another approach for the same.

Please let me know if i need to post this query in a different Section.

Thanks in advance.

Regards,
Prashant





Re: Database Fault Tolerance solution [message #489488 is a reply to message #489258] Mon, 17 January 2011 01:25 Go to previous message
prashantgoel1984
Messages: 3
Registered: January 2011
Junior Member
Any suggestions on this please?

-Prashant
Previous Topic: Replication from Many Database (Single Instances) to Single Database (Multiple Instances)
Next Topic: Auto DB Start on Server Restart
Goto Forum:
  


Current Time: Mon Sep 21 02:12:49 CDT 2020