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.
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   Hi
  Guys,
  <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 - 06:10:42 CST