Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: lost datafile

Re: lost datafile

From: Dave Eidman <dave_at_iamdigex.net>
Date: Sat, 11 Dec 1999 06:54:32 GMT
Message-ID: <3851F5DC.589B07FA@iamdigex.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US