Re: HELP: Transfer DB to another machine

If you are dealing with the same OS, the technique cited is the fastest way to move a database. It will only work for two machines with the same os.

If you are using 8i, there is a new technique to move tablespaces and their contents between instances. Once again, it must be the same OS. I haven't tried it yet, but the documentation seems pretty clear.

If the OS's are different, then you could try exporting the desired objects then importing them on the target. If you have no space or tape issues, export with data then import is the simplest. If you have space/tape issues, export the definitions from the host, import the definitions from the target and then copy the data table by table from the source across your network.

This last is probably the longest process, but uses the least volume of transient resources.

In article <954248164.13638.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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
> >
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Mar 28 2000 - 08:07:14 CST