Re: Recovering the Data from DBF files

Do you have all the database files from the old drive? If so, you should be able to create an instance on the new drive, shut it down, copy all the old data files, control files, redo logs, pfile, etc. to the new drive, start it back up, and it should do instance recovery. Now, if any of the files are corrupt, you're hosed.

And, from the backup-recovery guide "...a minimal production-level database requires at least two disk drives: one to hold the files in the redundancy set and one to hold the main database files...". Once you get everything back up, get a second drive and follow the procedures in the backup and recovery guide.

"Young" <uylee_at_madco911.com> wrote in message news:uoms4glth3oobf_at_corp.supernews.com...
> 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 - 16:03:39 CDT