RE: Duplicating a Database and Changig SID

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,