RE: Replication

Missed your first question.. If you disabled this job, it doesn't mean you stop capturing the data. Data capture is done through internal triggers, it will stop only when you drop the repgroup or remove the object from the repgroup.

Here is how you can check how many transactions are sitting in the queue to be delivered:

select count(*),dblink from deftrandest group by dblink;

The above query will list each of the master sites and the number of transactions queued up for replication.

-Upendra

> From: nupendra_at_hotmail.com
> To: smishra_97_at_yahoo.com; oracle-l_at_freelists.org
> Subject: RE: Replication
> Date: Thu, 8 Sep 2011 12:43:01 -0400
>
> Hey Sanjay,
> After breaking the replication jobs, you need to make the surviving site as MDS by relocating it.
>
> dbms_repcat.relocate_masterdef(gname IN VARCHAR2,
> old_masterdef IN VARCHAR2,
> new_masterdef IN VARCHAR2,
> notify_masters IN BOOLEAN := FALSE, -- If this is the only Master site left, you should set this to FALSE.
> include_old_masterdef IN BOOLEAN := FALSE, -- You need to set this to FALSE if you don't have all the master sites up now.
> require_flavor_change IN BOOLEAN := FALSE);
>
> Here is how you could check who is the current master site is:
> select gname,dblink,masterdef from dba_repsites order by 2;
>
> You could remove the repgroups on the surviving site(s):
> exec dbms_repcat.drop_master_repgroup(-
> gname=>'<REPGROUP_NAME>',-
> DROP_CONTENTS=>false,- -- This will retain all the replicated tables while the repgroup is being removed
> ALL_SITES=>false); -- This will ensure no communication is sent to the other master sites
>
> You may want to check for errors before and after the process in dba_repcatlog.
> You may want to simulate the testing in a non-production environment before executing this in production.
> Hope this helps.
> -Upendra
>
>
> > Date: Thu, 8 Sep 2011 08:32:57 -0700
> > From: smishra_97_at_yahoo.com
> > Subject: Replication
> > To: oracle-l_at_freelists.org
> >
> > I had one Replication Setup which is Multimaster setup done earlier in 11g R1. Now we consolidated three Server part of the Database into one and so one of the Master Site is final consolidated one. So need to remove Replication setup.
> > 1. If I disabled the do Deffered Job then is that stop capturing the data means Replication is disabled
> >
> > 2. What is process to remove Rep Setup when MDS is no longer available like some steps. e.g Relocate MDS, Drop ..
> >
> > TIA
> > Sanjay
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
                                               

--
http://www.freelists.org/webpage/oracle-l