Re: ** replication remove

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Mon, 23 Oct 2006 18:47:29 +0200

Very simple.

Connect, in sqlplus, as replication manager and then do:

begin
dbms_repcat.drop_master_repgroup(
gname => 'group name',
drop_conetnts => false,
all_sites => false);
end;
/

The trick is in: all_sites => false that tell it not to go and search for the other server.
We did it to test working with the second server when the first one is down.


Adar Yechiel
Rechovot, Israel



A Joshi wrote:

Yavor,
Thanks. Master2Master. Advanced replication. Thanks a lot for pointing me to the note 241943.1.
So if it is de-supported then what would be the way to get rid of replicaiton. Once the database is replicated it would be difficult to do database quiesce (suspend) also. since there will not be a secondary. Thanks.


*//*
<http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>

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


Other related posts: