Home » Server Options » Data Guard » Replication from Many Database (Single Instances) to Single Database (Multiple Instances) (Oracle 10g)
icon5.gif  Replication from Many Database (Single Instances) to Single Database (Multiple Instances) [message #488941] Wed, 12 January 2011 07:01 Go to next message
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 26730
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.
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member
>can DataGuard do the replication from many into one database?
NO
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member
What is DBID?
What is SCN?
What is schema?

How do you keep objects unique?
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 Go to previous messageGo to next message
iar1967
Messages: 5
Registered: January 2011
Location: Malaysia
Junior Member
Yes, those are my concerns too.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67283
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.
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 Go to previous message
Michel Cadot
Messages: 67283
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Tue Aug 04 12:57:18 CDT 2020