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: Recovering the Data from DBF files

Re: Recovering the Data from DBF files

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Fri, 20 Sep 2002 21:51:43 +0200
Message-ID: <amfunp$cuv$1@news1.xs4all.nl>


Why not simply open the database and use export utility? You only need the same Oracle version installed on a machine with the same operating system, put the database files, redolog files, controlfiles on it and start the db. Should work.
Maybe "alter database rename datafile" is needed when files are in other directories.

Young <uylee_at_madco911.com> schreef in berichtnieuws uomi89t176a9bd_at_corp.supernews.com...
| Recently our database server(with Oracle8i) crashed due to the harddrive
| failure.
| Fortunately the harddrive was not badly damaged and we were able to
recover
| all the oracle related files including all the DBF.
| But here is the problem. We need to somehow export the data from DBF files
| then import them into new DB.
| Is it possible to extract the data from those DBF files?
| Or is there any other method to retrieve them?
| Your assistance will be greatly appreciated.
|
|
Received on Fri Sep 20 2002 - 14:51:43 CDT

Original text of this message

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