Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dropped Datafile
The instance is shut down every once in a while and brought up without any
problems... (though I am surprised how it starts up without any errors)
-----Original Message-----
From: Chris Griffith [mailto:Chris.Griffith_at_dstm.com]
Sent: Saturday, May 20, 2000 2:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Dropped Datafile
sorry, I meant that as a question, like "it is okay????" Anyway, rebuilding the controlfile would fix the problem, but the tablespace will have to be dropped.
-----Original Message-----
Sent: Friday, May 19, 2000 5:50 PM
To: Multiple recipients of list ORACLE-L
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)
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-LReceived on Mon May 22 2000 - 06:59:34 CDT
(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). -- Author: INET: Winnie_Liu_at_infonet.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
![]() |
![]() |