Manual removal of replication in Oracle 8.1.7.4

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Mon, 28 Mar 2011 23:50:53 -0500
Message-ID: <6548C7B531E1364BAE8F77112F31A1199D905CFD_at_MSPM1BMSGM22.ent.core.medtronic.com>



Greetings,

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 replication.

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).

Thanks,
Ashoke

[CONFIDENTIALITY AND PRIVACY NOTICE] 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 records. 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: http://emaildisclaimer.medtronic.com

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 28 2011 - 23:50:53 CDT

Original text of this message