Re: copy a DB between 2 diff. systems?

Mike,
Could you please clarify what operating systems you migrate from/to ? We are soon to begin a large hardware migration effort from Sun 32bit and DecAlpha 64 bit to a consolidated HP 64 bit platform. Most all servers have Oracle and one has 1.2 terabytes of data. Oracle states that our only 'supported' option is to import/export, but can't afford the downtime w/ 1.2 TB. We plan on testing ftp, copy and tape restores, but would appreciate any insight/input from your migration experience.
Thanks Don

In article <38883DB3.F6C0CDF4_at_london.virgin.net>,   Mike Mountjoy <michael_at_london.virgin.net> wrote:
> Mike,
>
> I've done exactly that just before Christmas. Works very well. Its
> also a bit more straight forward if you can shutdown your instance
> for a couple of hours while things copy to the new machine.
>
> All you to do is make sure the versions on both boxes are the same
and that
> boxes are essentially the same in terms of user names , groups and
the like.
>
> Shutdown your source instance, copy the dbf's, control files, *.ora
files ,
> oratab setting
> (for /etc/init.d startup/shutdown scripts)
>
> Works very nicely. The thing about exports/imports is that things
can get messy
> in terms
> of synonyms/triggers etc firing or not being created during imp.
>
> Regrds,
> Mike
>
> Michele Viviani wrote:
>
> > Try with an Export full database on source system, trasfer via
ftp,lan the
> > file .exp and make an import full database on destinations system
> >
> > Hi Mike
> >
> > Michael Schäfer ha scritto nel messaggio
<3875f9a4_at_news.lhsgroup.com>...
> > >I know that it is not supported to copy an Oracle db from one
system to
> > >another, but
> > >
> > >is that technically possible (of course it is, but does it work)?
> > >
> > >copy all necessary file from a 64 bit system like DEC's Turbolaser
to an 64
> > >system like IBM's S80?
> >
> > >Thanks for help,
> >
> > >Mike
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 21 2000 - 12:49:53 CST