Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB

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

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Tue, 15 Oct 2002 06:49:15 -0800
Message-ID: <F001.004E9257.20021015064915@fatcity.com>


MessageAn update:

We finished the creation of the database in the morning in time for business day.

We found that the file system was performing at about 30-50% efficiency. On Sunday we moved the database to a new server and all is OK.

Now we are starting to prepare new server so we can return to replication.

Yechiel Adar
Mehish

  Thanks 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 Tue Oct 15 2002 - 09:49:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US