This forum is currently locked. You can't register or post questions at this time. (read more)

Oracle Data Guard Design

All posts relating to Oracle database administration.

Moderator: Tim...

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

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.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

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

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 6 guests