Re: How to change SID?

tmgn <tmgn_at_excite.com> wrote in message news: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
>

That's to rename the database and the SID

Alex Received on Tue Aug 24 1999 - 10:12:41 CDT