RE: Frequency of Log Switches

From: Kieran Murray <Kieran.Murray_at_esat.com>
Date: Thu, 30 Nov 2000 09:42:16 -0000
Message-Id: <10696.123298@fatcity.com>

Steven,

try changing the initialization parameter LOG_CHECKPOINT_TIMEOUT to be 900 and set the LOG_CHECKPOINT_INTERVAL to be a very high value (greater than the size of the redo logs),
this will cause log switches every 15 minutes or when the log file is full. Both of these values can
be dynamically altered using ALTER SYSTEM.

Regards,
Kieran Murray
Norkom Technologies,
43 Upper Mount Street, Dublin 2, Ireland Tel:- +353 86 8117916

-----Original Message-----
From: Steven Monaghan [mailto:MonaghaS_at_mscdirect.com] Sent: 29 November 2000 22:03
To: Multiple recipients of list ORACLE-L Subject: Frequency of Log Switches

I know that the recommended optimal log switch interval is 30 minutes, and our log sizes of 20Mb average a little less than that. Now that I am looking to implement a standby database, my users have a requirement that no more than 15 minutes of data should be lost if we need to fail over to standby. I was looking through the Oracle 8 reference (we are running 8.0.5 on SunOS 5.6) and I could not find one that would force a log switch based on time, not size. Is there one, or do I need to create a script that simply forces a log switch every 15 minutes?

TIA,

Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
MonaghaS_at_mscdirect.com
http://www.mscdirect.com

This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any copies of it. Thank you.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steven Monaghan
INET: MonaghaS_at_mscdirect.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

http://www.marketplace.ie
Ireland's Home for eBusiness

Received on Thu Nov 30 2000 - 03:42:16 CST