Re: 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 13:53:48 -0800
Message-ID: <F001.004E6420.20021010135348@fatcity.com>

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

--

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 - 16:53:48 CDT