Home » Server Options » Replication » Syncronize database server data (oracle 10.2, linux)
Syncronize database server data [message #474578] Tue, 07 September 2010 06:22 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Dear all,

we have four location, four database server seperatly,

we need to syncronize all the servers.

for example. all the server gaving table parts
if the parts_count column change in server. it showuld be change all the four servers

please help me, how to syncronize


thanks
Re: Syncronize database server data [message #474579 is a reply to message #474578] Tue, 07 September 2010 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What are the allowed options?
Are you ready to buy additional Oracle options or products?
Or do you want to do it by custom scripts?

Regards
Michel
Re: Syncronize database server data [message #474582 is a reply to message #474579] Tue, 07 September 2010 06:38 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Please Michel

give me the both options
Re: Syncronize database server data [message #474603 is a reply to message #474582] Tue, 07 September 2010 08:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are numerous possible options, I will not a research for you that will take me several days of work.

Here's one: Never directly change part_count in one server, use a procedure that changes it in ALL servers.

Regards
Michel

[Updated on: Tue, 07 September 2010 08:36]

Report message to a moderator

Re: Syncronize database server data [message #485825 is a reply to message #474603] Fri, 10 December 2010 05:30 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
you can do the real time syncronization by using oracle Golden gate all 4 database servers.

Thanks-
P
Re: Syncronize database server data [message #485908 is a reply to message #485825] Sat, 11 December 2010 03:42 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

If am correct you can go by Advanced Replication / Data Guard & RAC
Previous Topic: golden gate : manager not starting
Next Topic: Materialized view - background process
Goto Forum:
  


Current Time: Thu Mar 28 10:35:43 CDT 2024