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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Recover a datafile

Re: Recover a datafile

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/09/21
Message-ID: <969559393.26753.1.pluto.d4ee154e@news.demon.nl>#1/1

You need to recover the database.
In order to be able to do this you should have run the database in archivelog mode. If you didn't do that, and you also never ran export on the database, regrettably your data will be lost.

Regards,

Sybrand Bakker, Oracle DBA

<cristipp_at_my-deja.com> wrote in message news:8qd6e4$r4u$1_at_nnrp1.deja.com...
> Recently I lost all my Oracle instalation &
> files. All I am left with is the datafile
> corresponding to the tablespace I was working
> with. Is there anyway I can import this datafile
> into a fresh Oracle instalation or all my data
> are lost?
>
> Any help greatly appreciated, especially since
> there is no real DBA on a 500km radius :-)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Sep 21 2000 - 00:00:00 CDT

Original text of this message

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