Re: How to create a copy of an Instance?

I think you will find your answer in the SET parameter of the Create controlfile command. This will rename your database. You should also consider changing the controlfile parameter and the db_name parameter in your init.ora file to represent your new database.

==========Michael Nolan, 2/16/95========== Steve Butler <sbut-is_at_seatimes.com> writes:

>On 14 Feb 1995, Michael Nolan wrote:
 

>> What's the easiest way to create a duplicate copy of an instance
>> on the same machine but with files in different directories? (with a
>> different SID, obviously)

[Most of recommended procedure deleted] I received a similar recommendation from another reader in the Netherlands. (isn't the net wonderful!)

>You will need to edit that new SQL script to reference the new data file
>locations. You can also change the name of the database by changing it
>in the CREATE CONTROLFILE line of this script.
 

>CREATE CONTROLFILE REUSE DATABASE newname NORESETLOGS NOARCHIVELOG

It doesn't appear that you can change the database name when you issue the CREATE CONTROLFILE command under 7.0.15. I get a message complaining that the database name isn't the same as that in the headers, and it won't create the control files. The SQL Reference Manual for 7.0 states that the database name 'must be the existing database name'. (If this has been changed for 7.1, I don't see it documented as such.)

The fix I'm going to try is to shut down the live database again tonight, back it up again (just in case), rebuild the controlfiles as suggested but under the original database name, then issue an ALTER DATABASE RENAME GLOBAL_NAME TO XXXXX; command to change the global name, shut it down, restart the live database, modify the control files and restart the cloned database, and see if everything works.

---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan_at_notes.tssi.com, dbms_at_genie.geis.com
(posted from nolan_at_helios.unl.edu)