Re: How to change SID?

Actually this Procedure Renames the Database as well as the 'SID' .. If you want to Change only the SID , then carry out only the Step 3 + Change ORACLE_SID environmental Variable , /var/opt/oracle/oratab or /etc/oratab and all other references to ORACLE_SID..

-Thiru

tmgn wrote:

> 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 - 10:08:26 CDT