| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Recovering the Data from DBF files
Hi
On Fri, 20 Sep 2002 14:02:14 -0500, "Young" <uylee_at_madco911.com> wrote:
>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?
You have my sympathies - other posters have suggested possible routes to recovery. I would just like to say experiment on COPIES of the old dbf/control/redolog files. You will probably need to take several runs at the recovery process and will want to return to the orginals each time. Don't force yourself to be in the position of having to recover the db from some previous recovery attempt as well as the crash.
If you have not already done so do yourself a favour and create backup of the original files now
Just my $.02
Dale
 |
 |