Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multi-master Replication: Add/Remove Master Sites

Re: Multi-master Replication: Add/Remove Master Sites

From: Eric Comeau <ecomeau_at_sympatico.ca>
Date: Thu, 1 Nov 2001 20:12:11 -0500
Message-ID: <cumE7.14387$Fy2.2963009@news20.bellglobal.com>


Check the internal catalogs to see what they say - all_repgroup.

Actually I just fixed a similar problem I had in my development database today. In my case, (since its a dev db - I have been adding and dropping replication groups and renaming the database a few times). I had renamed the database global_name and an old replication group was still hanging around. When I went into the GUI it would not appear, but if I checked the catalogs it was there. If I tried to drop it via the API call it would't find it (I think it was complaining with the group was not mastered at this site) and fail with an error. When I would try to create a group withthe same name, it failed on a unique name error - similiar to what you mention below.

In the end I renamed the database back to the orginal global-name (by looking at the catalog all_repsites to see what sites participated in the replication group) and I was able to drop it.

I don't believe you have the same exact same problem, but maybe this give you some ideas and as I mention above, look into the catalogs to see what the database think's it has configured.

<user_at_domain.invalid> wrote in message
news:3BE0BC11.8020100_at_domain.invalid...
> Hi,
>
> We have a muliti-master replication group with four master sites. We
> removed two sites from the group using:
>
> DBMS_REPCAT.REMOVVE_MASTER_DATABASES()
>
> Now we would like add the two sites back to the group. However, when we
> used:
>
> DBMS_REPCAT.ADD_MASTER_DATABASE()
>
> we got error: "Replication group gname already exists at the site master".
>
> Any idea?
>
> TIA
> Eric
>
Received on Thu Nov 01 2001 - 19:12:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US