RE: how to clone a DB ?

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Mon, 07 Oct 2002 03:18:32 -0800
Message-ID: <F001.004E1F8D.20021007031832@fatcity.com>

1. ALTER DATABASE BACKUP CONTROLFILE TO TRACE
2. Either use the hot backup technique to copy the datafiles or shutdown the DB and copy all the datafiles.
3. Copy the Datafiles and logs to the appropriate disks in HOST2
4. Create the instance using the copied PFILE and ORADIM
5. Change the names of the datafiles and redo-logs in the create controlfile statement generated by step 1
6. Start the instance without mounting - STARTUP NOMOUNT
7. Create controlfile using the create control file statement.
8. If you used the consistent set of datafiles open database resetlogs or else recover database after applying the archived redo-logs.

Hope i didn't miss anything ;-)

Regards
Naveen

-----Original Message-----
Sent: Monday, October 07, 2002 3:03 PM
To: Multiple recipients of list ORACLE-L

Guys ,

i want to clone DB1 on host HOST1 to HOST2. i have installed oracle on HOST2 with the default DB created. the disk layout on HOST1 is different from that of HOST2. the environment is 8.1.6/win2k.

the files to be copied are all datafiles , log files and control files.
ami right ?

since the disk layout is differnet , how should i rename the datafiles/log files/control files ?
can someone throw light and explain me all the steps involved in detail ?

Thanx in advance.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: oraora oraora
  INET: oraoraora_at_rediffmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Oct 07 2002 - 06:18:32 CDT