RE: creating the database from another

[Mercadante, Thomas F]

Bunyamin,   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 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. Shutdown the SourceDB database. Copy all of the files from the SourceDB directories to the TargetDB directories. Copy the init.ora file from SourceDB to TargetDB.   On the TargetDB machine, create the Oracle services using ORADIM:   ORADIM -new -pid {sid} -pfile c:\oracle\ora816\database\init{sid}.ora   This will create the Oracle services, and will attempt to open the database.  Check the Alert{sid}.log file for success or failure.     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.   hope this helps.     Tom Mercadante Oracle Certified Professional -----Original Message----- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: 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