Re: Copying Database

You are actually on the right track, what you need to do is take the existing database and create a control file. The first thing you do is BACKUP YOUR PRODUCTION DATABASE!!!. Now create new create controlfile script. You do this from your existing database with the command: "alter database backup control file to trace". Next, shutdown the database and copy the redo logs and database files to a new location (it is good to also rename them as well - just document - so that you can easily perform the next step). The trace file is going to be dumped into your user trace directory, with the same cryptic format that it usually takes, so just look for the trace file with the time that you performed the command. Now, edit the file, remove all the junk from the top and change the create controlfile command to read

   create controlfile set database "newdbname" resetlogs

Next, create a new init.ora file with new names for the control files. Now shutdown the existing database, or this won't work. Now go into the new SID. In unix it is ORACLE_SID=newdbname;export ORACLE_SID

connect internal and run this new create script. Voila, you have a new database!

Declan O'Reilly wrote:

> I would like to create a second instance of my database on the same
> Unix Server.
> I was wondering is it possible to copy of all the tablespace, rollback
> and redo files
> to a new destination and then update the copied system tablespace with
> the new locations
> of the tablespaces etc, aswell as creating a new init???.ora file. Is
> this all there is to it or am I way off base.
>
> Thanks
> Declan O'Reilly

--
If you want to respond to me via email, remove "want no spam at all"
from my address.  You'd think spammers would get a clue by now.....

Sheilah Scheurich
DBA