Re: someone deleted my datafile
- From: "Dba DBA" <oracledbaquestions@xxxxxxxxx>
- To: "Bort, Guillermo" <guillermo.bort@xxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 19 Dec 2008 12:50:01 -0500
what is the rationale behind not being able to take a tablespace offline
when the database is not open, but being able to take a datafile offline?
that one tricked me up for a little while. Any idea why oracle made it that
way?
On Fri, Dec 19, 2008 at 12:49 PM, Dba DBA <oracledbaquestions@xxxxxxxxx>wrote:
> you can't take the tablespace offline when the database is not open. I had
> to take the datafile offline.
>
> open the database
>
> drop the tablespace including contents and datafiles.
>
> fixed.
>
> On Fri, Dec 19, 2008 at 12:24 PM, Bort, Guillermo
> <guillermo.bort@xxxxxxx>wrote:
>
>> Alter tablespace TBS offline;
>>
>> Alter database open;
>>
>> Drop tablespace TBS;
>>
>>
>>
>> Should do the tric. Incidentaly, what is the tablespace? If it is either
>> undo or system then you are screwed… otherwise should be recoverable.
>>
>>
>>
>> hth
>>
>>
>>
>> *Guillermo Alan Bort*
>>
>> DBA / DBA Main Team
>>
>>
>>
>> *EDS*, an HP company
>>
>> ITO
>>
>> Arias 1851
>>
>> Ciudad Autonoma de Buenos Aires (C1429DXC)
>>
>> Argentina
>>
>>
>>
>> Tel: +54 11 4704-3132
>>
>> E-mail: guillermo.bort@xxxxxxx <name.name@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:18 PM
>>
>> *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.
>>
>
>
Other related posts:
