| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Order of Redo log use
Dennis,
The redo log members as well as the controlfiles, are seperated as best at the environment allows, on different stripe sets. In general it is relatively robust using ADVfs & LSM mirroring. Redo log size is OK in my view, currently ~40 switches daily with 2 or 3 switches at 3-4 minutes intervals. It appears that I must have added new groups on more than one occasion with the active group at different points. Should be straighted out this weekend.
Mike Hand
Polaroid Corp.
-----Original Message-----
Sent: Thursday, February 20, 2003 2:48 PM
To: Multiple recipients of list ORACLE-L
Michael
The reason to use multiple members in each group is so each member can be on a different device (that is device, not just a separate mount point on the same device). Then if a terrorist sprays your computer room with automatic gunfire (or a drive crashes), maybe one of the devices will be spared. Remember that Oracle can easily rebuild data files. Redo logs and control files are the precious commodity. While you are at it, make sure you have two control files on separate devices. I am paranoid so I always configure three control files.
So you need to relocate the second member of each redo log group so both aren't on the same device. Make sure they are all the same size. Evaluate whether you need to make them larger while you are at it. How often does log file switch occur during peak load?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hand, Michael T
INET: HANDM_at_polaroid.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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). Received on Thu Feb 20 2003 - 14:44:12 CST
 |
 |