Re: Copy Prdoduction database to Test database on different machine

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 05 Feb 2004 17:39:05 -0800
Message-ID: <UeCUb.30937$P17.25569@fed1read03>

Herman Pool wrote:
> Hi all,
>
> I want to make a copy of the production database to a different
> machine and then reload the database for testing purpose.
> This must be done during the night when nobody is on the production
> system.
>
> On both machines:
> OS: Linux RH 8.0
> Oracle: 9.2.0.1
> Same directory structure.
>
> Which steps do I have to take or which scripts do I have to run?
>
> With kind regards,
>
> Herman Pool

Make sure both DBs are shutdown.
Launch a bunch of "rcp" commands to copy all the necessary files from production to test system.
Startup both DBs.

I do this almost weekly or so it seems to me. Received on Thu Feb 05 2004 - 19:39:05 CST