Re: Moving redo logs

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 26 Apr 2001 18:49:41 +0200
Message-ID: <l8kget0vcgqslftkecuds9mihfmv7qnm0k@4ax.com>

On Thu, 26 Apr 2001 17:19:27 +0100, "Steve Rainbird" <steve.rainbird_at_mssint.com> wrote:

>I have to reconfigure one of our NT databases so that its redo logs are not
>all on the same disk.
>
>Is this easy?
>
>I have looked at the documentation and as usual find it a little confusing.
>
>Any help would be appreciated.
>
>Thanks.
>
>Steve Rainbird
>Principal consultant
>MSS International Ltd.
>www.mssint.com
>
>
>

general scenario
select * from v$log will show you which logfile group you can drop (the inactive ones!)
so
alter database drop logfile group <N>
followed by
alter database add logfile group (<filename>,...) size [at least 5] M should do the trick
you can bump the logfile by
alter system switch logfile
and/or
alter system checkpoint

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Apr 26 2001 - 11:49:41 CDT