Re: ** logical standby data changes apply

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_at_xs4all.nl> 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.
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l


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

--
http://www.freelists.org/webpage/oracle-l