Re: Database Recovery
From: varad acharya <vacharya.ford_at_e-mail.com>
Date: 1996/10/15
Message-ID: <32636A03.5D2E_at_e-mail.com>#1/1
Date: 1996/10/15
Message-ID: <32636A03.5D2E_at_e-mail.com>#1/1
Claes Nordfeldt wrote:
>
> Hi !
>
> During a system maintainence we lost a datafile for the TEMP-tablespace.
> The database was shutdown down. We have no backup to restore and no
> archivelogs. The data in the datafile are not important as it only
> was used for temp-data. Is it possible to open the database without
> the datafile and drop tablespace TEMP and then recreate it ?
>
> Claes Nordfeldt
> Email: cnordfel_at_seisy.abb.se
Try this
Shutdown instance
startup mount
alter database datafile '<file_in_TEMP_tablspace>'> offline drop;
alter database open;
Once the database is opened u may drop the TEMP tablespace .
-- Regards, Varad AcharyaReceived on Tue Oct 15 1996 - 00:00:00 CEST