Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Production Issue: How to change the database name (sid) i...

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

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Thu, 16 Nov 2000 11:24:58 -0500
Message-Id: <10682.122262@fatcity.com> 





This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.



------_=_NextPart_001_01C04FE9.C59F2A20


Content-Type: text/plain;


        charset="iso-8859-1"



What is the sequence if you copy DB files during hot backup - not stoppimg
the database.



Alex Hillman



-----Original Message-----


From: Babu.Nagarajan_at_Cummins.com [mailto:Babu.Nagarajan_at_Cummins.com]
Sent: Thursday, November 16, 2000 9:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Production Issue: How to change the database name (sid)
i...





hi



if it is not late



    
  
  1.   start prod instance
  
  2.   alter system backup control file to trace.
  
  3.   shutdown prod and copy files to new location. start prod instace back.
  
  4.   edit the trace file and repoint all the datafiles to the new location.
  
  5.   change the create control file command. change from "create control file
database prod... noresetlogs " to
    create control file SET database dev... RESETLOGS"
  
  6.   change the last line in the trace file "open database " to "open
database RESETLOGS"
  
  7.   save it as a sql file.
  
  8.   edit the env and reset SID to test.
  
  9.   login to svrmgrl and run the sql file u saved in step 6.






babu







Hannah.M.Doran_at_sb.com_at_fatcity.com on 11/14/2000 02:45:24 PM



Please respond to ORACLE-L_at_fatcity.com



Sent by:  root_at_fatcity.com




To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:








Subject:


Production Issue: How to change the database name (sid) in a controlfile






Hi List.




     I am having an issue.  I just created a test and devl instance on my
development machine (NT SP4, Oracle 7.3.4).  In the past I only had one
instance


and it had the same SID (ORCL) as production.  Since these are Development
and


test environments, I used to be able to quickly replicate the prod data by
just


copying over the database base files and bringing up the instance.  Taaa
daaaaa!


Very quick for a 3 GB db.....



     Anyway, I needed to develop two instances, so rebuilt my nt box,
created 2


instances: test, devl.  I have copied over the db files from prod, but
forgot OH


NO, the db name in the control file is now out of sync!  I'm running 7.3.4
and


do NOT have the db schema set up (its a vendor app ~500-600 tables - no ddl
scripts).



     Anyone know fo a way to change the db name in a control file?
Otherwise my


life will be hell and will probably have to start from scratch for both new
instances!




Any suggestions?  These are only test and development environments, so I'm
looking for QUICK in porting my prod data.  In the past, this was the
quickest


way to do it.



Thanks in advance.



Hannah



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

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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Babu.Nagarajan_at_Cummins.com

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).

------_=_NextPart_001_01C04FE9.C59F2A20
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: Production Issue: How to change the database name (sid) =
i...</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>What is the sequence if you copy DB files during hot =
backup - not stoppimg the database.</FONT>
</P>

