OraFAQ Forum: Replication » Database Synchronisation.

Home » Server Options » Replication » Database Synchronisation. (Oracle 10g)

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

Database Synchronisation. [message #399652]

Thu, 23 April 2009 05:37

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

Report message to a moderator

Re: Database Synchronisation. [message #399663 is a reply to message #399652]

Thu, 23 April 2009 06:21

Michel Cadot
Messages: 68418
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

Report message to a moderator

Re: Database Synchronisation. [message #399665 is a reply to message #399663]

Thu, 23 April 2009 06:28

babuknb
Messages: 1734
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

Report message to a moderator

Re: Database Synchronisation. [message #399666 is a reply to message #399652]

Thu, 23 April 2009 06:39

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?

Report message to a moderator

Re: Database Synchronisation. [message #399727 is a reply to message #399666]

Thu, 23 April 2009 14:37

babuknb
Messages: 1734
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 28 23:51:45 CDT 2023