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

    I disagree. We moved 12 databases from one server to another on Friday in about eight hours. They totaled around 150G or so of data. They had lots of materialized views, mv logs and other dependencies. Five of the databases were given a new file structure and five were upgraded from 8172 to 8173. We used the "copy database files" method and everything worked as expected after the move. I don't think we could have come close to doing the work in that time frame using export/import.

    The eight hours includes the time to make the new init.oras, modify the controlfiles, create the directory structure on the new server, add the new locations of the databases to LDAP and to tnsnames.ora files and other housekeeping.

Van

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3e6e61ae_1_at_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:48:12 CST