Re: Q:Multi-Master Replication and Table Reorganization

Eric

Some good points, now that I think about it some more.

What version are you running - 7 or 8? With 7, you were able to export the table, disable the replication triggers, import the table and then re-enable the triggers. With 8 having internal triggers you can't do that any more, but the offline_instantiation begin and end load procedures may help instead.

HTH. Pete

Eric Comeau wrote:

> Hi Pete,
>
> Thanks for the reply, I suspected and was hoping you would provide some input on the subject as I see you
> post answers to many of the Replication Questions/Issues. I will post a follow-up to the net once I get further
> input from Oracle Support or others on the Net.
> (PS. please don't take the Oracle Support comments derogatory. I simply meant that because I have bronze
> support they are only required to provide a reply in 48 hrs. I was hoping to get an answer over the weekend
> from the newsgroup.)
>
> Well I had the following concerns with the procedure you described and decided I would attempt a simple test
> before replying. My concerns were:
> 1) dbms_reputil.replication_off only works on the current working session
> 2) suspending replication activity prohibits further updates therefore it should prohibit the import.
>
> Both concerns appear to be valid, unless I did something wrong.
>
> Thanks for the suggestion. Any others?
>
> Pete Sharman wrote:
>
> Eric
>
> Why remove the table from the rep group?
>
> I prefer not to remove the table from the rep-group as I am concerned with making sure all the proper conflict
> resolution gets re-added.
>
> If you can stop changes being made
> at the other masters, what I would do instead is:
>
> a. Execute dbms_reputil.replication_off at each instance.
>
> I have used the dbms_reputil.replication_off to turn off replication for my personal session, but I did not believe
> it turned it off system-wide. I ran a test where I opened two sessions (even used the same userid). In session1 I
> ran the "Execute dbms_reputil.replication_off" procedure. In the second session I ran an update on a replicated
> table. The update was pushed into the deferred queue and to the other site.
>
> b. Export the objects from the database where the data needs
> reorganizing.
> c. Truncate the tables.
> d. Import the objects.
>
> Did not attempt this based on my analysis from running the above.
>
> e. Execute dbms_reputil.replication_on on all sites.
>
> Haven't thought through it thoroughly, but that should work. Now if you
> can't stop changes going on at the other masters, that's a different
> ballgame, but I think from memory the recommendation is to suspend
> replication anyway before doing this.
>
> I suspected you would have to suspend activity at all sites, but I would prefer not, this will be a challenge to
> coordinate. Second whenever I suspend replication, you can no longer before update to any replicated tables,
> unless there is some special imp parameter. Below is the error returned when I attempted the import.
>
> IMP-00058: ORACLE error 23326 encountered
> ORA-23326: object group ARMY_NETID is quiesced
> Import terminated successfully with warnings.
>
> HTH.
>
> Pete
>
> Eric Comeau wrote:
>
> > How does one perform a table reorganization (export/import) in a
> > Multi-Master Replicated environment (with say four master sites) without
> > having the import replicate to the other sites?
> >
> > I have read through all the Oracle Replication manuals and there is no
> > discussion of the topic under any of the "Administering a Replicated
> > Environment" sections.
> >
> > When I posed the question to one Oracle Consultant, his answer was you
> > had to remove the table from the replication group, perform the
> > reorganization and then add the table in again.
> >
> > I have placed a call with Oracle Support and am awaiting their answer,
> > but since I only have bronze support, I only expect an answer next week.
> >
> > Eric Comeau
> > ecomeau_at_baynetworks.com
>
> --
> Regards
>
> Pete

--
Regards

Pete

Received on Fri Jul 16 1999 - 14:57:24 CDT