Operating System - HP-UX
1753427 Members
4682 Online
108793 Solutions
New Discussion

Re: drop the multimaster replication set up

 
Nirmalkumar
Frequent Advisor

drop the multimaster replication set up

Hi,

i have dropped the multimaster replication setup by the following steps

1.Login as repadmin user

2.execute dbms_repcat.suspend_master_activity(gname=>'REPLIC');

3.execute dbms_repcat.drop_master_repobject('DL','TEST12','TABLE');

4.execute dbms_repcat.remove_master_databases('REPLIC','DL.PNGEDMS2.AMD.COM');

5.execute dbms_repcat.drop_master_repgroup('REPLIC');


Replication Group name : REPLIC
Object and schema used for replication: TEST12 and DL
Master site : DL.PNGEDMS2.AMD.COM


The above things are i have did in master defintion site.all the things are dropped fine in master definition site.i have checked the dba_repsites and dba_repobject views ,did not find any records.

In the master site,i found the records in dba_repsies and dba_repobject views.the found records are the records which i have dropped in master definition site.

please help me out how to remove the records in master site or anything need to alter in the dropping steps which i have did in master def. site.

Thanks,
Nirmal.
1 REPLY 1
Yogeeraj_1
Honored Contributor

Re: drop the multimaster replication set up

hi Nirmal,

If you have access to metalink, please refer to "7. Drop Replication setup" in note 250048.1


hope this helps!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)