OraFAQ Forum: Data Guard » Replication from Many Database (Single Instances) to Single Database (Multiple Instances)

Home » Server Options » Data Guard » Replication from Many Database (Single Instances) to Single Database (Multiple Instances) (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #488941]

Wed, 12 January 2011 07:01

iar1967
Messages: 5
Registered: January 2011
Location: Malaysia

Junior Member

Hi,

I have a clients who currently implementing an application that using Oracle 10g in 20 distributed location. Each location will have its own database server and locally managed. I plan to create a Disaster Recovery (DR) Centre for this client in centralised location. I plan to setup 20 Application Server but only one database server with 20 instances. My question, can the Dataguard manage the replication between 20 database (with single instances) and single database (with 20 instances? The reason we design such way is to reduce the license cost of Oracle.

Thank you in advance for your response and advice.

Report message to a moderator

Re: Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #488965 is a reply to message #488941]

Wed, 12 January 2011 09:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I plan to create a Disaster Recovery (DR) Centre for this client in centralised location.
DR could be resource limited & not able to keep current with 20 other DB changes.

Report message to a moderator

Re: Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #489351 is a reply to message #488965]

Fri, 14 January 2011 22:21

iar1967
Messages: 5
Registered: January 2011
Location: Malaysia

Junior Member

Definitely it need higher specifications of server at DR to manage the database. Assumne that we are giving sufficient resource of processor and memory for the database server at DR, can DataGuard do the replication from many into one database?

Thanks.

Report message to a moderator

Re: Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #489353 is a reply to message #489351]

Fri, 14 January 2011 22:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>can DataGuard do the replication from many into one database?
NO

Report message to a moderator

Re: Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #489354 is a reply to message #489353]

Fri, 14 January 2011 22:34

iar1967
Messages: 5
Registered: January 2011
Location: Malaysia

Junior Member

Beside having one to one replication, do you know any other method or approach that is practical and economical to synchronise database between multiple production system into centralised DR system.

Report message to a moderator

Re: Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #489355 is a reply to message #489354]

Fri, 14 January 2011 23:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What is DBID?
What is SCN?
What is schema?

How do you keep objects unique?

Report message to a moderator

Re: Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #489356 is a reply to message #489355]

Fri, 14 January 2011 23:39

iar1967
Messages: 5
Registered: January 2011
Location: Malaysia

Junior Member

Yes, those are my concerns too.

Report message to a moderator

Re: Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #489358 is a reply to message #489351]

Fri, 14 January 2011 23:55

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

iar1967 wrote on Sat, 15 January 2011 05:21

Definitely it need higher specifications of server at DR to manage the database. Assumne that we are giving sufficient resource of processor and memory for the database server at DR, can DataGuard do the replication from many into one database?

Streams.

Regards
Michel

[Updated on: Fri, 14 January 2011 23:55]

Report message to a moderator

Re: Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #489361 is a reply to message #489358]

Sat, 15 January 2011 00:13

iar1967
Messages: 5
Registered: January 2011
Location: Malaysia

Junior Member

Thanks Mike for your input. I will read through those documents. So far I have not found topics that touch on replication of database instances.

Report message to a moderator

Re: Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #489363 is a reply to message #489361]

Sat, 15 January 2011 01:12

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you read the book it is just about replication of databases/schemas/tables from one or many databases to one or many databases, Oracle or not.

Regards
Michel

[Updated on: Sat, 15 January 2011 01:12]

Report message to a moderator

Previous Topic:	Resources of data Guard
Next Topic:	Database Fault Tolerance solution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 31 05:39:14 CDT 2025