RE: Duplicating a Database and Changig SID

From: Prakriteswar Santikary <prakriteswar.santikary_at_pointinfo.com>
Date: Fri, 30 Nov 2001 08:39:04 -0800
Message-ID: <F001.003D1FC5.20011130082031@fatcity.com>

Ron,

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


<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'"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />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

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

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

-----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 Sonja,
 
 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).
 
 At
 the end, you will find how to alter the dbid so that RMAN will see it as a new database.
 
 Be
 sure to bounce the instance as instructed. 
 -Ron-
 <BLOCKQUOTE dir=ltr
 style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> -----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.
 
 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-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman'; 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,

Received on Fri Nov 30 2001 - 10:39:04 CST