RE: creating the database from another

<SPAN

class=958071417-27082001>Bunyamin,
<SPAN

class=958071417-27082001> 
Let's
call the database that already exists the SourceDb, and the new one you want to create the TargetDB
Do the
following:
 
On the TargetDB<SPAN
class=958071417-27082001> machiine,
create the same directory
structure that exists on the SourceDB
machine.  This should include the directories where the database files exist(db_data_files), control files (v$controlfile), log files (v$logfile), as well as the oracle bdump and udump
directories.
<SPAN

class=958071417-27082001>Shutdown the SourceDB database.
<SPAN

class=958071417-27082001>Copy all of the files from the SourceDB directories to the TargetDB directories.
<SPAN

class=958071417-27082001>Copy the init.ora file from SourceDB to TargetDB.
<SPAN

class=958071417-27082001> 
<SPAN

class=958071417-27082001>On the TargetDB machine, create the Oracle services using ORADIM:
<SPAN

class=958071417-27082001> 
<SPAN

class=958071417-27082001>ORADIM -new -pid {sid} -pfile c:\oracle\ora816\database\init{sid}.ora
<SPAN

class=958071417-27082001> 
<SPAN

class=958071417-27082001>This will create the Oracle services, and will attempt to open the database.  Check the Alert{sid}.log file for success or failure.
<SPAN

class=958071417-27082001> 
<SPAN

class=958071417-27082001> 
<SPAN

class=958071417-27082001>If you wish to change the SID name, you will need to re-create the control files.  Look at issuing a 'alter database backup controlfile to trace'; command on the SourceDB database to produce the create control file command to run on the TargetDB machine.
<SPAN

class=958071417-27082001> 
<SPAN

class=958071417-27082001>hope this helps.
<SPAN

class=958071417-27082001> 
 
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Bunyamin K. Karadeniz   [mailto:bunyamink_at_havelsan.com.tr]Sent: Monday, August 27, 2001   12:40 PMTo: Multiple recipients of list ORACLE-LSubject:   creating the database from another
  I have a 8.1.6 database on NT on one machine .   And I want to create this database to another machine where oracle is   installed but there is no database.  I have the back up of   datafiles,control files and redo log files and archieve files.    
   Can you tell What I will do step by step ?   Is there a such a document ?
   
  Thank you
  Bunyamin
    Received on Mon Aug 27 2001 - 12:20:52 CDT