RE: someone deleted my datafile

  • From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
  • To: <oracledbaquestions@xxxxxxxxx>, "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 19 Dec 2008 11:27:59 -0600

When you do alter database open; what error do you get?


Guillermo Alan Bort

DBA / DBA Main Team


EDS, an HP company


Arias 1851

Ciudad Autonoma de Buenos Aires (C1429DXC)



Tel: +54 11 4704-3132

E-mail: guillermo.bort@xxxxxxx <> 


We deliver on our commitments

so you can deliver on yours.


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dba DBA
Sent: Friday, December 19, 2008 3:25 PM
To: Allen, Brandon; oracle-l@xxxxxxxxxxxxx
Subject: Re: someone deleted my datafile


doesn't work with the database not opened. I have it in mount state. 



On Fri, Dec 19, 2008 at 12:23 PM, Allen, Brandon
<Brandon.Allen@xxxxxxxxxxx> wrote:

I'm not sure if this is the right answer, but I think you might be able
to take the missing datafile and/or tablespace offline first and then
open the database.  Did you try that?


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dba DBA
Sent: Friday, December 19, 2008 10:18 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: someone deleted my datafile


I know this is a stupid question. I am mainly a developer. I do what is
needed as a DBA sometimes. I am using google to solve this. I just
needed my database to open. I don't care about losing the tablespace. 

On windows

oracle 10.2

I just created the database. It is for development purposes. There is
nothing in it I can't afford to lose. I don't have a backup.

I just want to drop the tablespace with the datafile in it.

1. I can mount the database, but can't open it because oracle can't find
the datafile
2. i cant drop the tablespace in mounted mode.

I know there is a way to fix this. what do I do? I know I need to
somehow drop the tablespace.



Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.


Other related posts: