Re: HELP: Transfer DB to another machine

Hello

    I have a question, if they are on different platform(AIX -> NT) How to do it ?

Thanks

wayne

Sybrand Bakker wrote:

> 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 - 06:44:33 CST