ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 10 Oct 2002 07:08:26 -0800
Message-ID: <F001.004E59F9.20021010070826@fatcity.com>

MessageHello 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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Yechiel Adar
  INET: adar76_at_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_at_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). Received on Thu Oct 10 2002 - 10:08:26 CDT