Re: Import oradata files

Comments embedded.
Giulio Ferro wrote:
> I hope some expert can halp me with this.
>
> An old 8.1 server crashed and no backup was avaialble.

Mistake number 1.

> I managed to salvage from the hard disk the oracle directories,
> and specifically the oradata directory. Since I had to set up an
> other server I tried to install oracle 8.1 in a new machine and
> import the old data.
>

You're fine here, but it would be nice of you to tell us which operating system you're using as the process varies between *nix and Windows.

> In order to do this I created a database with the assistant which had
> the same name of the old database, then I copied the files in the old
> oradata into the new oradata.
>

Mistake number 2.

> It didn't work. I tried to run the migration utility but it complained
> about different version of control files, and when I tried to open it
> I couldn't.
>
> Can someone please tell me what I did wrong and what is the correct
> procedure to do this?
>

Usually one would:

1. Install the required version of the Oracle software on the new server.
2. Copy the old database files to the new server.
3. Ensure the environment is set up properly then connect to, and startup, the database. (This would be for *nix systems; Windows requires some services to be created/started before connections to the database are allowed.)

This is a classic example of cloning a database, covered here many times with detailed instructions available in the archive.

> Thanks in advance.

David Fitzjarrell Received on Tue Feb 07 2006 - 15:01:16 CST