Re: Clone a database

2002-01-10 Thread Beatriz Martínez Jiménez
Hello again, thanks all that have replied. I have another question. Is it possible to clone a database just only through OS operations? For example, is it possible to overwrite the files related with one database (.dbf, .ctl..) with the one related with the database to 'clone'? Maybe it sounds

RE: Clone a database

2002-01-10 Thread Martin Kendall
Yes it is quite possible to do just that. The only thing is that you have to generate a CREATE DATABASE command from the source DB by ALTER DATABASE BACKUP CONTROLFILE TO TRACE command. Note the CONTROLFILE does not have a space in it ! You then alter the contents of the Trace file to SET the

RE: Clone a database

2002-01-09 Thread Martin Kendall
Hi, Just to be absolutely sure as to what you have got in terms of a backup, please explain how exactly you obtained your backup from Enterprize Mgr. Martin -Original Message- Martínez Jiménez Sent: 09 January 2002 09:50 To: Multiple recipients of list ORACLE-L Hello list, I new to

Re: Clone a database

2002-01-09 Thread Ruth Gramolini
Have a look at None:73974.1 on Metalink. It give the step for cloning a database from backups. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 09, 2002 4:50 AM Hello list, I new to clone a database for changing

RE: Clone a database

2002-01-09 Thread Babich , Sergey
Hi, Beatriz, If you want to create an identical copy of your production (that's my understanding), it is a lot easier to export it (FULL=Y) and then import the dump file into your new database. Let me know if you need more info. Regards, Sergey Babich, Oracle DBA -Original Message-

RE: Clone a database

2002-01-09 Thread
Hello Beatriz Oracle 8i can export and import an entire tablespace and this is much faster then regular export/import. The procedure was published in XEPHON http://www.xephon.com. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED]

RE: Clone a database

2002-01-09 Thread Rachel Carmichael
easier perhaps only if you have the exact same disk layouts and space available. and certainly MUCH more time to create -- an import takes anywhere from 2-4 times as long as the export did. --- Babich , Sergey [EMAIL PROTECTED] wrote: Hi, Beatriz, If you want to create an identical copy of

RE: Clone a database

2002-01-09 Thread Babich , Sergey
With all my respect, this is not always the case Best regards, Serge -Original Message- Sent: Wednesday, January 09, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Subject:RE: Clone a database easier perhaps only if you have the exact same disk layouts and space

Re: Clone a database

2002-01-09 Thread Charlie Mengler
I have test system (pandora) with the EXACT same disk layout as my production box. I run the SQL below which generates a shell script. While the DB is down for cold backups, I have the operator run clone-db.ksh; which takes less time to complete than the backups. Once it completes I just start

Re: Clone a database

2002-01-09 Thread orantdba
Hi, If the backup was made using OEM, especially in later versions then the backup is a RMAN backup. Please look at your script contents to verify. The documentation discusses how to use rman backups to clone a database. John [EMAIL PROTECTED] wrote: easier perhaps only if you have the

RE: Clone a database

2002-01-09 Thread Jeremiah Wilton
: RE: Clone a database easier perhaps only if you have the exact same disk layouts and space available. and certainly MUCH more time to create -- an import takes anywhere from 2-4 times as long as the export did. --- Babich , Sergey [EMAIL PROTECTED] wrote: Hi, Beatriz, If you want

RE: Clone a database

2002-01-09 Thread Babich , Sergey
Thanks -Original Message- Sent: Wednesday, January 09, 2002 1:25 PM To: Multiple recipients of list ORACLE-L Subject:RE: Clone a database This message uses a character set that is not supported by the Internet Service. To view the original message content, open

RE: Clone a database

2002-01-09 Thread Rachel Carmichael
, Sergey wrote: With all my respect, this is not always the case Best regards, Serge -Original Message- Sent: Wednesday, January 09, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Subject:RE: Clone a database easier perhaps only if you have the exact same

RE: Clone a database

2002-01-09 Thread DENNIS WILLIAMS
With all my respect, this is not always the case Best regards, Serge -Original Message- Sent: Wednesday, January 09, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Subject:RE: Clone a database easier perhaps only if you have the exact same disk layouts and space

RE: Clone a database

2002-01-09 Thread DENNIS WILLIAMS
respect, this is not always the case Best regards, Serge -Original Message- Sent: Wednesday, January 09, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Subject:RE: Clone a database easier perhaps only if you have the exact same disk layouts and space available

RE: Clone a database

2002-01-09 Thread Rajesh . Rao
AFAIK, RMAN has a duplicate command, which will initiate a backup, copy the concerned datafiles onto the target host, and then perform an incomplete recovery using the archived logs. This will also generate a unique DBID for the new cloned database. I have never used this. But am curious to