Re: Moving a Oracle installation from one box to another.

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 11 Mar 2003 22:07:52 -0000
Message-ID: <3e6e61ae_1@mk-nntp-1.news.uk.worldonline.com>

"Nick Palmer" <nick_at_kcicorp.com> wrote in message news:v6s3h93j7crsc8_at_corp.supernews.com...
> Hi all,
>
> I'm in the process of upgrading one of our Oracle 8i boxes. I've got the
> new box, installed the OS and gotten everything ready for Oracle. So my
> question is, how do I move my Oracle instances from the old box to the new
> one ? Basically I want to duplicate the setup on the new box that I had
on
> the old box.
> What would the process to do this involve. It appears that if I install
> Oracle on the new box, then stop all the databases on my old box and copy
> over all the databases files as well as the config files, this will do it.
> Is this possible ?
>
>
> Thanks.
> Nick.
>
>

FWIW, I wouldn't attempt copying files. It may work, if you've got everything exactly right, but I'd prefer creating empty databases on the new box, and importing. Then I could be confident that it would work.

Of course, this depends on the size of the dbs, and how quickly it needs to be done.

Regards,
Paul Received on Tue Mar 11 2003 - 16:07:52 CST