Re: copy a DB between 2 diff. systems?

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
Received on Fri Jan 21 2000 - 05:06:27 CST