OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Cloning the DB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cloning the DB [message #442116]

Thu, 04 February 2010 14:30

patdev
Messages: 74
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

Report message to a moderator

Re: Cloning the DB [message #442118 is a reply to message #442116]

Thu, 04 February 2010 14:39

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Cloning the DB [message #442582 is a reply to message #442116]

Tue, 09 February 2010 03:50

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

Report message to a moderator

Previous Topic:	Changing column order using Data Pump in Oracle 10g?
Next Topic:	Import from one tablespace to another

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 23:11:32 CST 2025