Re: How to change SID?

You need to REcreate the Control file to achieve this .

1. SVRMGR>Alter Database backup controlfile to trace; # this will generate an Ascii Trace file in $USER_DUMP_DEST directory which will have the Control File Creation Script.
2. Shutdown the Database and Do a Physical Backup of all the Datafiles,Controlfiles,RedoLog files,Archived Redo log files etc etc...for Safety.
3. Rename the Init<oldSID>.ora and config<OLDSID>.ora to Init<NEWSID>.ora and Config<NewSid>.ora files in $ORACLE_HOME/dbs This is to prevent any errors during Database Startups looking for default 'pfile' names.

4.Rename the Old Controlfiles to say control01.old etc This is to Create New Controlfile and not reuse the existing one.

5 Edit the Control File creation Script ..It should read like

 Startup nomount;
  Create Controlfile set Database 'NEW_SID' Resetlogs ...... <all others remain the Same>
;
5.alter database open resetlogs;
.
Hope this helps

-Thiru

Cheong wrote:

> Hi:
>
> Surely there's are ways to change SID without recreating a db.
>
> I've scanned through the posted messages but found none, unfortunately.
>
> Can someone give me a hint or point me to where I could find some info on
> this?
>
> Thanks in advance!
>
> Best regards,
> Cheong
Received on Tue Aug 24 1999 - 09:46:49 CDT