Return-Path: <root@fatcity.cts.com>
Received: from ensim.rackshack.net (root@localhost)
 by orafaq.net (8.11.6/8.11.6) with ESMTP id g9ANd1r13202
 for <oracle-l@orafaq.net>; Thu, 10 Oct 2002 18:39:01 -0500
X-ClientAddr: 209.68.248.164
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164])
 by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id g9ANd0D13197
 for <oracle-l@orafaq.net>; Thu, 10 Oct 2002 18:39:01 -0500
Received: from fatcity.UUCP (uucp@localhost)
 by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id OAA69769;
 Thu, 10 Oct 2002 14:20:38 -0700 (PDT)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004E6420; Thu, 10 Oct 2002 13:53:48 -0800
Message-ID: <F001.004E6420.20021010135348@fatcity.com>
Date: Thu, 10 Oct 2002 13:53:48 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: "Yechiel Adar" <adar76@inter.net.il>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Yechiel Adar" <adar76@inter.net.il>
Subject: Re: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: multipart/alternative;	boundary="----=_NextPart_000_026A_01C270B9.0EFB3500"
------=_NextPart_000_026A_01C270B9.0EFB3500
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

MessageThanks for all the replies.

We called Oracle support and they come with the DUL utility and
extracted the data.

As I write this e-mail imports are running.

Concurrently we tried to restore the last full backup from more then 2 =
weeks ago\
and found about 1 day worth of archive logs missing, so this option is =
out.

We now also restoring last night export to a separate database so in =
case
of logical errors in the imported data they will be able to input the =
deals again
and bring the system up to date.

So now, eleven hours later we hope to finish in a few hours.

Yechiel Adar
Mehish

------=_NextPart_000_026A_01C270B9.0EFB3500
Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D3>Thanks for all the =
replies.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial>We called Oracle support and they come with the =
DUL=20
utility and</FONT></DIV>
<DIV><FONT face=3DArial>extracted the data.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial>As I&nbsp;write this e-mail imports are=20
running.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial>Concurrently we&nbsp;tried to restore the last =
full backup=20
from more then 2 weeks ago\</FONT></DIV>
<DIV><FONT face=3DArial>and found about 1 day worth of archive logs =
missing, so=20
this option is out.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial>We now also restoring last night export to a =
separate=20
database so in case</FONT></DIV>
<DIV><FONT face=3DArial>of logical errors in the imported data they will =
be able=20
to input the deals again</FONT></DIV>
<DIV><FONT face=3DArial>and bring the system up to date.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial>So now, eleven hours later we hope to finish in =
a few=20
hours.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>Yechiel Adar<BR>Mehish</DIV></BODY></HTML>

------=_NextPart_000_026A_01C270B9.0EFB3500--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76@inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

