RE: Production Issue: How to change the database name (sid)

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 15 Nov 2000 12:28:11 -0500
Message-Id: <10681.122133@fatcity.com>

Hannah,
 You could use the "run" command from the svrmgr prompt to run a file on = the server. @ora:\files\startup\doit
ROR m=AA=BF=AAm

>>> Hannah.M.Doran_at_sb.com 11/15/00 11:41AM >>>

THANK YOU, THANK YOU, THANK YOU, THANK YOU ALL! Got it, DID it, both instances up and running perfectly.....

Thanks for all of the advice.....

     Now, I'll just write up a little procedure so I never have to ask = again:>

     FYI       - create a dump to trace of the prod control file


          - copy prod db files to test server (DELETE THE CONTROL FILES =

--- or
you have to type the whole script in again!) --- did it:>

• edit the script (Use SET OPTION, RESETLOGS, made sure file = paths correct for test environment etc).
• startup nomount db
• laboriously type the script into server manager (7.3.4) = ARGH!!!!!! ----- a few million times:> gotta be a better way to do this!
• shutdown immediate db
• startup mount db
• alter db open resetlogs
• DONE:>

P.S.> after creating the controlfile, the db is still in nomount state, therefore could not
use ALTER DATABASE OPEN RESETLOGS

since I did not need to recover the db, I did a shutdown immediate, then = startup
mount,
then the alter statement and it came right up.

Thanks,

     Hannah

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author:=20
  INET: Hannah.M.Doran_at_sb.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 15 2000 - 11:28:11 CST