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: Ron Yount <ronwy_at_swbell.net>
Date: Thu, 29 Nov 2001 16:03:30 -0800
Message-ID: <F001.003D14F5.20011129155020@fatcity.com>

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)
  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
    Hi
    Guys,
    <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 Thu Nov 29 2001 - 18:03:30 CST

Original text of this message

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