Home » RDBMS Server » Networking and Gateways » database cloning (oracle 10 g)
database cloning [message #544023] Sun, 19 February 2012 07:18 Go to next message
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 #544036 is a reply to message #544023] Sun, 19 February 2012 08:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>but I have copied this file to C:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE location but still giving me error.
post full directory listing that shows statement above is true

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: database cloning [message #544044 is a reply to message #544036] Sun, 19 February 2012 10:09 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
dear BlackSwan I got my mistake and I have completed above issue but when I issue
ALTER DATABASE OPEN RESETLOGS then it give me an error like
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CVM\SYSTEM01.DBF'
Re: database cloning [message #544047 is a reply to message #544044] Sun, 19 February 2012 10:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am learning how to clone database using cold backup,
If the DB was cleanly shutdown prior the clone, then the files do not know that they now reside on different system
& the DB should only require simple "STARTUP" to bring it back online.
It is not clear whether you have an error of omission or error of commission, but you do have some sort of error.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: database cloning [message #544086 is a reply to message #544047] Mon, 20 February 2012 01:38 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
dear BlackSwan I gotsucceded in cloning part but no I am not able to connect my origanal database ,it is giving me listner problem .I tried to reconfigure it using netca but still giving me error as below:

the information provided for this listener is currently in use by other software on this computer
Re: database cloning [message #544088 is a reply to message #544086] Mon, 20 February 2012 01:59 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
dear BlackSwan , dont know what goes wrong and right but finally my both instance are working...finally I learned database cloning after long time ..thanks for your support.
Re: database cloning [message #546066 is a reply to message #544088] Mon, 05 March 2012 02:33 Go to previous messageGo to next message
paddysmith
Messages: 2
Registered: March 2012
Location: USA
Junior Member
How to clone a database manually??????
Re: database cloning [message #546068 is a reply to message #546066] Mon, 05 March 2012 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I give you 2 ways (there are other ones):
1/ Full backup, copy the backup files, restore.
2/ Stop the source database, copy all its files to target location, restart source database, create new service in target server, start the new database.

Regards
Michel
Re: database cloning [message #553042 is a reply to message #546068] Tue, 01 May 2012 05:41 Go to previous messageGo to next message
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
Michel Cadot
Messages: 68624
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
Previous Topic: dblink and left join
Next Topic: Two LAN Cards for Network Traffic Control Advantage
Goto Forum:
  


Current Time: Thu Mar 28 08:57:45 CDT 2024