Re: Data Guard Apply lag

Do you have a delay for log transportation process or log apply process. If
it is about transportation maybe this calculation would give you an idea.

if it is about the applying process try to calculate from the formula below
and take action if you network is not satisfying for transportation process(
*Note:241925.1*);

Using a formula that allows for 30% network overhead and the known redo
rate, validate that your network bandwidth is sufficient to support the redo
rate. For example if we know the redo rate is 500 K/sec, then the following
calculation would be done:**

Required bandwidth
= ((Redo rate in bytes ps / .7) * 8) / 1,000,000
= bandwidth in Mbps

= ((500 * 1024) / .7) * 8) / 1,000,000

= 5.85 Mbps



Thus, in this example a 10 Mbps network or a T3 network (44.736 Mbps )
should have plenty of bandwidth whereas a T1-DS1 network (1.544 Mbps) would
not be sufficient for this redo rate. Also playing into this capacity is
what else is using this link.



If it is about the delay for applying process then maybe you should try to
parellize the applying process by clause below

"alter database recover managed standby database parallel X disconnect "

i think value of X was
max(X)=number_of_cpu*2


another option is Set DB_BLOCK_CHECKING=FALSE for Faster Redo Apply Rates

and another one Set PARALLEL_EXECUTION_MESSAGE_SIZE = 4096


also if you do not have async i/o  increasing db_writer process will help
you

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#i1033033









On 3/5/07, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:


DELAY is the parameter I was talking about - here is the link and
example from further down on the same page as the link you sent:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/log_
arch_dest_param.htm#77475

LOG_ARCHIVE_DEST_3='SERVICE=stby1 DELAY=240'
LOG_ARCHIVE_DEST_STATE_3=ENABLE


-----Original Message-----
From: GovindanK [mailto:gkatteri@xxxxxxxxxxx]

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

Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions
and other information in this message that do not relate to the official
business of this company shall be understood as neither given nor endorsed
by it.

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






--
A. Coskan GUNDOGAR

Other related posts: