Thanks Thorsten. works like treat..
Thorsten Jens wrote:
> extents wrote:
>
> > Suppose I have a production database with redo log size of 50MB.
> > Generally we have about 3-4 log switches a day. There are days we have
> > 50-60 log switches a day. Using data guard how do I ensure that the
> > standby database is always not less than 1 hour behind the production?
> > What I mean is on any given day we wont lose more than 1 hours of data.
>
> Have a look at the archive_lag_target parameter.
>
> Thorsten
Received on Thu Aug 03 2006 - 06:17:22 CDT
