Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recreating Oracle environment
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