Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: lost datafile
Try listing the dba_segments and dba_extents views for the affected
tablespace. For the segments that exist in the tablespace but
do not have an extent in the deleted file, you have a pretty good
shot of recovering the table. If you have indexes on tables that
are otherwise unrecoverable, because of the deleted file, but the
index itself exists completely outside the delete file, you should
be able to recover at least the fields in the index. Obviously the
first thing you need to do is a backup.
Boris Bliznukov wrote:
>
> Dear All,
>
> Accidentally I deleted one table space data file. As usual there is no
> backup :( There are about 10 different table spaces in this database. Is
> there any way to save data in other table spaces ??? I was trying to
> create a new database create table space with exactly same parameters
> and substitute it for missing one. But Oracle complains about
> "ORA-01251: Unknown File Header Version read for file number 17". Did
> anyone had this kind of problem?
>
> SVRMGR>
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 110021040 bytes
> Fixed Size 51632 bytes
> Variable Size 58679296 bytes
> Database Buffers 51200000 bytes
> Redo Buffers 90112 bytes
> Database mounted.
> ORA-01157: cannot identify data file 17 - file not found
> ORA-01110: data file 17: '/tmp/ora/tmp_ddm01.dbf'
> SVRMGR>
>
> Regards, Boris.
>
> --
> *** "I always wanted to be somebody,
> *** but I should have been more specific."
Received on Sat Dec 11 1999 - 00:54:32 CST