Re: move data from Production to test database everyday
From: michael ngong <mngong_at_yahoo.com>
Date: 5 Mar 2003 12:16:24 -0800
Message-ID: <ecf365d5.0303051216.1e3f1b42_at_posting.google.com>
Date: 5 Mar 2003 12:16:24 -0800
Message-ID: <ecf365d5.0303051216.1e3f1b42_at_posting.google.com>
oraclehyd_at_yahoo.com (oraclehyd) wrote in message news:<fc615b88.0303031415.619f313d_at_posting.google.com>...
> 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.
A standby with manual application of logs seems like something
you might want to consider.Do the application of logs nightly when
the system is probably not very busy
Michael Tubuo Ngong
Received on Wed Mar 05 2003 - 21:16:24 CET