Re: HELP: Transfer DB to another machine

Export Import.
The procedure described below is only valid if there's no platform swap involved.

Hth,

Sybrand Bakker, Oracle DBA

Cantonese Boy <cantoneseboy_at_yahoo.com> wrote in message news:38E0A931.B4A91084_at_yahoo.com...
> 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:55:03 CST