Re: emergency rescue needed

Hi,

First question, you wouldn't have a backup of this database? Since you have data in this database which you HAVE to be able to access, then I wouldn't really call it a test database, it's a production DB then, at least what concerns the backup & recovery part.

If you don't need any data from the files which are corrupted, you might want to do following:

startup mount;
alter database datafile x offline; -- where x is the datafile number which you get from v$datafile (or corruption error messages) alter database open;
export your tables

Of course if some of the corrupt datafiles belong to your system or rollback/undo tablespace, things get more complicated and you should turn to support.

Tanel.

>I had/have a test DB where a number of files got corrupted.
> I just HAVE be able to open this DB.
> I am willing to sacrafice the data in the corrupted files.
> What are the steps to do so?
> It is something along the lines of STARTUP NOMOUNT
> ALTER TABLESPACE ???? OFFLINE;
> DROP TABLESPACE ?????;
> STARTUP MOUNT;
> ALTER DATABASE OPEN;
>
> I've just looked in Metalink & did not find where this procedure is
> documented.
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l