Re: Recreating Oracle environment

Hi Omar,

I have never done it, but in theory it should be possible to copy the images and recreate the control file.
Issue an alter database backup control file to trace before you start. This trace file will end up in the background_dump_dest directory of the production database. Make any necessary changes, copy the files, startup nomount of the new instance, create controlfile from the script you just generated (not overwriting the old one of course) and that should be it. Assuming of course all files are of the same size.

Hth,

Sybrand Bakker, Oracle DBA

Omar Gillani wrote:

> Greetings Folks: What is the best method for recreating a production
> Oracle environment to a test Oracle environment? Assuming we cannot do
> a backup/restore of a production machine, what would be the best
> method? Are Export and Import the only options, or can we do an
> image-copy? Is there a utility in Oracle to do an image-copy? If we
> were to do an Export and then an Import, we have to pre-define the DB
> structure on the test machine and then perform the import? Thanks in
> advance for any and all help. Regards, Omar

Received on Wed Mar 17 1999 - 23:44:24 CST