Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Recovering database in NT

Re: Recovering database in NT

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 15 Feb 2006 20:48:50 +0100
Message-ID: <dsvvrr$n5q$1@news3.zwoll1.ov.home.nl>


hassan wrote:
> We had an NT machine running Oracle 8.0.5 crash recently.
> Someone recovered the machine using the NT recovery disk and now it is
> back up, but as a clean system.
>
> The oracle files (programs and data) are still there but we cannot get
> anything to run as all the registry and system entries were erased by
> the recovery.
>
> We already have a new machine ready to go but need the databse off the
> old one.
>
> Is it possible to re-install oracle on the old machine and have it link
> back to the existing database? If it can link successfully, we can
> export the data and would be all set.
>
> If that is not an option, can the data files be moved to the new
> machine and have the new installation of oracle link to them?
>
> Any help with this would be greatly appreciated.
>
> Hassan
>

Would not call that a recovery, but well... Hopefully you have the 8.0.5 installation disks and patches (if any - you just mention the major version).
You need to:

- reinstall the software (and patches)
- recreate the service for you SID (using oradim)
- open svrmgrl, and recover the database. That

   could just be a matter of connect internal, startup,    it could be an entirely different, and more difficult    story.

Or... just get your backup tapes, and get the registry and oracle software from that (:evil:)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Feb 15 2006 - 13:48:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US