| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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,
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. Received on Wed Nov 29 2000 - 15:04:34 CST
 |
 |