RE: Replication

From: Upendra N <nupendra_at_hotmail.com>
Date: Thu, 8 Sep 2011 12:43:01 -0400
Message-ID: <BLU129-W1AD0497A98206E235A45BD81E0_at_phx.gbl>

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 - 11:43:01 CDT