Re: copying a database from one server to another

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 13 Jun 2003 10:14:20 +0200
Message-ID: <3EE987DC.1060103@science-computing.de>

Christoph Kukulies wrote:
> Billy Verreynne <vslabs_at_onwe.co.za> wrote:
>

>>Christoph Kukulies wrote:

>
>
>

>>If using the same Oracle version on both NT platforms:
>>A full physical backup of the Oracle database. Do a restore on the 2nd NT 
>>machine. If using the same file structure, do a startup. If not, rename the 
>>datafiles first.

>
>

>>If this works, delete the database from the old machine.

>
>
> May I come back to the original problem:
>
> The original database does only exist in the tree of the
> server in \database (with its control and data file and the ini files).
>
> The services had been removed so the registry is defunct Oracle-wise.
>
> Even if I manage to resurrect a server again, be it from an installation CD
> or by any other means, what do I have to do to make this DB visible
> to the Orcale installation? As said, no dump (export) exists.

If I've followed you correctly, then all of your oracle software still exists on the server.

In that case, check the oracle docs on the usage of oradim.exe.

HTH Holger Received on Fri Jun 13 2003 - 03:14:20 CDT