Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: datafile deleted and no backup at all
Thanks!
cgilbert_at_mail.dotcom.fr wrote in message
<39176F47.CA98FCE8_at_mail.dotcom.fr>...
>zhangc a ~{#?~}rit :
>>
>> I accidentally deleted datafile for the temp tablespace and we don't have
>> any backup and the database is running in noarchivelog mode. I tried to
>> alter database create datafile ... shutdown the database... and now I
cannot
>> open the database at all since it always asks for "media recovery" and
seems
>> like there is nothing I can do but recreate the database, and loss all
the
>> data,although it's not very important data.
>>
>> Any help will be very much appreciated.
>>
>> Chuck
>
>If the datafile is from a REAL temporary tablespace (i mean just sort
>segments
>are stored in it), do the following :
>
>- startup mount the database
>- alter database datafile '....' offline drop;
>- alter database open;
>- drop tablespace TEMP including contents;
>- recreate the tablespace
Received on Tue May 09 2000 - 00:00:00 CDT