OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » database cloning (oracle 10 g)

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

database cloning [message #544023]

Sun, 19 February 2012 07:18

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

Report message to a moderator

Re: database cloning [message #544036 is a reply to message #544023]

Sun, 19 February 2012 08:54

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/

Report message to a moderator

Re: database cloning [message #544044 is a reply to message #544036]

Sun, 19 February 2012 10:09

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'

Report message to a moderator

Re: database cloning [message #544047 is a reply to message #544044]

Sun, 19 February 2012 10:28

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/

Report message to a moderator

Re: database cloning [message #544086 is a reply to message #544047]

Mon, 20 February 2012 01:38

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

Report message to a moderator

Re: database cloning [message #544088 is a reply to message #544086]

Mon, 20 February 2012 01:59

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.

Report message to a moderator

Re: database cloning [message #546066 is a reply to message #544088]

Mon, 05 March 2012 02:33

paddysmith
Messages: 2
Registered: March 2012
Location: USA

Junior Member

How to clone a database manually??????

Report message to a moderator

Re: database cloning [message #546068 is a reply to message #546066]

Mon, 05 March 2012 02:45

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

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

Report message to a moderator

Re: database cloning [message #553042 is a reply to message #546068]

Tue, 01 May 2012 05:41

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.

Report message to a moderator

Re: database cloning [message #553043 is a reply to message #553042]

Tue, 01 May 2012 05:58

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

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

Report message to a moderator

Previous Topic:	dblink and left join
Next Topic:	Two LAN Cards for Network Traffic Control Advantage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 23:35:55 CDT 2025