| 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
Mike,
Is there any reason your redo logs must begin with 1?
You don't need to take the database down to do this, just start with a higher number.
Or, if you insist on consecutive numbers starting with 1, just create a temp set of redo, drop the old ones, recreate them, then drop the temp set.
I've done this a few times to resize/reorg redo on disk without taking the database down.
Jared
"Hand, Michael T" <HANDM_at_polaroid.com>
Sent by: root_at_fatcity.com
02/20/2003 10:34 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Order of Redo log use
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Jared.Still_at_radisys.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 - 15:02:22 CST
 |
 |