Re: move data from Production to test database everyday
From: Robert Fazio <dbabob_at_hotmail.nospam.com>
Date: Sun, 16 Mar 2003 05:43:17 GMT
Message-ID: <Xns9340757355Edbabobhotmailcom_at_204.127.204.17>
>> Hi,
>>
>> How to move data from live production database which is huge in size
>> (let us say 100GBs) to test database everyday. Export and import
>> would be the worst tool. I guess it would be backup and recovery with
>> Rman. But anyone can give out some steps or procedures to do it. I
>> will appreciate all help.
>
Date: Sun, 16 Mar 2003 05:43:17 GMT
Message-ID: <Xns9340757355Edbabobhotmailcom_at_204.127.204.17>
Frank <fvanbortel_at_netscape.net> wrote in news:3E6661B9.9080805 _at_netscape.net:
> oraclehyd wrote:
>> Hi,
>>
>> How to move data from live production database which is huge in size
>> (let us say 100GBs) to test database everyday. Export and import
>> would be the worst tool. I guess it would be backup and recovery with
>> Rman. But anyone can give out some steps or procedures to do it. I
>> will appreciate all help.
>
Another option is advanced replication, but the easiest way is with a something like EMC's timefinder or an equivalent tool. This takes a snapshot of the database on disk and duplicates it.
As far as Rman, it would just be a restore of the database to another system. I would suggest though that you create a copy of your catalog also. That way it doesn't think that you restored the database that you are backing up. Received on Sun Mar 16 2003 - 06:43:17 CET