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: Duplicating a Database and Changig SID

RE: Duplicating a Database and Changig SID

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Fri, 30 Nov 2001 08:53:08 -0800
Message-ID: <F001.003D2045.20011130083522@fatcity.com> 







Same here Ron.....will 


really appreciate it if u could send me the file at my email 
id


as an attachment......I 


think the LIST doesnt support attachments......else, a text 
file


will also 


help.


 


Samir Sarkar 


Oracle DBA - Lennon 


Team Schlumberger<FONT 


face=Impact color=#800000>Sema 


Email :  


samir.sarkar_at_nottingham.sema.slb.com <FONT face=Verdana 
color=#000080 


size=1>            


samir.sarkar_at_sema.co.uk <FONT face=Verdana 
color=#000080 size=1>Phone : +44 (0) 115 - 95 76217 
EPABX : +44 (0) 115 - 957 6418 



Ext. 76217 Fax 


: +44 (0) 115 - 957 


6018            




  <FONT face=Tahoma 



  size=2>-----Original Message-----From: Prakriteswar Santikary 
  [mailto:prakriteswar.santikary_at_pointinfo.com]Sent: 30 November 2001 
  16:21To: Multiple recipients of list ORACLE-LSubject: 
  RE: Duplicating a Database and Changig SID


  <FONT face=Arial color=#0000ff 



  size=2>Ron,


  <FONT face=Arial color=#0000ff 



  size=2> 


  I 


  was trying to open your attached document. I get this 
  error:


  <FONT face=Arial color=#0000ff 



  size=2> 


    


  <SPAN 



  style="mso-fareast-font-family: 'MS Mincho'"><encoded content removed -- 
  binaries not allowed by ListGuru>


  <SPAN 



  style="mso-fareast-font-family: 'MS Mincho'"> 


  <SPAN 



  style="mso-fareast-font-family: 'MS Mincho'"><SPAN 
  class=342482619-30112001>Could you pl. 
  send this doc as .txt file to me ? I would really appreciate 
  that.


  <SPAN 



  style="mso-fareast-font-family: 'MS Mincho'"><SPAN 
  class=342482619-30112001><FONT face=Arial color=#0000ff 
  size=2> 


  <SPAN 



  style="mso-fareast-font-family: 'MS Mincho'"><SPAN 
  class=342482619-30112001><FONT face=Arial color=#0000ff 
  size=2>thanks


  <SPAN 



  style="mso-fareast-font-family: 'MS Mincho'"><SPAN 
  class=342482619-30112001><FONT face=Arial color=#0000ff 
  size=2>Santi
  


    <FONT face=Tahoma 


    size=2>-----Original Message-----From: Ron Yount 
    [mailto:ronwy_at_swbell.net]Sent: Friday, November 30, 2001 7:41 
    AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
    Duplicating a Database and Changig SID
    <SPAN 


    class=643433715-30112001>Sonja,


    <SPAN 


    class=643433715-30112001> 


    <SPAN 


    class=643433715-30112001>Here are my rough instructions for how to duplicate 
    a database (by copying files) and then how to alter the database name 
    (typically referred to as "cloning" a database).  
    <SPAN 


    class=643433715-30112001> 


    At 


    the end, you will find how to alter the dbid so that RMAN will see it as a 
    new database.


    <SPAN 


    class=643433715-30112001> 


    Be 


    sure to bounce the instance as instructed.
    <SPAN 


    class=643433715-30112001> 


    <SPAN 


    class=643433715-30112001>-Ron-


    <BLOCKQUOTE dir=ltr 


    style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">

      <FONT face="Times New Roman" 
      size=2>-----Original Message-----From: root_at_fatcity.com 
      [mailto:root_at_fatcity.com]On Behalf Of Sonja SehovicSent: 
      Friday, November 30, 2001 3:11 AMTo: Multiple recipients of 
      list ORACLE-LSubject: RE: Duplicating a Database and Changig 
      SID
      Yes, 
      please, I'm very interested.
      <SPAN 
      class=490540509-30112001> 
      <SPAN 
      class=490540509-30112001>Sonja
      
        <FONT face=Tahoma 
        size=2>-----Original Message-----From: Ron Yount 
        [mailto:ronwy_at_swbell.net]Sent: Friday, November 30, 2001 
        12:50 AMTo: Multiple recipients of list 
        ORACLE-LSubject: RE: Duplicating a Database and Changig 
        SID
        <FONT face=Arial color=#0000ff 
        size=2>If you are using RMAN and would like some direction on how to 
        change the DBID as well, let me know and I will send you some 
        directions/steps for that as well.
        <FONT face=Arial color=#0000ff 
        size=2> 
        <FONT face=Arial color=#0000ff 
        size=2>-Ron-
        <BLOCKQUOTE dir=ltr 
        style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
          <FONT face="Times New Roman" 
          size=2>-----Original Message-----From: root_at_fatcity.com 
          [mailto:root_at_fatcity.com]On Behalf Of Sonja 
          SehovicSent: Thursday, November 29, 2001 5:45 
          AMTo: Multiple recipients of list 
          ORACLE-LSubject: RE: Duplicating a Database and Changig 
          SID
          <SPAN 
          class=054404410-29112001>Hi!
          <SPAN 
          class=054404410-29112001> 
          Before 
          I tell you procedure, be aware that when you make a clone of your 
          database DBID remains the same, which is a problem if you use RMAN for 
          you backups.
          <SPAN 
          class=054404410-29112001> 
          Steps 
          are:
          0. On 
          your database issue: 
          <FONT 
          face="Times New Roman" size=3>     <FONT 
          face=Arial><SPAN lang=EN-US 
          style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 10.0pt; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">alter 
          database backup controlfile to trace 
          resetlogs;
          1. 
          Backup your database.
          <SPAN 
          class=054404410-29112001>2. Shutdown database (shutdown 
          immediate)
          3. Copy 
          all your datafile, logfiles, controlfiles to the new 
          location
          4. Edit 
          your new init.ora file and change DB_NAME, DB_BLOCK_SIZE must be the 
          same, 
            
            change path for controlfiles, user_dump_dest, 
          background_dump_dest, core_dump_dest
          5. 
          Edit  your new controlfile (which you get in step 0) and change 
          it in:
          <SPAN 
          class=054404410-29112001>        
          CREATE CONTROLFILE REUSE SET DATABASE 'NEWSID' RESETLOGS 
          
          <SPAN 
          class=054404410-29112001>    and change the path of 
          datafiles and logs
          6. 
          Recreate you control file.
          7. 
          Change your tnsnames.ora and sqlnet.ora files.
          <SPAN 
          class=054404410-29112001> 
          This 
          should do. 
          I had 
          no problems in doing that
          <SPAN 
          class=054404410-29112001> 
          <SPAN 
          class=054404410-29112001>HTH,
          <SPAN 
          class=054404410-29112001>    Sonja
           
          
            <FONT face=Tahoma 
            size=2>-----Original Message-----From: MRaval 
            [mailto:MRaval_at_giorgioarmani.com]Sent: Wednesday, 
            November 28, 2001 7:55 PMTo: Multiple recipients of list 
            ORACLE-LSubject: Duplicating a Database and Changig 
            SID
            <FONT face=Arial color=#0000ff 
            size=2>Hi Guys,
            <FONT face=Arial color=#0000ff 
            size=2> 
            <FONT face=Arial color=#0000ff 
            size=2>I am newbie oracle DBA and want to duplicate my  
            development database to Test database and want to change ORACLE_SID, 
            Could anyone tell exact steps that I have to follow. My database is 
            on SUN 5.6 and oracle 8.1.6.
            <FONT face=Arial color=#0000ff 
            size=2> 
            <FONT face=Arial color=#0000ff 
            size=2>Thanks,

___________________________________________________________________________


This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 


If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.



If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.


Received on Fri Nov 30 2001 - 10:53:08 CST












Original text of this message













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