Re: Copying Database

You are on the right track...

1.) From your source database issue the command 'alter database backup controlfile to trace' , this will create a .trc file which you will modify and rename to a .sql file. You will use this file for two things: first, to create a copy script to copy all the files listed in it to a new location where you would like them to be for your second instance. Secondly, you will then use it to create your control file for your second instance.. remove any comments, modify the locations of all the files and change the following <create control file reuse database "dbname" noresetlogs> to <create control file set database "newdbname" resetlogs>. and make sure the last line reads alter database open resetlogs

3.) shutdown the source database

2.) set ORACLE_SID to the new value for your second instance.

3.) create new initsid.ora and configsid.ora files for your second instance(I copy them from the other instance), modify them to reflect the new sid and file locations of the second instance.

4.) run the script that will copy all your data files

5.) sqldba lmode=y

      connect internal
      startup nomount

6.) run your create control file .sql file

Don't forget to have complete backups before doing all this and you will have add this instance to any sqlnet related .ora files so that clients can connect..

Well, that should be about it.

Cheers, Robert Prendin
email me if you have any trouble..

Declan O'Reilly <declan_at_mcs.com> 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
>
Received on Wed Dec 10 1997 - 00:00:00 CST