Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!postnews2.google.com!not-for-mail
From: joel-garry@home.com (Joel Garry)
Newsgroups: comp.databases.oracle.server
Subject: Re: Recovery Issue
Date: 7 Jul 2004 16:58:09 -0700
Organization: http://groups.google.com
Lines: 33
Message-ID: <91884734.0407071558.522a4985@posting.google.com>
References: <392ee2a7.0407061547.131469c3@posting.google.com>
NNTP-Posting-Host: 67.116.125.178
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1089244690 26856 127.0.0.1 (7 Jul 2004 23:58:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 7 Jul 2004 23:58:10 +0000 (UTC)
Xref: core-easynews comp.databases.oracle.server:225182
X-Received-Date: Wed, 07 Jul 2004 16:57:19 MST (news.easynews.com)

troy.ochsenbein@gmail.com (tjo) wrote in message news:<392ee2a7.0407061547.131469c3@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