CLONING a DATABASE! [message #73466] |
Wed, 05 May 2004 04:46 |
Deepa
Messages: 269 Registered: November 2000
|
Senior Member |
|
|
How do we clone a database in ORACLE?
I had done a coldbackup of a database(production) and am trying to replicate the same in our local environment.
Pls enumerate the steps for cloning the database.
|
|
|
Re: CLONING a DATABASE! [message #73495 is a reply to message #73466] |
Tue, 11 May 2004 11:02 |
croca
Messages: 50 Registered: January 2004
|
Member |
|
|
You will need same operating system.
On unix machine is more simple, you just restore datafiles, controlfiles, online redolog and INIT.ORA files to their original locations.
Install same oracle software version.
And startup your DB
On windows you will need to install same oracle version, restore datafiles, controlfiles.etc...to same location as source database, and create service with oradim command.
Best regards.
www.otools.com.ar
|
|
|
|