RE: Order of Redo log use

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Fri, 21 Feb 2003 06:14:03 -0800
Message-ID: <F001.00554329.20030221061403@fatcity.com>

Jared,
No they do not have to begin with 1 and in fact my 10 groups are currently 11 - 20. I too have rearranged/reorg'ed redo logs while the database was up. Mostly with success, but in one case linesize was too short when I built my script and production (V7.3) was briefly left with only one redo log. It also seems that my current conundrum is due to insufficient controls while adding new redo log groups to a live database in the past.

Downtime is mostly for segment/tablespace reorg (no, not to compress extents ;-) ).

Mike

-----Original Message-----
Sent: Thursday, February 20, 2003 4:02 PM To: Multiple recipients of list ORACLE-L

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

--

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 Fri Feb 21 2003 - 08:14:03 CST