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   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 color=#0000ff face=Arial
  size=2> 
  <FONT color=#0000ff face=Arial
  size=2>-Ron-
  <BLOCKQUOTE dir=ltr
  style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">
<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-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; 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)
2. Copy all your datafile, logfiles, controlfiles to the new location
3. 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 color=#0000ff face=Arial 
      size=2>Hi Guys,
      <FONT color=#0000ff face=Arial 
      size=2> 
      <FONT color=#0000ff face=Arial 
      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 color=#0000ff face=Arial 
      size=2> 
      <FONT color=#0000ff face=Arial 
      size=2>Thanks,