Re: Recreating Oracle environment

Omar,

A simple solution if you can't backup/restore....

• Shutdown Oracle
• FTP files over to your production server (you might wan't to compress)
• Restart your development database
• Start your production database.

This assumes both server have exactly the same directory structures.

Regards,

Marc Mazerolle

Stephane Faroult wrote:

> 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
>
> I have a script named dbcopy which does it. Needs to be adapted, because
> it assumes a number of client-specific things about the way Unix
> directories are organized but it can be a good base for you to work on.
> Can you e-mail me a reminder at stephane.faroult_at_ota.fr.socgen.com ?
> Can send it to you tomorrow.
> --
> Regards,
>
> Stéphane Faroult
> Oriole Corporation
> -------------------------------------------------------------------
> http://www.oriolecorp.com, created by Oracle DBAs for Oracle DBAs
> -------------------------------------------------------------------
Received on Thu Mar 18 1999 - 14:36:09 CST