HDR - Sync secondary manually

Hi All, IDS 10.00.FC8 RHL AS4 (2.6.9-42.ELsmp, gcc version 3.4.6 20060404) Few questions on HDR (apology for little understanding on HDR): DRINTERVAL=300 NOFUZZYCKPT=1 1) Will block/unblock on primary (onode -c block/unblock) sync data on secondary OR the buffers are not sent until the buffer pool is full or DRINTERVAL has been reached? 2) Will force checkpoint "onmode -c" sync the data on secondary? 3) While HDR is up & running, Is it possible to block/unblock secondary using onmode -c block/unblock? 4) Is there any command (other than step 1 & 2 above) to sync secondary manually? TIA Stay connected to the people that matter most with a smarter inbox. Take a look http://au.docs.yahoo.com/mail/smarterinbox

- "onmode -c" should force a ckpt which will I believe will sync to the secondary immediately. - by default, no fuzzy checkpoints with HDR. - do not know the answer to the block / unblock questions Bob ----- Original Message ----- From: "H.G" <hariog@yahoo.com> To: ids@iiug.org Sent: Wednesday, January 28, 2009 1:56:50 AM GMT -05:00 US/Canada Eastern Subject: HDR - Sync secondary manually [14651] Hi All, IDS 10.00.FC8 RHL AS4 (2.6.9-42.ELsmp, gcc version 3.4.6 20060404) Few questions on HDR (apology for little understanding on HDR): DRINTERVAL=300 NOFUZZYCKPT=1 1) Will block/unblock on primary (onode -c block/unblock) sync data on secondary OR the buffers are not sent until the buffer pool is full or DRINTERVAL has been reached? 2) Will force checkpoint "onmode -c" sync the data on secondary? 3) While HDR is up & running, Is it possible to block/unblock secondary using onmode -c block/unblock? 4) Is there any command (other than step 1 & 2 above) to sync secondary manually? TIA Stay connected to the people that matter most with a smarter inbox. Take a look http://au.docs.yahoo.com/mail/smarterinbox ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H.G > Sent: Wednesday, January 28, 2009 12:57 AM > To: ids@iiug.org > Subject: HDR - Sync secondary manually [14651] > > Hi All, > > IDS 10.00.FC8 > RHL AS4 (2.6.9-42.ELsmp, gcc version 3.4.6 20060404) > > Few questions on HDR (apology for little understanding on HDR): > > DRINTERVAL=300 > NOFUZZYCKPT=1 > > 1) Will block/unblock on primary (onode -c block/unblock) sync data on > secondary OR the buffers are not sent until the buffer pool is full or > DRINTERVAL has been reached? Yes > > 2) Will force checkpoint "onmode -c" sync the data on secondary? , but-- From the manual: How the Log Records Are Sent As shown in Figure 20-4 on page 20-9, when the primary database server starts to flush the contents of the logical-log buffer in shared memory to the logical log on disk, the database server also copies the contents of the logical-log buffer to a data-replication buffer on the primary database server. The primary database server then sends these logical-log records to the secondary database server. The secondary database server receives the logical-log records from the primary database server into a shared-memory reception buffer (which the database server automatically adjusts to an appropriate size for the amount of data being sent). The secondary database server then applies the logical-log records through logical recovery. HDR Buffers The HDR buffers are part of the virtual shared memory that the primary database server manages. The HDR buffers hold logical-log records before the primary database server sends them to the secondary database server. The HDR buffers are the same size as the logical-log buffers. Figure 20-4 shows this concept. So, unless you have LOGBUFF set very high, even if you have a huge DRINTERVAL, the servers will be closely paired. If that isn't sufficient for you, set your DRINTERVAL to -1 and force the primary to write to the secondary at exactly the same time it writes its own log. > > 3) While HDR is up & running, Is it possible to block/unblock secondary > using > onmode -c block/unblock? The commands work, but I don't think they actually do anything on a secondary. > > 4) Is there any command (other than step 1 & 2 above) to sync secondary > manually? Maybe a better question is, "Why do you want to sync the servers manually?" Maybe you should consider just reducing your DRINTERVAL or setting it to -1. > > TIA > > Stay connected to the people that matter most with a smarter inbox. Take a > look http://au.docs.yahoo.com/mail/smarterinbox > > > ************************************************************************ ** > ***** > Forum Note: Use "Reply" to post a response in the discussion forum.

