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