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