how can i clone another database from a production one?

**ngwh** · 03-09-2003, 01:01 AM

HI,

I am curious as to how I can clone a database from a current production which I cannot shutdown to perform a cold backup and then dump into the "clone" machine ??

Would just the online hotbackups of datafiles, all the archived logfile,init.ora file and the recreation script to recreate the controlfiles be sufficient?

Please enlighten me as I do not have a spare server to try this out.

thank-u in advance for any kind soul out there

**stmontgo** · 03-09-2003, 01:13 AM

look into rman and it's duplicate database function as well

**ngwh** · 03-09-2003, 01:24 AM

can we do it without RMAN? beCause we are planning for a Disaster recovery procedure was wondering if we just have datafiles,init.ora and archived logfiles would we be able to reconstruct the database?

thank-u

**marist89** · 03-09-2003, 01:39 AM

Yup, I do it all the time...

**ngwh** · 03-09-2003, 01:45 AM

Hi marist89,

Would u be able to tell us here in details how did u do it?
I believe many of us who are ignorant will be keen to know

thank in advance.

**nabeel** · 03-09-2003, 02:18 AM

If u are not shutting down the database, how u will copy the datafile... I think u got 2 options..

1) Manual Hot backup (Placing Individual TS in backup mode)
2) Using a third party backup software i.e Legato

and ofcourse RMAN

What i think in the current situation ngwh, we have to perform manual online backup then apply the archive logfiles, but in this situation u have to take care of ya data trasfer rate b/w the machines... coz if u have large datafile they might take time to copy.

Well senior DBA's correct me if i am wrong...Keen to know more options..

**pando** · 03-09-2003, 04:44 AM

it has been discussed many times, search the forum

**ngwh** · 03-09-2003, 08:32 PM

hi all,

As far as i can figure out...steps for cloning hot backups with archived logfiles :

1)makesure u got a trace copy of controlfile,hotbackup datafiles and all uptodate archived logfiles lastly init.ora with correct SID setting and so on
2)recreate controlfile using the trace copy u got
3)perform a recover database using backup controlfile and recover until cancel

that's it!

correct me if i am wrong?

**SANJAY_G** · 03-09-2003, 11:36 PM

http://www.quest-pipelines.com/newsletter/cloning.htm

**pando** · 03-10-2003, 02:25 AM

Originally posted by ngwh
hi all,

As far as i can figure out...steps for cloning hot backups with archived logfiles :

1)makesure u got a trace copy of controlfile,hotbackup datafiles and all uptodate archived logfiles lastly init.ora with correct SID setting and so on
2)recreate controlfile using the trace copy u got
3)perform a recover database using backup controlfile and recover until cancel

that's it! correct me if i am wrong?

I dont understand, why you dont search the old threads?

Thread: how can i clone another database from a production one?

Thread Tools

Display

how can i clone another database from a production one?

Posting Permissions