Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id g9AHi1A19842 for ; Thu, 10 Oct 2002 12:44: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 g9AHhxD19830 for ; Thu, 10 Oct 2002 12:44:00 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA32609; Thu, 10 Oct 2002 08:25:26 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004E5A9A; Thu, 10 Oct 2002 07:28:55 -0800 Message-ID: Date: Thu, 10 Oct 2002 07:28:55 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Deshpande, Kirti" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Deshpande, Kirti" 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_001_01C27068.88D056E0" ------_=_NextPart_001_01C27068.88D056E0 Content-Type: text/plain; charset="iso-8859-1" Note # 148894.1 on Metalink has a possible solution... NT has a limit of 4GB for the file size :( - Kirti -----Original Message----- Sent: Thursday, October 10, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Hello all HELP - and I am not an idiot. Oracle 8.1.6.3.4 on NT. We have a problem that the datafile for the application tables autoextended from 3.9 GB to 4.1 GB. We are getting ora-01115 errors and the datafile is offline. We tried export but it gets the same error. The status now is that the datafile is offline. Alter datafile online needs recovery. Recovery gets I/O error and aborts. Anybody knows how to get the data out? As per Murphy's law, the last full backup of the database ran about 2 weeks ago and nobody noticed that the backup job ended ok but without backing up the files. So recovery means restoring from 2 weeks ago and applying archive logs for some hours. Oracle support are sending someone with a utility that MAY save the day. Any ideas ??????????????? HELP Yechiel Adar Mehish ------_=_NextPart_001_01C27068.88D056E0 Content-Type: text/html; charset="iso-8859-1" Message
Note # 148894.1 on Metalink has a possible solution...
 
NT has a limit of 4GB for the file size :(
 
- Kirti
 
-----Original Message-----
From: Yechiel Adar [mailto:adar76@inter.net.il]
Sent: Thursday, October 10, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L
Subject: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB

Hello all
 
HELP - and I am not an idiot.
 
Oracle 8.1.6.3.4 on NT.
 
We have a problem that the datafile for the application tables autoextended from 3.9 GB to 4.1 GB.
We  are getting ora-01115 errors and the datafile is offline.
We tried export but it gets the same error.
 
The status now is that the datafile is offline.
Alter datafile online needs recovery. 
Recovery gets I/O error and aborts.
 
Anybody knows how to get the data out?
 
As per Murphy's law, the last full backup of the database ran about 2 weeks ago
and nobody noticed that the backup job ended ok but without backing up the files.
So recovery means restoring from 2 weeks ago and applying archive logs for some hours.
 
Oracle support are sending someone with a utility that MAY save the day.
 
Any ideas ???????????????
 
HELP
 
Yechiel Adar
Mehish
------_=_NextPart_001_01C27068.88D056E0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: kirti.deshpande@verizon.com 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).