Re: Cloning databases & changing SID.

Terry

To change the SID all you need to do is change the name of the initSID.ora and set your ORACLE_SID appropriately

To change the name of the database and the SID do the above and this :

In the trace script amend

CREATE CONTROLFILE USE DATABASE "SID" RESETLOGS NOARCHIVELOG to

CREATE CONTROLFILE SET DATABASE "NEWSID" RESETLOGS NOARCHIVELOG and change the db_name in the initSID.ora file

Alex

On Fri, 12 Nov 1999 22:44:34 -0000, "terry norman" <scott_at_tiger9.freeserve.co.uk> wrote:

>Dear all,
>
>I found details somewhere of how to copy a database's files to another
>machine and by doing an "alter database backup controlfile to trace" on the
>original machine, then copying over the trace control file and editing it to
>change the path names, one could "clone" a new database. I lost the details
>but still managed to busk it and get this to work. Obviously this is to
>create a database for testing, similar to a live one. What it wouldn't let
>me get away with however was changing the SID. Does anyone know how to do
>that please? The "clone" is up and running ok, but I would like it to have a
>different SID from the live one to avoid any career limiting accidents.
>
>T very much IA.
>
>Terry.
>
>
Received on Mon Nov 15 1999 - 09:36:57 CST