Re: redo log question...

From: Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid>
Date: Tue, 15 Aug 2000 13:21:40 -0700
Message-ID: <05860470.fbf348cf@usw-ex0102-015.remarq.com>

gdas <gdas1NOgdSPAM_at_yahoo.com.invalid> wrote:
>I'm new to this partically area...I have a database created and
>I would like to increase the redo log 'space'. Currently there
>are 4 redo log groups with each group having a size of 1024K.
>
>I can add more log files using the command "ALTER DATABASE ADD
>LOGFILE ..."
>
>Should I just do that, or does it make sense to resize the
>existing redo files? My goal is to have ~20M of redo space.
>
>If I should resize the existing files. Can anyone provide me
>with the details for how I should go about doing this?
>
>Thanks in advance.
>Gavin
>

Wait until your first group is not the current log and has been archived then drop it, remove the files at the OS level, and add the group back at the new size. Repeat process for each remaining group. You can force a redo log switch with the alter system switch logfile command.

Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice. --

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Tue Aug 15 2000 - 15:21:40 CDT