Manual removal of replication in Oracle

  • From: "Mandal, Ashoke" <ashoke.k.mandal@xxxxxxxxxxxxx>
  • To: "exriscer@xxxxxxxxx" <exriscer@xxxxxxxxx>
  • Date: Mon, 28 Mar 2011 23:50:53 -0500


The asynchronous replication (between two databases) has broken. For some 
reason the repgroup at the master definition site is not accessible. I couldn't 
see it through replication manager. But could query as follows:

SQL> select gname, status from dba_repgroup;

GNAME                          STATUS
------------------------------        ---------------
REPGROUP_1                NORMAL

But I am not allowed to suspend the replication or do anything to cleanup the 

Do any of you have the manual steps to remove and cleanup the replication from 
both of the databases(master definition site and master site).



Information transmitted by this email is proprietary to Medtronic and is 
intended for use only by the individual or entity to which it is addressed, and 
may contain information that is private, privileged, confidential or exempt 
from disclosure under applicable law. If you are not the intended recipient or 
it appears that this mail has been forwarded to you without proper authority, 
you are notified that any use or dissemination of this information in any 
manner is strictly prohibited. In such cases, please delete this mail from your 
To view this notice in other languages you can either select the following link 
or manually copy and paste the link into the address bar of a web browser:

Other related posts: