Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Procedure to move one oracle database to another machine

Re: Procedure to move one oracle database to another machine

From: Praba Dorai <praba_at_pluto1.engr.sgi.com>
Date: Wed, 10 Jun 1998 08:13:04 -0700
Message-ID: <357EA280.1F8C0D35@pluto1.engr.sgi.com>


mpir_at_compuserve.com wrote:
>
> If the reason for the move is to allow the user on the other machine to
> access the database, then just install the SQL*NET client on the other
> machine rather than move/clone the database. This will allow them to access
> the one copy of the database across the network.
>
> In article <357dbace.69500015_at_isappp>,
> gedau_at_pobox.com (George Dau) wrote:
> >
> > Praba Dorai <praba_at_pluto1.engr.sgi.com> wrote:
> >
> > ] What are the procedures to move one oracle database to
> > ]another machine ? This oracle db should be accessed by
> > ]user who is working in another machine by network?
> > ]
> > ]Is it necessary to create a file system for oracle as NFS ?
> >
> > No, don't use NFS. It's slow and there are often locking problems.
> > Clone the database to the other machine.
> >
> > (Assuming OFA layout)
> > On the first machine, go to $ORACLE_BASE/admin/SID or wherever the
> > top of the tree is for that SID. Then make a tar file of everything
> > under there (you'll need to put the tar file somewhere where there is
> > enough space, this may be a tape). If the database is running in archivelog
> > mode, it is not necessary to shut down the database while doing this - I've
> > done it several times with active, running, databases.
> >
> > Now take you tar file to the new machine, and untar it to the same place,
> > so the tar creates the SID directory and everything under it.
> >
> > Create the link in $ORACLE_HOME/dbs to $ORACLE_BASE/admin/SID/pfile or where
> > ever your pfile is, and create the entry in /etc/oratab (or wherever your oratab
> > is).
> >
> > Startup the new database! It'll do some recovery and away you go.
> >
> > --
> > ,-,_|\ George Dau, __
> > / * \ Unix (Solaris, DEC Unix, Linux), Oracle, Internet. (OO)
> > \_,--\_/ Home: gedau_at_pobox.com Work: gedau_at_isa.mim.com.au ( \/ )
> > v WWW: http://pobox.com/~gedau W--W
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

Mpir,

 Since our people are going to use the new machine(the old machine is going to give to the another group), I have to move the database to the new one.

Could any one help me in this aspect ? Received on Wed Jun 10 1998 - 10:13:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US