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: Kevin Fries <kfries_at_lart.com>
Date: Thu, 29 Nov 2001 17:08:57 -0800
Message-ID: <F001.003D159C.20011129161525@fatcity.com>

I'm
interested, please post it to the list.
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff solid 2px; MARGIN-LEFT: 5px; 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 Ron YountSent:     Thursday, November 29, 2001 5:50 PMTo: 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
    style="BORDER-LEFT: #0000ff solid 2px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px"     dir = ltr>

<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) 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 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,
Received on Thu Nov 29 2001 - 19:08:57 CST

Original text of this message

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