| Database Synchronisation. [message #399652] |
Thu, 23 April 2009 05:37  |
|
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 #399665 is a reply to message #399663] |
Thu, 23 April 2009 06:28  |
|
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. 
Babu
|
|
|
| Re: Database Synchronisation. [message #399666 is a reply to message #399652] |
Thu, 23 April 2009 06:39 |
|
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 
Is there any other solution?
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
