Re: copying a database from one server to another

Christoph Kukulies wrote:

> I have a database left in \oracle\ora81\databases on an NT server
> which also may have the Oracle server installed, but the server
> seems to be disabled in NT services. Anyway, I don't want to resurrect
> that server again, but instead migrate the database left ther to another
> server running 8i (or maybe 8.0.6 or something, I cannot predict at the
> moment).
>
> How can I "move" the database to the other server? As said, I would
> believe it to be difficult to get that server running on that machine and
> do a full export.

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.

If not the same version.. well, you can still try the above and see if it works (assuming the version is a minor difference that use the same phsyical file structures). You will however need to upgrade the db to the relevant Oracle version.

You can also resurrect the old server and do a full db export.

Another option would be to install that older version Oracle on the new server too and restore the physical backup there - and then either upgrade or use export/import/dblink to copy the relevant schemas/tables across.

--
Billy