Re: Replication

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Thu, 8 Sep 2011 10:07:46 -0700 (PDT)
Message-ID: <1315501666.10880.YahooMailNeo_at_web161217.mail.bf1.yahoo.com>

Upendra
Thanks for the information.IF I will stop the Do Deferred job, is that will stop my Replication Queue or call from generating. What I meant to say as disabling the Replication setup. Will later on remove the setup.

Rgds

Sanjay

---

From: Upendra N <nupendra_at_hotmail.com> To: smishra_97_at_yahoo.com; oracle-l_at_freelists.org Sent: Thursday, September 8, 2011 12:43 PM Subject: RE: Replication  

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

Received on Thu Sep 08 2011 - 12:07:46 CDT