Received: (qmail 25599 invoked from network); 28 Mar 2011 23:52:55 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 28 Mar 2011 23:52:39 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9DD84DB2263; Tue, 29 Mar 2011 00:52:31 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Ov4GSntSou54; Tue, 29 Mar 2011 00:52:31 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A1548DB0F05; Tue, 29 Mar 2011 00:51:48 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 29 Mar 2011 00:51:07 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DE509DB0DDE for ; Tue, 29 Mar 2011 00:51:06 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id pmFkM9sPdhQs for ; Tue, 29 Mar 2011 00:51:06 -0400 (EDT) Received: from VA3EHSOBE001.bigfish.com (va3ehsobe001.messaging.microsoft.com [216.32.180.11]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A192DDB0DEF for ; Tue, 29 Mar 2011 00:51:04 -0400 (EDT) Received: from mail155-va3-R.bigfish.com (10.7.14.236) by VA3EHSOBE001.bigfish.com (10.7.40.21) with Microsoft SMTP Server id 14.1.225.8; Tue, 29 Mar 2011 04:51:00 +0000 Received: from mail155-va3 (localhost.localdomain [127.0.0.1]) by mail155-va3-R.bigfish.com (Postfix) with ESMTP id DB30010181E3; Tue, 29 Mar 2011 04:51:00 +0000 (UTC) X-SpamScore: -4 X-BigFish: VPS-4(zz4015Lzz1202hzz8275bhz2fh2a8h668h61h) X-Spam-TCS-SCL: 0:0 X-Forefront-Antispam-Report: KIP:(null);UIP:(null);IPVD:NLI;H:mspinfrasym2.corp.medtronic.com;RD:nd242247.global.medtronic.COM;EFVD:NLI Received: from mail155-va3 (localhost.localdomain [127.0.0.1]) by mail155-va3 (MessageSwitch) id 1301374259999730_7083; Tue, 29 Mar 2011 04:50:59 +0000 (UTC) Received: from VA3EHSMHS012.bigfish.com (unknown [10.7.14.242]) by mail155-va3.bigfish.com (Postfix) with ESMTP id ED581CC8052; Tue, 29 Mar 2011 04:50:59 +0000 (UTC) Received: from mspinfrasym2.corp.medtronic.com (144.15.242.247) by VA3EHSMHS012.bigfish.com (10.7.99.22) with Microsoft SMTP Server (TLS) id 14.1.225.8; Tue, 29 Mar 2011 04:50:55 +0000 X-AuditID: 0a30376f-b7ca0ae00000347a-5f-4d91652e5128 Received: from mspmail2.medtronic.com ( [10.48.80.44]) (using TLS with cipher AES256-SHA (AES256-SHA/256 bits)) (Client did not present a certificate) by mspinfrasym2.corp.medtronic.com (Symantec Mail Security) with SMTP id C1.F0.13434.E25619D4; Mon, 28 Mar 2011 22:50:54 -0600 (CST) Received: from MSPM1BMSGH07.ent.core.medtronic.com ([10.48.55.62]) by mspmail2.medtronic.com (8.13.8+Sun/8.13.8) with ESMTP id p2T4os5E028984 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=FAIL); Mon, 28 Mar 2011 23:50:54 -0500 (CDT) Received: from MSPM1BMSGM22.ent.core.medtronic.com ([10.48.55.203]) by MSPM1BMSGH07.ent.core.medtronic.com ([10.48.55.62]) with mapi; Mon, 28 Mar 2011 23:50:54 -0500 From: "Mandal, Ashoke" To: "exriscer@gmail.com" CC: Oracle Mailinglist Date: Mon, 28 Mar 2011 23:50:53 -0500 Subject: Manual removal of replication in Oracle 8.1.7.4 Thread-Topic: Manual removal of replication in Oracle 8.1.7.4 Message-ID: <6548C7B531E1364BAE8F77112F31A1199D905CFD@MSPM1BMSGM22.ent.core.medtronic.com> References: <6548C7B531E1364BAE8F77112F31A1199AD00799@MSPM1BMSGM22.ent.core.medtronic.com> In-Reply-To: <6548C7B531E1364BAE8F77112F31A1199AD00799@MSPM1BMSGM22.ent.core.medtronic.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_6548C7B531E1364BAE8F77112F31A1199D905CFDMSPM1BMSGM22ent_" MIME-Version: 1.0 X-Brightmail-Tracker: AAAAAQAAAZE= X-OriginatorOrg: medtronic.com X-archive-position: 35351 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ashoke.k.mandal@medtronic.com Precedence: normal Reply-To: ashoke.k.mandal@medtronic.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --_000_6548C7B531E1364BAE8F77112F31A1199D905CFDMSPM1BMSGM22ent_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Greetings, The asynchronous replication (between two databases) has broken. For some re= ason 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 th= e replication. Do any of you have the manual steps to remove and cleanup the replication fr= om both of the databases(master definition site and master site). Thanks, Ashoke [CONFIDENTIALITY AND PRIVACY NOTICE]=0A= =0A= Information transmitted by this email is proprietary to Medtronic and is int= ended 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 autho= rity, you are notified that any use or dissemination of this information in= any manner is strictly prohibited. In such cases, please delete this mail f= rom your records.=0A= =0A= To view this notice in other languages you can either select the following l= ink or manually copy and paste the link into the address bar of a web browse= r: http://emaildisclaimer.medtronic.com --_000_6548C7B531E1364BAE8F77112F31A1199D905CFDMSPM1BMSGM22ent_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Greetings,
 
The asynchronous replication (between two databas= es) has broken. For some reason the repgroup at the master definition site is no= t accessible. I couldn't see it through replication manager. But could query a= s follows:
 
SQL> select gname, status from dba_repgroup;
 
GNAME       &n= bsp;            =       STATUS
------------------------------      =   ---------------
REPGROUP_1        = ;        NORMAL
 
But I am not allowed to suspend the replication o= r do anything to cleanup the replication.
 
Do any of you have the manual steps to remov= e and cleanup the replication from both of the databases(master definition site an= d master site).
 
Thanks,
Ashoke

[CONFIDENTIALITY AND= PRIVACY NOTICE]=0A= =0A= Information transmitted by this email is proprietary to Medtronic and is int= ended 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 autho= rity, you are notified that any use or dissemination of this information in= any manner is strictly prohibited. In such cases, please delete this mail f= rom your records.=0A= =0A= To view this notice in other languages you can either select the following l= ink or manually copy and paste the link into the address bar of a web browse= r: http://emaildisclaimer.medtronic.com

--_000_6548C7B531E1364BAE8F77112F31A1199D905CFDMSPM1BMSGM22ent_-- -- http://www.freelists.org/webpage/oracle-l