Home » Server Options » Replication » Database Synchronisation. (Oracle 10g)
Database Synchronisation. [message #399652] Thu, 23 April 2009 05:37 Go to next message
JasjotS
Messages: 12
Registered: March 2008
Location: India
Junior Member

Hi All,

Below is my requirement:
I need to keep my two databases (one in oracle 10.1.0.4 & one in 10.2.0.4) in sync. Both databases can be updated during runtime, hence creating a sync batch will not help.

As per my understanding, replication is the solution for us. It would be appreciated if any expert can confirm on this.

If replication is the best solution, then I have following queries:
What are the requirements for the oracle replication?
Does it require any specific hardware/network, or it can be done by doing some settings or executing scripts?

Regards,
Jasjot
Re: Database Synchronisation. [message #399663 is a reply to message #399652] Thu, 23 April 2009 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/toc.htm

Regards
Michel
Re: Database Synchronisation. [message #399665 is a reply to message #399663] Thu, 23 April 2009 06:28 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Yes. Advanced Replication help you.

>>one in oracle 10.1.0.4 & one in 10.2.0.4)

If you use replication; but need keep same database version on both site.


>>What are the requirements for the oracle replication?

It's depent's you. What's your requirement to implement replication?

>>Does it require any specific hardware/network, or it can be done by doing some settings or executing scripts?

Both database located in same/differnet place; Network require. Smile

Babu
Re: Database Synchronisation. [message #399666 is a reply to message #399652] Thu, 23 April 2009 06:39 Go to previous messageGo to next message
JasjotS
Messages: 12
Registered: March 2008
Location: India
Junior Member

Thanks for the reply!

Let me further describe my problem.
I have an oracle 10.1.0.4 database which is used by two applications: App1 & App2.
Both applications update the database from online.

As per the client requirement we need to upgrade to 10.2.0.4, but app2 has compatibility issue with 10.2.0.4.
So, the plan is to have 2 databases [one(10.2.0.4) for app1 & another(10.1.0.4) for app2]

If you mean to say that the requirement for replication is to have both databases with same version, then it will not work for me Sad

Is there any other solution?
Re: Database Synchronisation. [message #399727 is a reply to message #399666] Thu, 23 April 2009 14:37 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


You con't.

>>but app2 has compatibility issue with 10.2.0.4

What's the problem?

babu
Previous Topic: Materialized view
Next Topic: Sending email to administrator when Refresh fails
Goto Forum:
  


Current Time: Thu Mar 28 17:57:28 CDT 2024