Prev: Urgent openings ...get a refund
Next: CREATE OR REPLACE VIEW ORA-01031
From: DavidClement on 2 Jul 2008 10:24
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
From: fitzjarrell on 2 Jul 2008 11:06
On Jul 2, 9:24 am, DavidClement <dclem...(a)davidclement.org> 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:

http://www.pgts.com.au/pgtsj/pgtsj0211b.html

Follow the instructions carefully.


David Fitzjarrell

From: DavidClement on 2 Jul 2008 11:35
Thanks for the advice.
 | 
Pages: 1
Prev: Urgent openings ...get a refund
Next: CREATE OR REPLACE VIEW ORA-01031