Beginner wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1185520675.121146_at_bubbleator.drizzle.com...
>> Beginner wrote:
>>> Hi,
>>>
>>> we have currently a multi-master replication environment where we have
>>> four databases. Now we have to move one database to another node.
>>>
>>> Any hints what we have to consider
>>>
>>> Thank you in advance!
>>>
>>> db
>> First hints are:
>>
>> 1. Version of Oracle
>> 2. Operating system
>> 3. What is your definition of "node?"
>>
>> My recommendation unless you have a paleolithic version of Oracle is to
>> bury multi-master replication in a shallow unmarked grave and go to
>> streams.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
>
> Hi,
>
> thank you for your comments
>
> 1. Oracle 9.2.0.8
> 2. HP-UX
> 3. node = in this case new physical server
>
> Yes, we are planning to start using streams :)
>
> db
Then invest your efforts there. If CDC (Change Data Capture)
will do what you want it is easier to implement than Streams
but not until you go to 10g.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Jul 29 2007 - 00:07:45 CDT
