Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to change SID?
Ooops I forgot to mention that..It's been a long time since I did it ,the last time..
-Thiru
Cheong wrote:
Hi Thiru:Received on Wed Aug 25 1999 - 11:05:56 CDTIt works! (of course) --- thanks a whole bunch!
What were omitted were (step 3): change the db_name parameter in initSID.ora
or configSID.ora file, and make the ifile to point to the proper
configSID.ora file (if the ifile exists in initSID.ora file) before one runs
the CREATE CONTROLFILE script.Save for the annoying
ORA-00283: Recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
that scares me off initially --- only to find out that that was because of
the RESETLOGS parameter (that requires one to open the database using the
RESETLOGS option, which was already done at the end of the CREATE CONTROFILE
script).Have fun!
Cheong
tmgn wrote in message <37C2B059.1C3475AB@excite.com>...
>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
>