Re: Procedure to move one oracle database to another machine

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