RE: Data Guard Apply lag

  • From: "GovindanK" <gkatteri@xxxxxxxxxxx>
  • To: Brandon.Allen@xxxxxxxxxxx, mr.hicken@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 05 Mar 2007 10:40:50 -0800

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@xxxxxxxxxxx> 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
>  
> 
--
//www.freelists.org/webpage/oracle-l


Other related posts: