Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cloning databases & changing SID.

Re: Cloning databases & changing SID.

From: terry norman <scott_at_tiger9.freeserve.co.uk>
Date: Tue, 16 Nov 1999 19:39:15 -0000
Message-ID: <80sbv0$mts$1@news5.svr.pol.co.uk>

Alex, Thanks a lot.   Regards, Terry.
Alex Hudghton <alex_at_alenda.freeserve.co.uk> wrote in message
news:382fe548.6658871_at_news.freeserve.net...

> 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 Tue Nov 16 1999 - 13:39:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US