From: Sybrand Bakker <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Moving redo logs
Date: Thu, 26 Apr 2001 18:49:41 +0200
Message-ID: <l8kget0vcgqslftkecuds9mihfmv7qnm0k@4ax.com>
Reply-To: postbus@sybrandb.demon-verwijderdit.nl
References: <9c9hqh$ddr$1@plutonium.btinternet.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@nl.demon.net
NNTP-Posting-Host: sybrandb.demon.nl
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
X-Trace: beta-news.demon.nl 988303652 beta-news:71205 NO-IDENT sybrandb.demon.nl:212.238.21.78
Lines: 38


On Thu, 26 Apr 2001 17:19:27 +0100, "Steve Rainbird"
<steve.rainbird@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