Re: ** logical standby data changes apply

  • From: A Joshi <ajoshi977@xxxxxxxxx>
  • To: cjpengel.dbalert@xxxxxxxxx
  • Date: Mon, 16 May 2005 12:55:20 -0700 (PDT)

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' 
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.
> --


Yahoo! Mail
 Stay connected, organized, and protected. Take the tour


Other related posts: