Re: How to resize redo logs

From: Andrew Pahomov <Pahomov_at_validio.com.ua>
Date: Fri, 2 Feb 2001 10:37:35 +0200
Message-ID: <3a7a71d0$1@miik2-ilt.ilt.kharkov.ua>

SELECT group#, bytes, members FROM sys.v_$log

Create new log

ALTER DATABASE ADD LOGFILE GROUP 3 ('ORACEL_HOME\ORADATA\SID\REDO03.LOG') SIZE 5M
and any,
drop old logs group
ALTER DATABASE DROP LOGFILE GROUP 6;
if they not drop : ALTER SYSTEM SWITCH LOGFILE;

<MAbbouchi_at_IITRI.ORG> wrote in message
news:DD42667CBCE4D3119D0700104B95123F3016CA_at_abmail.iitri.org...
> How to resize redo logs and is there a special consideration to be aware
of?
>
> Thanks
> Mo
>
> --
> Posted from nat05.IITRI.ORG [205.167.170.5]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Feb 02 2001 - 02:37:35 CST