Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Not able to find data file on server but database is working fine
If some data has been inserted/deleted from tables on this tablespace after the datafile deletion, I think a recovery will be needed anyway.
Regards,
Alessandro
> Actually you can recover these files depending on your OS.
>
> On Linux you can use the /proc filesystem. You have to be root. Warning:
> be VERY careful, you can really mess up your filesystem if you don't know
> what you're doing here.
>
> # ll /proc/10785/fd
> lrwx------ 1 jschneider jschneider 64 Jun 25 16:17 0 -> /dev/pts/3
> lrwx------ 1 jschneider jschneider 64 Jun 25 16:17 1 -> /dev/pts/3
> lrwx------ 1 jschneider jschneider 64 Jun 25 16:17 2 -> /dev/pts/3
> lr-x------ 1 jschneider jschneider 64 Jun 25 16:17 3 ->
> /usr/home/jscheinder/test2 (deleted)
> # stat -L /proc/10785/fd/3
> File: `3'
> Size: 11 Blocks: 8 IO Block: 4096 regular file
> Device: 803h/2051d *Inode: 246096 *Links: 0
> Access: (0664/-rw-rw-r--) Uid: ( 619/jschneider) Gid: ( 619/jschneider)
> Access: 2007-06-25 16:18:06.000000000 -0700
> Modify: 2007-06-25 16:12:39.000000000 -0700
> Change: 2007-06-25 16:17:30.000000000 -0700
>
>
> (that dereferences the still open file and gives you the inode - even though
> it's deleted)
>
>
> # debugfs -w /dev/sda3
> debugfs: cd /home/jschneider/fixed
> debugfs: ln <246096> test2
>
> and shazam, you've got the file back.
>
> -Jeremy
>
<cut>
> > Hi,
> >
> > On the test machine the developer created a new tablespace and I can see
> > in the alert.log file that the command was successful. Also I can see
> > from dba_data_fies that the datafile is available and also the
> > tablespace is showing as Online in dba_tablespaces. Also I am able to
> > create and insert data into table created in this tablespace but problem
> > is I don't see the file on server and I done search(find) as root and
> > don't see file anywhere on the system. Where the file can be and what
> > can be the possible reason for this behavior?
> > Environment: Oracle 10.2.0.3 on RHAT4
> >
> > Thanks
> > --Harvinder
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 26 2007 - 03:28:54 CDT
![]() |
![]() |