Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Guard Apply lag

RE: Data Guard Apply lag

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Mon, 05 Mar 2007 10:40:50 -0800
Message-Id: <1173120050.3323.1177829075@webmail.messagingengine.com>

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-l
Received on Mon Mar 05 2007 - 12:40:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US