Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Recovering the Data from DBF files
The machine I have problems with had a single hard drive that contained the
OS, the registry, and the database; and after a lot of effort I am unable to
boot from this drive, but I installed a second drive with an OS and registry
and I boot from the new drive and then I can access the old drive. The
problem now however, is that the new registry does not know about the
database on the old drive, and therefore, the instance will not start.
Since I am unable to boot from the old drive, I thought that I could install
Oracle on the new drive to get the registry set properly, start an instance,
and some how point the database toward the existing .dbf files on the old
drive. Is this possible, or are there inherent reasons why this will not
work in Oracle? Or, is there a better solution?
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:hdmmouolq95qmno018v1hug612s28v1reh_at_4ax.com...
> On Fri, 20 Sep 2002 11:33:06 -0500, "Young" <uylee_at_madco911.com>
> wrote:
>
> >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.
>
> Why?
> >Is it possible to extract the data from those DBF files?
> No, except for using Data UnLoader from Oracle Support which will cost
> you big wad
> >Or is there any other method to retrieve them?
>
> You need to use the normal recovery procedures outlined in the backup
> and recovery manual. However you sound like your database is not
> running in archivelog.
> In that case the only thing you can do is pray and create a new
> controlfile (syntax in the manual), and open the database with
> resetlogs and forget about the changes you just lost.
>
> Regards
>
>
> >Your assistance will be greatly appreciated.
> >
> >
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Sep 20 2002 - 14:02:14 CDT