Re: New Instance for Existing Database -- 10gR2 under Win Server 2003 64-bit

From: <>
Date: Wed, 2 Jul 2008 08:06:19 -0700 (PDT)
Message-ID: <>

On Jul 2, 9:24 am, DavidClement <> wrote:
> I'm a Unix/Linux Oracle developer who needs to ask a Windows-oriented
> DBA question.
> For testing purposes, one of the guys in this shop wants a new
> instance that will access existing database files. Working from home
> late at night, he copied all the files (control files, DBFs, and
> everything) and then blew away the instance and installed a new one.
> Now he wants a new instance that can mount the files that he copied.
> If someone with Windows DBA knowledge could say to me, "Read Chapter
> nn of the XYZ Manual, you fool," that would be extremely helpful. I'm
> just not certain where to start. :-)
> Thanks to all who've taken the time to read this post.
> David Clement

This is known as cloning a database, and, yes, it's explained numerous places on the web. The link below is but one of many sites explaining this process:

Follow the instructions carefully.

David Fitzjarrell Received on Wed Jul 02 2008 - 10:06:19 CDT

Original text of this message