RE: Dropped Datafile

Chris,

It's not okey. And rebuilding the controlfile would not help at all.

Winnie

Chris Griffith <Chris.Griffith_at_dstm.com> on 05/19/2000 09:52:35 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: RE: Dropped Datafile

Everything is okay now...just wait until you bump the instance. My suggestion is a good old-fashioned rebuilding of the control files.

Chris Griffith
OCP DBA -----Original Message-----
Sent: Friday, May 19, 2000 10:28 AM
To: Multiple recipients of list ORACLE-L

A trainee inadvertantly deleted a datafile from the OS 'immediately' after creating it. Everything seems okay for now except once in a while the following error shows up while creating schema objects:

     ORA-00376: file 13 cannot be read at this time
     ORA-01110: data file 13: '<OS datafile path>'

Query on dba_data_files shows the datafile to exist even after issuing the 'ALTER database datafile ... offline DROP' command.

Full database export works fine. Logical backups every day - Development server.

Any suggestions to clean up the database apart from cold backup - dropping tablespace - dropping datafiles at OS level - recreating tablespace and doing a table level import for the objects that earlier existed in that tablespace.

Thanks in advance

--
Author: Subramaniam, Lakshmi (L.)
  INET: lsubrama_at_ford.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Author: Chris Griffith
  INET: Chris.Griffith_at_dstm.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).