Oracle Data Guard Design

All posts relating to Oracle database administration.

Moderator: Tim...

Oracle Data Guard Design

Postby peterx » Mon Apr 23, 2012 6:58 am

hi Tim,

Is it possible and realistic to form a Data Guard Infrastructure with 10 sites (different locations)
to a single Machine with 10 standby databases?

Anything needed to consider?

thanks
Last edited by peterx on Fri May 11, 2012 1:30 pm, edited 1 time in total.
peterx
Senior Member
 
Posts: 189
Joined: Wed Feb 09, 2011 7:07 am

Re: Oracle Data Guard Design

Postby Tim... » Mon Apr 23, 2012 8:49 am

Hi.

From a performance perspective it is not reasonable because the primary server would experience 10 times the overhead servicing all the standby databases.

Instead, it is recommended to take a cascading approach. The primary server supports only a few standby databases (1-3), which in turn cascad their changes to another layer of standby databases.

http://docs.oracle.com/cd/E11882_01/ser ... m#BEHBIGHF

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Oracle Data Guard Design

Postby peterx » Wed May 02, 2012 11:08 am

hi Tim,

very thanks.

Then, any doc or guideline for me to plan the requirements for 10 site DR solution.

How to estimate the network traffic for all the Data Guard Traffic.

Any oracle official doc guide to plan the network (throughput) or hardware requirements ?

thanks
peterx
Senior Member
 
Posts: 189
Joined: Wed Feb 09, 2011 7:07 am

Re: Oracle Data Guard Design

Postby Tim... » Wed May 02, 2012 11:19 am

Hi.

Apart form the doc link already posted, not really sure where to go to next. You could always raise an SR with Oracle to see if they have any whitepapers about similar installations.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 7 guests