Cloning databases & changing SID.

From: terry norman <scott_at_tiger9.freeserve.co.uk>
Date: Fri, 12 Nov 1999 22:44:34 -0000
Message-ID: <80i5a6$emr$1@news7.svr.pol.co.uk>

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 Fri Nov 12 1999 - 16:44:34 CST