Cloning the Oracle 9i on Windows [message #466022] |
Fri, 16 July 2010 08:14 |
patdev
Messages: 73 Registered: August 2008
|
Member |
|
|
Hi all,
I am new to this, can any one please send me the cloning process of oracle 9i on windows 2003 please.
I need to create test database instance on same server as the production.
Thanks
|
|
|
|
|
Re: Cloning the Oracle 9i on Windows [message #466032 is a reply to message #466028] |
Fri, 16 July 2010 08:54 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Simplest way: stop the database, copy ALL the files (data, log, control, init.ora/spfile, password...) to the same locations, create a new instance on target server (see ORADIM), start both databases.
Regards
Michel
|
|
|
|