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

Home -> Community -> Mailing Lists -> Oracle-L -> Newbie question on recovering an offline datafile

Newbie question on recovering an offline datafile

From: Jaeger David - Grand Rapids <David.Jaeger_at_Kohler.Com>
Date: Thu, 4 May 2006 09:18:13 -0500
Message-ID: <EA15F3A1658A5A4F995F684EADBC338A01858FB0@bkgrex16a.kohlerco.com>


This is not an urgent situation as this only involves a test instance of the database. Here is the situation. I refresh our TEST and DVLP instances of our production database through a series of scripts. On our production database (8i) I added a new datafile to a tablespace. When I do this I manually add the new datafile definition to a script that creates the new control files for the refreshed TEST or DVLP database. Well this script wasn't updated prior to the last refresh of the TEST datasbase.

At this point I receive error messages from our concurrent manager (we run Oracle Apps 10.7) containing ORA-376 and ORA-1111 errors. I found that the database didn't know what to do with the references to the new datafile and took it offline. I found the offending datafile and renamed it in the database, but now I can't bring it back online. It appears that the datafile needs to be recovered. I can easily solve the problem by refreshing the TEST database from last night's backup of the production database, but I would rather use this as a learning exercise. Can anyone guide me through the steps needed to resolve this issue?

Thank You,
David Jaeger

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 04 2006 - 09:18:13 CDT

Original text of this message

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