Re: Cloning a database

From: marko mikulicic <marko_at_seul.org>
Date: Mon, 20 Aug 2001 03:03:53 -0400
Message-ID: <3B80B659.9020401@seul.org>

Ban Spam wrote:

> marko mikulicic <marko_at_seul.org> wrote in news:3B7F589A.5070701_at_seul.org:
> 
> 

>>Hello,
>>
>>I have Oracle 9i on linux glib2.2.2 kernel 2.4.3
>>
>>
>>I created a little (400MB) database with dbca with no templates
>>and after hours of swapping (I have 512 RAM) and many failures
>>(the installer did not copy the STANDARD package).
>>Creation from templates was too big.
>>Somehow I managed to get it installed and now I don't want
>>pass again all this. I want to test replication on a single host, just
>>to learn how to do it, but I had not disk space to waste. Template
>>creation doesn't allow to change the tablespace dimensions, so I
>>thought that cloning that one with another name would do the job.
>>
>>But wich files do I need to copy ? (I know how to setup net stuff)
>>Is the databasename stored inside the database itself ?
>>
>>I have a slow machine with much ram, but oracle can be a hog :-)
>>
>>Thanks in advance
>>
>>
>>

> 
> Below is a SQL script that generate a Korne Shell script
> which I use to clone any DB. FWIW "pandora" is my test box.
> 
> set pages 0 feedback off lines 255
> spool clone-db.ksh
> select 'rcp ' || file_name || ' pandora:' || file_name || ' &' from 
> dba_data_files;
> select 'rcp ' ||      name || ' pandora:' ||      name || ' &' from v
> $controlfile;
> select 'rcp ' || member    || ' pandora:' || member    || ' &' from v
> $logfile;
> spool off
> 

Can this database run on the same machine or will have conflicting instance name ?

(If just coping would be necessary why just not recursiveliy copy the database directory?)

Marko Received on Mon Aug 20 2001 - 02:03:53 CDT