Re: How to change SID?

Hi Thiru:

It 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_at_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
>
Received on Wed Aug 25 1999 - 03:31:52 CDT