Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

0 views
Skip to first unread message

DavidClement

unread,
Jul 2, 2008, 10:24:58 AM7/2/08
to
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

ora...@msn.com

unread,
Jul 2, 2008, 11:06:19 AM7/2/08
to

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

DavidClement

unread,
Jul 2, 2008, 11:35:13 AM7/2/08
to
Thanks for the advice.
0 new messages