Re: How to change SID?

From: tmgn <tmgn_at_excite.com>
Date: Tue, 24 Aug 1999 11:24:46 -0400
Message-ID: <37C2B93E.C48ECA84@excite.com>

Yup ..Pls see my earlier posting..
Thx

-thiru

Alex Hudghton wrote:

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

That's to rename the database and the SID

Alex

Received on Tue Aug 24 1999 - 10:24:46 CDT