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: copying a database from one server to another

Re: copying a database from one server to another

From: Christoph Kukulies <kuku_at_accms33.physik.rwth-aachen.de>
Date: 4 Jul 2003 08:09:39 GMT
Message-ID: <be3co3$tp$1@nets3.rz.RWTH-Aachen.DE>


Richard O <maverickguy_1_at_mailcity.com> wrote:
> An overview (high-level) of how you may restore your database.

A final 'thank you' to all who added helpful comments. Especially this last one.

--
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de


> 1. Install Oracle on the new machine. (This will also re-intrroduce
> Oracle to the registry)
> 2. Restore your datafiles, online redo logs and control file to their
> original locations. (This is the easiest way. You may place them on
> other sub-directories, edit a recreated control file, etc; but that
> will take a whole new thread). If you have the original init.ora, that
> would help. If not edit the default init.ora file.
> 3. Recreate the Oracle service using "oradim". Check docs for the
> syntax.
> 4. Edit the listener.ora file; add your database instance.

> I have done this several times before; you should have a restored
> database afterwards.

> Hope this helps.

> Regards,
> Rich
Received on Fri Jul 04 2003 - 03:09:39 CDT

Original text of this message

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