Re: Recovery Issue

joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0407071558.522a4985_at_posting.google.com>...
> 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

Looks like I'm in luck the control, redo, and system files are all there as well as the pfile and bdump directory. With that in mind, could you point me in the direction I should research to recover the data?  

tjo Received on Thu Jul 08 2004 - 21:57:15 CDT