Re: Recovery Issue

troy.ochsenbein_at_gmail.com (tjo) wrote in message news:<392ee2a7.0407061547.131469c3_at_posting.google.com>...
> Recently I received a system that had 3 partitions C, D, E. The
> operating system was on the C partition and the Oracle database
> (8.1.7) was on the E partition. The Operating system had major issues
> and was unable to boot, so I formatted the C partition and loaded
> Windows 2000.
>
> Nothing was done to E partition, if I wanted to install Oracle on the
> D partition would it be possible to recover the data from E? If so,
> how would I go about accomplishing this task?

It kinda depends on whether any of your database was not on E. You may indeed be able to simply install oracle on D and ORADIM your way to success.

If part of your database was not on E, you may be hosed (unless you have some proper backups). Look to see if E has some files with SYSTEM, CONTROL or REDO in their name. If you don't have any one of those, hosed (although it is possible they have used different names, it is unlikely). Also, if your %ORACLE_HOME% was lost and happened to have the pfile and such under it, you may need to know a fair amount of Oracle basics to get things going - look for folders named pfile and bdump, perhaps under a folder named as your instance name, and look for network\admin. In general, people are encouraged to spread things out among disks if possible, you may be lucky if that had been ignored.

Then there's that registry...

jg

--
@home.com is bogus.
http://meta.wikipedia.org/wiki/Wikimedia_servers