database cloning [message #544023] |
Sun, 19 February 2012 07:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/e77f0a4be52ece672d91ceb99ecdf345?s=64&d=mm&r=g) |
hemant_khandare
Messages: 72 Registered: November 2011
|
Member |
|
|
Dear Sir,
I am learning how to clone database using cold backup, and I read many articles on it finally tried all the steps but finally I got stuck in some step so please help me .
I have copied all datafile ,redofile and also created control file but I am getting error while inititialisation of my clone(CVM) instance.
SQL> startup nomount pfile=C:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\INITCVM.ORA;
LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE
\INITCVM.ORA'
ORA-01078: failure in processing system parameters
but I have copied this file to C:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE location but still giving me error.
Thanks In advance
|
|
|
|
|
|
|
|
|
|
Re: database cloning [message #553042 is a reply to message #546068] |
Tue, 01 May 2012 05:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
amitets
Messages: 2 Registered: April 2012
|
Junior Member |
|
|
A database cloning procedure is especially useful for the DBA who wants to give his developers a full-sized TEST and DEV instance by cloning the PROD instance into the development server areas.
|
|
|
Re: database cloning [message #553043 is a reply to message #553042] |
Tue, 01 May 2012 05:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1/ What has this remark has to do with the current problem?
2/ And this is a bad practice as it gives access to anyone to confidential data.
Data should be anonymized and his is very seldomly done.
3/ This is a lie, how many development sites have several terabytes server? Only small applications can be cloned like this. Yes, I know some of them, but this does NOT give better development that those with small servers AND appropriate not real data.
Regards
Michel
|
|
|