Home » RDBMS Server » Server Utilities » Cloning the DB
Cloning the DB [message #442116] Thu, 04 February 2010 14:30 Go to next message
patdev
Messages: 56
Registered: August 2008
Member
Hi,

what steps i need to follow to create clone of database sysetm.

1) alter controlfile from backup and get the script toc reate databsae
2)shudown database and copy datafile from old to new server
3)edit control file and change old to new intance name
4)remove recover and alter database syntax from control file.
5)creaet same directroy on the new server location
6)run the sql file.

Do i need to install any oracle on new server?
I know it is bad question but new to clone and copy databsae to new server!!

Thanks
Pat
Re: Cloning the DB [message #442118 is a reply to message #442116] Thu, 04 February 2010 14:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Do i need to install any oracle on new server?

Of course otherwise who will run the instance?

A good reading:
Database Concepts
Start with chapter 1 "Introduction to the Oracle Database", especially sections "Overview of Physical Database Structures" and "Overview of the Oracle Instance".

Regards
Michel
icon12.gif  Re: Cloning the DB [message #442582 is a reply to message #442116] Tue, 09 February 2010 03:50 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Once you become familiar with the fine reading material michel suggested, then you can find instructions on cloning an Oracle database by searching the forum or looking it up here.
Smile
Previous Topic: Changing column order using Data Pump in Oracle 10g?
Next Topic: Import from one tablespace to another
Goto Forum:
  


Current Time: Fri Dec 02 16:33:25 CST 2016

Total time taken to generate the page: 0.51143 seconds