Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 2027 invoked from network); 11 Dec 2007 13:29:22 -0600
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 11 Dec 2007 13:29:22 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7496D7D78C6;
 Tue, 11 Dec 2007 14:29:22 -0500 (EST)
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 23773-03; Tue, 11 Dec 2007 14:29:22 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D69257D7330;
 Tue, 11 Dec 2007 14:29:21 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 11 Dec 2007 14:27:13 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A0B807D7659
 for <oracle-l@freelists.org>; Tue, 11 Dec 2007 14:27:13 -0500 (EST)
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 23364-04 for <oracle-l@freelists.org>;
 Tue, 11 Dec 2007 14:27:13 -0500 (EST)
Received: from rn-out-0102.google.com (rn-out-0910.google.com [64.233.170.191])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 686FA7D7805
 for <oracle-l@freelists.org>; Tue, 11 Dec 2007 14:27:12 -0500 (EST)
Received: by rn-out-0102.google.com with SMTP id e24so384328rng
        for <oracle-l@freelists.org>; Tue, 11 Dec 2007 11:27:12 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
        bh=g6HdVZhsGm7T2YDakLb4qKYqCFcfelC5YahtBUV9cDM=;
        b=FeI7Ltj70xSdM0IOg5XXXc6C3xOEd6FEHBuLNnLkmgSmqfElbyr6Y6iFL1PtcaYBglpiw5sjp03ySWGD5G/Ky0P7U2YygG/t7ZuMiHpzua5JIQ1iH5xgMXNbvCPQGks5yd1gfrCHF6wzNZMhGYJYVq9jfPNhtQhKUlbeGUj2OQw=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type;
        b=p/DgKF4NO96OOE7Z0YDIlvhUSQjSBAfNrk7V2Xor91BUNEbA1drqoo/OTc6cl3qlOWsYzfKy5xStevqzWoCwfpBMlGxWlItLRm2GtcS4CCwiRXSOH4KHtTZdAc4rsp4H8TAN5xvWTq43k/2BhiD4UKbd7ZmPvJaFWIlvxdNplhs=
Received: by 10.150.182.17 with SMTP id e17mr972441ybf.1197401232275;
        Tue, 11 Dec 2007 11:27:12 -0800 (PST)
Received: by 10.150.186.11 with HTTP; Tue, 11 Dec 2007 11:27:12 -0800 (PST)
Message-ID: <3c5f7820712111127o2689bd9t4bb5af2decc6d67d@mail.gmail.com>
Date: Tue, 11 Dec 2007 12:27:12 -0700
From: "Sandra Becker" <sbecker6925@gmail.com>
To: oracle-l <oracle-l@freelists.org>
Subject: Logminer failure
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_7354_5575750.1197401232244"
X-archive-position: 3847
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: sbecker6925@gmail.com
Precedence: normal
Reply-to: sbecker6925@gmail.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain
------=_Part_7354_5575750.1197401232244
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Oracle Standard Edition 1, Ver. 9.2.0.8
RHEL 4.1

I've opened an SR with Oracle, but they haven't responded yet and I was
hoping someone could point me in the right direction.  We accidentally
deleted some data one of our customers needs to do their year-end
processing.  We know when it happened and thought we could use logminer to
get the undo statements.  Unfortunately, every time we run the query to get
the sql_undo from v$logmnr_contents, we get an ORA-03113
end-of-communication channel error.  Any suggestions?  I lost my standby
database on Saturday night and I'm still recovering that database so
logminer is my only hope right now.

Thanks in advance.

Sandy

------=_Part_7354_5575750.1197401232244
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Oracle Standard Edition 1, Ver. <a href="http://9.2.0.8">9.2.0.8</a></div>
<div>RHEL 4.1</div>
<div>&nbsp;</div>
<div>I&#39;ve opened an SR with Oracle, but they haven&#39;t responded yet and I was hoping someone could point me in the right direction.&nbsp; We accidentally deleted some data one of our customers needs to do their year-end processing.&nbsp; We know when it happened and thought we could use logminer to get the undo statements.&nbsp; Unfortunately, every time we run the query to get the sql_undo from v$logmnr_contents, we get an ORA-03113 end-of-communication channel error.&nbsp; Any suggestions?&nbsp; I lost my standby database on Saturday night and I&#39;m still recovering that database so logminer is my only hope right now.
</div>
<div>&nbsp;</div>
<div>Thanks in advance.</div>
<div>&nbsp;</div>
<div>Sandy</div>

------=_Part_7354_5575750.1197401232244--
--
http://www.freelists.org/webpage/oracle-l


