Re: Changing SID on an instance

Jason Edwards <jarv_at_chinook.halcyon.com> writes:  

>Does anybody out there know how to change the SID of a
>V6 instance on UNIX? We can't seem to find anything in the docs
>about it.
 

Hi.  

The name of the database is determined at database creation time from the information in the init.ora file. It cannot be changed after creation so far as I know.  

You could do a full export, then an incremental off to removable media, and then recreate your database with the new database name that you like and then log into the new database as system, import the incremental with inctype=system, then the full as inctype=restore, and then the incremental as inctype=restore. It would be very wise for you to create the second (new name) database first, using different datafiles mapped to the same tablespace names as the original, making sure you use different controlfile names and that you don't walk over any other part of the original database.  

And make SURE you have a good UNIX backup of all database and control files (done with the database shut down), AND verify that your exports are good and readable (use the show=y option to read your export file in without mucking up anything, and make sure it gets all the way to the end with no errors) BEFORE you embark on this, lest you end up clobbering your existing database.  

R. Scott Hunter shunter_at_cfotax.attmail.com AT&T Tax Systems Received on Wed Mar 30 1994 - 00:43:07 CEST