Re: datafile erased and oracle doesn't want to start... How to erase the tablespace when database is closed ?

if your database is running in archive log mode:

1. mount your database
2. alter database datafile <datafile name> offline;
3. open the database
4. drop tablespace <..> including contents.

or you can use archive log files to recover the datafile.. make sure that you have all the archive log files and restore the datafile from the backup. then open svrmgrl:

1. mount the database
2. set auto recoverary on
3. recover database
4. open the database

if your database is running in no archive log mode:

1. mount your database
2. alter database datafile <datafile name> offline drop;
3. open the database
4. drop tablespace <..> including contents

it provides that the tablespace that got corrupted is not the SYSTEM tablespace.

Winnie

Jean-Francois Vincent wrote in message <35DAE10E.1F37_at_platinum.com>...
>Hi, a .dbf file of a tablespace was erased and now the instance doesn't
>want to start and stay started but not opened, so we can't drop the
>tablespace with the command DROP TABLESPACE INCLUDING CONTENTS in the
>svrmgr. How to delete the tablespace and restore the rest of the
>instance ?
>
>
>thank. J-Fr.
Received on Wed Aug 19 1998 - 22:18:35 CDT