Home » RDBMS Server » Backup & Recovery » Cloning the Oracle 9i on Windows
Cloning the Oracle 9i on Windows [message #466022] Fri, 16 July 2010 08:14 Go to next message
patdev
Messages: 54
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 #466023 is a reply to message #466022] Fri, 16 July 2010 08:20 Go to previous messageGo to next message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member

Try Rman Duplicate Database

Babu

[Updated on: Fri, 16 July 2010 08:21]

Report message to a moderator

Re: Cloning the Oracle 9i on Windows [message #466028 is a reply to message #466023] Fri, 16 July 2010 08:46 Go to previous messageGo to next message
patdev
Messages: 54
Registered: August 2008
Member
I do not have RMAN on that server!! I was handed th server to create clone of dtabase on same server with Testname. what are the steps i need to follow ot create the clone on server.

thanks

[Updated on: Fri, 16 July 2010 08:47]

Report message to a moderator

Re: Cloning the Oracle 9i on Windows [message #466032 is a reply to message #466028] Fri, 16 July 2010 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
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
Re: Cloning the Oracle 9i on Windows [message #466038 is a reply to message #466022] Fri, 16 July 2010 09:55 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you have a database on the server, then you have RMAN (unless someone actually removed the rman executable).

If you do not want to use RMAN to duplicate the database, then you can consider Cloning An Oracle Database on Windows.
Previous Topic: Getting ORA-19700 with various RMAN Commands
Next Topic: RMAN copy
Goto Forum:
  


Current Time: Sat Sep 20 18:00:10 CDT 2014

Total time taken to generate the page: 0.27147 seconds