dbTalk Databases Forums  

Help needed for Database Replication

comp.databases.oracle comp.databases.oracle


Discuss Help needed for Database Replication in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Anshul Seth
 
Posts: n/a

Default Help needed for Database Replication - 03-22-2005 , 11:01 PM






Hi All,

I am currently handling a J2EE application with the Application server
as Weblogic 7.0 SP2 and Database on Oracle 9.2.1.0.

The client wants to setup a test environment, and as the application
is mission-critical, it would be of great help if the production and
test DB are in sync in real-time.

Can any one of you please guide me on this issue?
I did read about Multi-Master Replication, but don't know much about
it.
If somebody has used it, please explain the steps, the problems and
roadblocks one generally faces while implementing it.

Also, my requirement is one way replication, i.e. from production to
test and not vice versa, not that the changes done in test should
reflect in the production.

Please guide.

Thanx.
Anshul Seth

Reply With Quote
  #2  
Old   
jwarnick
 
Posts: n/a

Default Streams - 03-24-2005 , 02:49 AM






Check out Oracle Streams. It can handle one-way replication b
reading the archive logs and applying the changes to the downstrea
(your test) database


Reply With Quote
  #3  
Old   
dinko
 
Posts: n/a

Default Re: Help needed for Database Replication - 04-06-2005 , 05:50 AM




"Anshul Seth" <sethanshul (AT) yahoo (DOT) com> wrote

Quote:
Hi All,

I am currently handling a J2EE application with the Application server
as Weblogic 7.0 SP2 and Database on Oracle 9.2.1.0.

The client wants to setup a test environment, and as the application
is mission-critical, it would be of great help if the production and
test DB are in sync in real-time.

Can any one of you please guide me on this issue?
I did read about Multi-Master Replication, but don't know much about
it.
If somebody has used it, please explain the steps, the problems and
roadblocks one generally faces while implementing it.

Also, my requirement is one way replication, i.e. from production to
test and not vice versa, not that the changes done in test should
reflect in the production.

Please guide.

Thanx.
Anshul Seth



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.