Re: Clone Oracle Database

From: Myron Wintonyk <mwintony_at_med.ualberta.ca>
Date: Thu, 22 Feb 2001 13:53:33 +1000
Message-ID: <3A948D3D.4A0CAB2F@med.ualberta.ca>

If the hardware is similar (same O/S, same Oracle version), then you can simply copy
all the data files to the new location. Once that is done, you recreate the control files
(and the redo logs), with a script similar to this:

    startup nomount
    create controlfile set database "NEWSID" resetlogs noarchivelog reuse

        logfile group 1 'redologfile1',
                  group 2 'redologfile 2'
      datafile 'file1','file2','file3' ...
      character set xxxx;

alter databae open resetlogs;
alter database rename global_name to NEWSID;

That should do it. Again, assuming that the environments are "similar".

"Frédéric Houbie" wrote:

> Hi,
>
> I have a Oracle database here in Belgium. I need to install this database (a
> copy) somewhere else, how can I burn a CD with necessary files (which ones
> ??) and what is the procedure to use it on another Oracle Server ?
>
> Thanks
>
> Frédéric
Received on Wed Feb 21 2001 - 21:53:33 CST