Re: redo log question...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 15 Aug 2000 20:55:26 +0200
Message-ID: <966402537.15729.0.pluto.d4ee154e@news.demon.nl>

You can't resize redo logfiles. You need to use add and drop like you already outlined below.
I usually do the following
check which redo log groups are not in use by selecting from v$log. If the redolog group I want to drop is in use then
alter system switch logfile;

alter database drop logfile group <n>
alter database add logfile group <n>

and so on. So I actually reuse the group numbers. Four times 5M should for a start indeed be sufficient. Check the frequency of your switches in v$loghistory.

Hth,

Sybrand Bakker, Oracle DBA

"gdas" <gdas1NOgdSPAM_at_yahoo.com.invalid> wrote in message news:1042c254.599c72eb_at_usw-ex0101-006.remarq.com...
> 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
>
>
> -----------------------------------------------------------
>
> 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 - 13:55:26 CDT