<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Babu.Nagarajan_at_Cummins.com [<A =
HREF=3D"mailto:Babu.Nagarajan_at_Cummins.com">mailto:Babu.Nagarajan_at_Cummins=
.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, November 16, 2000 9:55 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: Production Issue: How to change the =
database name (sid)</FONT>
<BR><FONT SIZE=3D2>i...</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>hi</FONT>
</P>

<P><FONT SIZE=3D2>if it is not late</FONT>
</P>

<P><FONT SIZE=3D2>1. start prod instance</FONT>
<BR><FONT SIZE=3D2>2. alter system backup control file to trace.</FONT>
<BR><FONT SIZE=3D2>4. shutdown prod and copy files to new location. =
start prod instace back.</FONT>
<BR><FONT SIZE=3D2>3. edit the trace file and repoint all the datafiles =
to the new location.</FONT>
<BR><FONT SIZE=3D2>4. change the create control file command. change =
from &quot;create control file</FONT>
<BR><FONT SIZE=3D2>database prod... noresetlogs &quot; to</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; create control file SET database =
dev... RESETLOGS&quot;</FONT>
<BR><FONT SIZE=3D2>5. change the last line in the trace file &quot;open =
database &quot; to &quot;open</FONT>
<BR><FONT SIZE=3D2>database RESETLOGS&quot;</FONT>
<BR><FONT SIZE=3D2>6. save it as a sql file.</FONT>
<BR><FONT SIZE=3D2>7. edit the env and reset SID to test.</FONT>
<BR><FONT SIZE=3D2>8. login to svrmgrl and run the sql file u saved in =
step 6.</FONT>
</P>

<P><FONT SIZE=3D2>babu</FONT>
</P>
<BR>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2>Hannah.M.Doran_at_sb.com_at_fatcity.com on 11/14/2000 =
02:45:24 PM</FONT>
</P>

<P><FONT SIZE=3D2>Please respond to ORACLE-L_at_fatcity.com</FONT>
</P>

<P><FONT SIZE=3D2>Sent by:&nbsp; root_at_fatcity.com</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>To:&nbsp;&nbsp; Multiple recipients of list ORACLE-L =
&lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=3D2>cc:</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2>Subject:</FONT>
<BR><FONT SIZE=3D2>Production Issue: How to change the database name =


(sid) in a controlfile</FONT>

<BR><FONT SIZE=3D2>---------------------------------</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hi List.</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; I am having an issue.&nbsp; =
I just created a test and devl instance on my</FONT>
<BR><FONT SIZE=3D2>development machine (NT SP4, Oracle 7.3.4).&nbsp; In =
the past I only had one</FONT>
<BR><FONT SIZE=3D2>instance</FONT>
<BR><FONT SIZE=3D2>and it had the same SID (ORCL) as production.&nbsp; =
Since these are Development</FONT>
<BR><FONT SIZE=3D2>and</FONT>
<BR><FONT SIZE=3D2>test environments, I used to be able to quickly =
replicate the prod data by</FONT>
<BR><FONT SIZE=3D2>just</FONT>
<BR><FONT SIZE=3D2>copying over the database base files and bringing up =
the instance.&nbsp; Taaa</FONT>
<BR><FONT SIZE=3D2>daaaaa!</FONT>
<BR><FONT SIZE=3D2>Very quick for a 3 GB db.....</FONT>
</P>

<P><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; Anyway, I needed to develop =
two instances, so rebuilt my nt box,</FONT>
<BR><FONT SIZE=3D2>created 2</FONT>
<BR><FONT SIZE=3D2>instances: test, devl.&nbsp; I have copied over the =
db files from prod, but</FONT>
<BR><FONT SIZE=3D2>forgot OH</FONT>
<BR><FONT SIZE=3D2>NO, the db name in the control file is now out of =
sync!&nbsp; I'm running 7.3.4</FONT>
<BR><FONT SIZE=3D2>and</FONT>
<BR><FONT SIZE=3D2>do NOT have the db schema set up (its a vendor app =
~500-600 tables - no ddl</FONT>
<BR><FONT SIZE=3D2>scripts).</FONT>
</P>

<P><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; Anyone know fo a way to =
change the db name in a control file?</FONT>
<BR><FONT SIZE=3D2>Otherwise my</FONT>
<BR><FONT SIZE=3D2>life will be hell and will probably have to start =
from scratch for both new</FONT>
<BR><FONT SIZE=3D2>instances!</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Any suggestions?&nbsp; These are only test and =
development environments, so I'm</FONT>
<BR><FONT SIZE=3D2>looking for QUICK in porting my prod data.&nbsp; In =
the past, this was the</FONT>
<BR><FONT SIZE=3D2>quickest</FONT>
<BR><FONT SIZE=3D2>way to do it.</FONT>
</P>

<P><FONT SIZE=3D2>Thanks in advance.</FONT>
</P>

<P><FONT SIZE=3D2>Hannah</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Author:</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: Hannah.M.Doran_at_sb.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =


(like subscribing).</FONT>

</P>
<BR>
<BR>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: </FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: Babu.Nagarajan_at_Cummins.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =


Received on Thu Nov 16 2000 - 10:24:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US