Re: dataguard over high latency links

From: ORA600 <panandrao_at_gmail.com>
Date: 26 Jan 2006 00:41:27 -0800
Message-ID: <1138264887.136440.158850@o13g2000cwo.googlegroups.com>

There are couple of decent Data Guard Best Practices as well...on OTN. just search for it and it gives some interesting ideas.

I had implemented 9205 Data Guard (Physical) over a WAN... max performance mode and it almost worked well except when there was too much redo generation on the primary side.

we used ARCH as the "transporter"

we had to use _log_archive_callout={LOCAL_FIRST=TRUE} ...can't remember the exact syntax. please do check.

this is to ensure that Oracle first writes the local online redolog, archives it locally and then attempts to send it across the network. This avoids situations where the redo is too fast on the primary and local ARCH process cannot archive it fast enough, then with a slow network it can't send the archived log file across. This causes a hang on the primary.

check the whitepapers, they have enough information.

Which version of Oracle is it?

ORA600 Received on Thu Jan 26 2006 - 02:41:27 CST