OK, first, read the Administrator's Guide section on HDR. Here's a quick guide: - HDR is constantly updating the secondary - Each time a logical log buffer fills and is flushed to the current local logical log file it is also copied to the HDR buffer to be sent to the secondary (or multiple secondaries in 11.10 or later). - The HDR buffer is either sent to the secondary immediately if DRINTERVAL is set to 0 or -1 or sent every DRINTERVAL seconds. (DRINTERVAL -1 blocks the committing transaction, if the buffer contains a COMMIT record, until the commit is processed on the secondary. DRINTERVAL 0 does not.) Answers to your specific questions inline below: On Wed, Jan 28, 2009 at 1:56 AM, H.G <hariog@yahoo.com> wrote: > Hi All, > > IDS 10.00.FC8 > RHL AS4 (2.6.9-42.ELsmp, gcc version 3.4.6 20060404) > > Few questions on HDR (apology for little understanding on HDR): > > DRINTERVAL=300 > NOFUZZYCKPT=1 > > 1) Will block/unblock on primary (onode -c block/unblock) sync data on > secondary OR the buffers are not sent until the buffer pool is full or > DRINTERVAL has been reached? I think this is mostly covered above. BLOCK/UNBLOCK does not specifically cause HDR activity except in that the transaction flushing that HDR replicates does not occur while the engine it blocked. > > > 2) Will force checkpoint "onmode -c" sync the data on secondary? It will force the current logical log buffer to be flushed to disk and to the replication buffer and it will force the replication buffer to be sent to the secondary. Following that a checkpoint will be forced on the secondary just like any other checkpoint on the primary. > > 3) While HDR is up & running, Is it possible to block/unblock secondary > using > onmode -c block/unblock? No, and there is no need to. The block/unblock is used to archive the server and you cannot take an archive on the secondary in v 10.00. > > 4) Is there any command (other than step 1 & 2 above) to sync secondary > manually? No. Not needed as synching is continuous, though not immediate - depending on DRINTERVAL. That said, forcing a checkpoint on the primary, as in your second question above, will bring the secondary up-to-date if DRINTERVAL is set to a positive value (it's really always up-to-date if set to zero or minus one.) Art > > > TIA > > Stay connected to the people that matter most with a smarter inbox. Take a > look http://au.docs.yahoo.com/mail/smarterinbox > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --001636c5a72e1b4cc604618d1acd

ids-bounces@iiug.org wrote on 01/28/2009 12:56:50 AM: > [image removed] > > HDR - Sync secondary manually [14651] > > H.G > > to: > > ids > > 01/28/2009 12:57 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hi All, > > IDS 10.00.FC8 > RHL AS4 (2.6.9-42.ELsmp, gcc version 3.4.6 20060404) > > Few questions on HDR (apology for little understanding on HDR): > > DRINTERVAL=300 > NOFUZZYCKPT=1 > > 1) Will block/unblock on primary (onode -c block/unblock) sync data on > secondary OR the buffers are not sent until the buffer pool is full or > DRINTERVAL has been reached? since checkpoint is always synchronized between HDR Primary and Secondary,. onmode -c will force the data sync. > > 2) Will force checkpoint "onmode -c" sync the data on secondary? > > 3) While HDR is up & running, Is it possible to block/unblock secondary using > onmode -c block/unblock? No. checkpoint can be initiated at primary only. > > 4) Is there any command (other than step 1 & 2 above) to sync secondary > manually? No, set DRINTERVAL to -1 to ensure synchronous updates to secondary. > > TIA > > Stay connected to the people that matter most with a smarter inbox. Take a > look http://au.docs.yahoo.com/mail/smarterinbox > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >