Re: Copying Database

Robert,

            I have a similiar situation in that we are running Oracle server 7.0.16.6.0 and Oracle server 7.3.3 on a sparc server 1000. My problem is that I need to copy or move a database from the older oracle server version to the newer one. The new database needs to be in place without disturbing the old one. Oracle export and import utilities are of no value as interrogation of the produced export file shows hard coded directory paths for each datafile etc... I guess my question to you is, can I follow the same procedure you have outlined in your response below and will there be any impact or issues because of the different versions of oracle involved.

Thanks for any help or assistance.

Regards

Tony Ferrazzo
tferrazz_at_vttsvic1.telecom.com.au

Robert Prendin wrote:

> 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
>
Received on Thu Dec 18 1997 - 00:00:00 CST