Re: ** logical standby data changes apply
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: ajoshi977@xxxxxxxxx
- Date: Mon, 16 May 2005 23:34:41 +0200
Nope.
In 10g you can use direct apply. For Logical Standby this can be
achieved using the command ALTER DATABASE START LOGICAL STANDBY APPLY
IMMEDIATE. But that's of no help for you now.
In 9i the only thing that comes near is archive_lag_target. Setting this
to e.g. 120 will cause a log switch every two minutes. Of course that
has its own donwsides, you should make a careful tradeoff what value is
appropriate. I had one customer logswithing every 60 seconds, but they
only had very few transactions.
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Mon, 2005-05-16 at 21:55, A Joshi wrote:
> Hi Carel : Version is 9i. So are you saying there is no way to make it apply
> redo log before log switch? Thanks
> Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx> wrote:For 9i this is
> 'documented' behaviour.
> What version are you on?
>
> Best regards,
>
> Carel-Jan Engel
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>
> On Mon, 2005-05-16 at 20:45, A Joshi wrote:
>
> > Hi,
> >
> > I have setup a logical standby database and data from primary is going to
> > standby. I have setup the log archive location for standby to use LGWR and
> > it seems to be writing to standby site. However it is not applying the redo
> > log immediately. It seems to be waiting for the log switch to apply the
> > log. So there is delay between primary and secondary. I would like to have
> > the standby updated immediately without waiting for log switch. Is there
> > some setting I am missing. The manual does talk about log transport
> > services and specifies how to transport redo log instead of archive log. I
> > did not find anything related to applying redo log as they come. So I do
> > not know if it is possible. Or if there are ways to make it happen. One way
> > would be to have frequent log switch but that would create other issues. So
> > apart from forcing very frequent log switches is there a way workaround?
> >
> > Thanks for your help.
> >
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! Mail Mobile
> > Take Yahoo! Mail with you! Check email on your mobile phone.
> >
> > --
> > //www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> ---------------------------------
> Yahoo! Mail
> Stay connected, organized, and protected. Take the tour
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
