Re: Can the SID be changed?

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Mon, 16 Jun 2003 16:29:13 -0400
Message-ID: <QPpHa.10280$945.30023@tor-nn1.netcom.ca>

alter database backup controlfile to trace

edit the trace file and change the CREATE CONTROLFILE command to say CREATE CONTROLFILE REUSE SET DATABASE "NEWSID" RESETLOGS (note the SET keyword)

Shutdown immediate your db,
modify the dbname in the init.ora
connect / as sysdba
startup nomount the database
and execute the create controlfile command. recover database USING BACKUP CONTROLFILE until cancel CANCEL
Then open resetlogs the database and
ALTER DATABASE RENAME GLOBAL_NAME TO newsid;

Corrections/additions welcome

-- 

OpenVMS 7.2-1, Oracle 8.1.6.0

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove zulu from my address

"Big Chuck" <ccarson_at_echeeba.com> a écrit dans le message de
news:3EEE1D16.8010103_at_echeeba.com...


>

> Is it possible to change the SID of a data base and if so how?

>

> Thx,

> CC

>

Received on Mon Jun 16 2003 - 15:29:13 CDT