RE: how to clone a DB ?

From: Inka Bezdziecka <IBezdziecka_at_cupe.ca>
Date: Mon, 07 Oct 2002 07:00:48 -0800
Message-ID: <F001.004E22D5.20021007070048@fatcity.com>

On the source database run:
alter database backup controlfile to trace;

Edit trace file according to the file system, save it as name.sql and run it on a target database. Change init.ora where required (e.g. number of control files, rollback segments automatically brought on line, archiving destination and so on).

inka

-----Original Message-----
Sent: Monday, October 07, 2002 5:33 AM
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: Inka Bezdziecka
  INET: IBezdziecka_at_cupe.ca

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 - 10:00:48 CDT