Re: Database to a new server within multi-master replication environment

On Apr 22, 2:16 am, "Beginner" <begin..._at_nospam.com> wrote:
> "DA Morgan" <damor..._at_psoug.org> wrote in message
>
> news:1208823088.188513_at_bubbleator.drizzle.com...
>
>
>
> > Beginner wrote:
> >> Hi there,
>
> >> who has planned and succesfully done a database move to a new server with
> >> multi-master environment.
>
> >> What needs to be considered beforehand?
>
> >> tia
> >> jb
>
> > If you are planning multi-master replication the best thing to do is hit
> > drop a brick on your foot. If you enjoyed the feeling do it two more
> > times. If you still are having fun multi-master replication is for you.
>
> > Non-masochists implement streams.
> > --
> > Daniel A. Morgan
> > Oracle Ace Director & Instructor
> > University of Washington
> > damor..._at_x.washington.edu (replace x with u to respond)
> > Puget Sound Oracle Users Group
> >www.psoug.org
>
> Actually we already have multi-master replication in place but now we need
> to move one instance to another server...

I've done it couple of years back. Followed the directions for offline instantiation
in the manual. Went quite smoothly.
Basically added another master site in the new server using offline instantiation
and dropped the old site.
Did test it also in a test env. I advise you do so also so that you can be comfortable
with the steps.

Anurag Received on Tue Apr 22 2008 - 09:45:41 CDT