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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).