Re: Duplicating database

Steven Egberghs wrote:
>
> Oracle 7.3
> AIX 7.1
>
> Suppose we have two identical database ( one production and one test ).
> They were created with the same script, except for the instance name and
> db-location
>
> Which files am I allowed (or not ) to copy from one to another.
>
> I suppose
> OK : all the dbf-files
> NOK : the controlfile
>
> ?? Do the need to be in NOARCHIVELOG ??
>
> Thanks
> Steven

You can copy the datafiles and the online redo log files. You should not copy the control files. From the original database, use the command ALTER DATABASE BACKUP CONTROLFILE TO TRACE to build a text file that will recreate the control file. Edit that text file to change the database name from production to test, and to change the file locations to the test database locations. Startup nomount the database and run the text file to recreate the control file and rename the database.

We do this a lot.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com