Re: HELP: Transfer DB to another machine

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 28 Mar 2000 10:39:00 +0200
Message-ID: <954233102.7978.0.pluto.d4ee154e@news.demon.nl>

Diego Pasquale <sincro8_at_micronet.it> wrote in message news:38E06D90.46116539_at_micronet.it...
> Hi, I'm pretty new to Oracle and I would like to know how to transfer a
> DB from a machine to another one (they have the same version of Oracle
> on it, Oracle 8i).
> Thank you,
> Diego.
>
>

1 make a cold backup of the old database 2 issue the command alter backup controlfile to trace in svrmgr The file will appear in the directory pointed to by user_dump_dest 3 create a new instance on the target system 4 copy all o/s database files and redolog files from the source system to the target system
5 copy the trace file over
6 when locations have changed, edit the trace file 7 now run the trace file through svrmgr 8 follow any additional instruction in the trace file 9 you should be set now.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Mar 28 2000 - 02:39:00 CST