Re: Online redo logfiles

From: Darren Smith <dsmith_at_nospamming.au.oracle.com>
Date: Sat, 23 Oct 1999 14:51:47 +0800
Message-ID: <38115B03.44C51375@nospamming.au.oracle.com>

You cant enlarge them,

what you do is

ALTER DATABASE ADD LOGFILE
'?PATH TO NEW LOGFILE>' SIZE ?SIZE YOU WANT> ; Create the size and number of logfiles that you want

Find out which logfile is currently active:

select a.group# , a.member , b.status , b.bytes from v$logfile a , v$log b
where a.group# = b.group#;

Switch logfiles till you are current on the new logfiles

alter system switch logfile;

then drop your old logfiles

alter database drop logfile '?path of logfile>';

Hope this helps....

Darren

querix_at_my-deja.com wrote:

> I want to enlarge the size of the online redo logfiles. Can I do it
> with the 'alter database' command in a direct way?
> How?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Oct 23 1999 - 01:51:47 CDT