Order of Redo log use

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Thu, 20 Feb 2003 10:34:04 -0800
Message-ID: <F001.00553305.20030220103404@fatcity.com>

Ok, I'm working on a 8.1.7 Tru64 system with 10 groups of redo logs with 2 members; 5 groups on each of 2 mount points. I've finally taken a close look at the order each group is used and I'm not happy. Four of the 10 switches are between redo logs on the same mount point. Now I'm not sure when this happened since this database has been around for many years and the number of groups and the size of the redos have increased, and the 2nd members were added. Now I have down time to correct this over the weekend. I know I can just leave the order the groups are used as is and move/rename the underlying redo logs, but I'd rather have all of the even-numbered groups on one mount point and the odd groups on the other. So is this as easy as dropping (except for the active one) and recreated in the order I want them used or is there other factors. For that matter, when new groups are added how are they merged into the order groups are used. Another few points I found is that the default order of group# in V$LOGFILE does not correspond to the order used, and RESETLOGS does not affect the order of group used either. If this is a RTMF let me know that too.

Thanks,
Mike Hand
Polaroid Corp

This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
--

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 - 12:34:04 CST