Re: copying a database from one server to another

An overview (high-level) of how you may restore your database.

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

Holger Baer <holger.baer_at_science-computing.de> wrote in message news:<3EF6AF45.4090200_at_science-computing.de>...
> Sybrand Bakker wrote:
> > On Fri, 13 Jun 2003 10:14:20 +0200, Holger Baer
> > <holger.baer_at_science-computing.de> wrote:
> >
> >
> >>In that case, check the oracle docs on the usage of oradim.exe.
> >
> >
> >
> > Won't help. oradim only sets very few variables in the registry.
> > Well, good way to learn to backup the registry I guess
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> Sorry for the late reply.
>
> If I'm not completely mistaken (and I'm sure you'll let me know
> instantly :-) ) you use oradim to create a new service. If you
> name it the same, then you should get an instance up.
>
> But perhaps I missed the point of the original poster. I thought
> he just lost the services. Of course, if the complete oracle tree
> is gone, that's another fish to fry.
>
> Regards,
>
> Holger
Received on Tue Jun 24 2003 - 04:59:13 CDT