Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Guard Apply lag
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/log_arch_dest_param.htm#82634
Example log_archive_dest_2="SERVICE=tns_entry_here ARCH NOAFFIRM OPTIONAL REOPEN=seconds"
Which version/platform is this problem occuring?
HTH
GovindanK
On Mon, 5 Mar 2007 10:32:13 -0700, "Allen, Brandon"
<Brandon.Allen_at_OneNeck.com> said:
> Can't recall the exact parameter off the top of my head, but there is
> one that can be set to intentionally force a delay on the application of
> logs to the standby. It is done to give you a chance to prevent logical
> corruption/user error (e.g. accidental drop/delete) from being
> propagated to the standby if you desire to do so. You might want to
> look up the parameter and confirm if it's set or not. If that's not the
> cause, then check the wait events for the log apply session and see
> where it's spending it's time.
>
> Regards,
> Brandon
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 05 2007 - 12:40:50 CST
![]() |
![]() |